$value) { $$key = $value; } if ($a =='Apply'){ $v = verifyForm(); if ($v == 1) { insert_data($conn); ?>

"; echo advertjobs(); } ?>

:: Application History

"; $get_rs = OCIParse($conn, $get_jobs); OCIExecute($get_rs); if(!$get_rs) { $norec=""; } $bcolor="#FFFFFF"; $x=0; while (OCIFetchInto($get_rs,$get_row, OCI_ASSOC)) { $x=$x+1; if($bcolor == "#FFFFFF") { $bcolor="#F4F4F4"; } else { $bcolor="#FFFFFF"; } $CSS_JOB_ID=$get_row["CSS_JOB_ID"]; $adver=$get_row["CSS_ADVERTISEMENT_ID"]; $CSS_DATE=$get_row["CSS_DATE"]; $eexp=explode("12.",$CSS_DATE); $CSS_DATE=$eexp[0]; $CSS_JOB_TITLE=$get_row["CSS_ADVERTISEMENT_NO"]; $PYEAR=$get_row["PYEAR"]; $temp.=" "; if($CSS_ADVERT_ID == $adid) { $ch="checked"; } else { $ch=""; } $temp.=""; } $temp.="$norec

CSS Advertisements Application History
Serial. No	CSS Advertisement No	Apply Date	Optional Subjects	Occupational Groups	Print Preview
No Record Found
".$x."	".$CSS_JOB_TITLE."	".$CSS_DATE."	View	View	Print View

"; return $temp; } function displayJobTitle($jobId){ return ""; } function jobsdetail() { global $conn,$jobid; $jobid=$_GET["jobid"]; $det_jobs="select j.CSS_JOB_TITLE,j.CSS_JOB_VACANCIES,j.CSS_JOB_EXP,j.CSS_JOB_GRADE, m.MINISTRY_NAME,j.CSS_JOB_DEPT,j.CSS_JOB_MAX_AGE,c.CITY_NAME,trim(to_char(j.CSS_JOB_POST_DATE,'YYYY')) as PYEAR, trim(to_char(j.CSS_JOB_CLOSE_DATE,'DD')) || '-' || trim(to_char(j.CSS_JOB_CLOSE_DATE,'MM')) || '-' || trim(to_char(j.CSS_JOB_CLOSE_DATE,'YYYY')) as CDATE from CSS_JOB_POST j, CSS_MINISTRIES m, CSS_CITY c where j.CSS_JOB_PLACE=c.CITY_ID and j.CSS_JOB_MINISTRY=m.MINISTRY_ID and j.CSS_JOB_ID=$jobid"; //echo $det_jobs; exit; $temp=""; $det_rs = OCIParse($conn, $det_jobs); OCIExecute($det_rs); OCIFetchInto($det_rs,$det_row, OCI_ASSOC); $CSS_JOB_TITLE=$det_row["CSS_JOB_TITLE"]; $MINISTRY_NAME=$det_row["MINISTRY_NAME"]; $CSS_JOB_DEPT=$det_row["CSS_JOB_DEPT"]; $CSS_JOB_MAX_AGE=$det_row["CSS_JOB_MAX_AGE"]; $CITY_NAME=$det_row["CITY_NAME"]; $CSS_JOB_VACANCIES=$det_row["CSS_JOB_VACANCIES"]; $CSS_JOB_EXP=$det_row["CSS_JOB_EXP"]; $CSS_JOB_GRADE=$det_row["CSS_JOB_GRADE"]; $CDATE=$det_row["CDATE"]; $PYEAR=$det_row["PYEAR"]; $dept_sql="select CSS_DEPARTMENT_NAME from CSS_MIN_DEPT where CSS_DEPARTMENT_ID=$CSS_JOB_DEPT"; $dept_rs = OCIParse($conn, $dept_sql); OCIExecute($dept_rs); OCIFetchInto($dept_rs,$dept_row, OCI_ASSOC); $CSS_DEPARTMENT_NAME=$dept_row["CSS_DEPARTMENT_NAME"]; $temp.=""; echo $temp; } function ViewApplicantDetail1(){ global $conn,$userId; $temp=""; $aid=$_GET['userId_d']; //echo $aid; exit; if ($aid>0){ $display_sql= "select * from CSS_APP_GENERAL where CSS_APPLICANT_ID=$aid"; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); $CSS_islamiat=$row_display["CSS_ISLAMIAT_EXCEPTION"]; if(strlen($CSS_islamiat)==0) $CSS_islamiat='No'; else $CSS_islamiat='Yes'; $CSS_APPLICANT_ID=$row_display["CSS_APPLICANT_ID"]; $CSS_APPLICATION_ID=$row_display["CSS_APPLICATION_ID"]; $CSS_APPLICANT_NAME=$row_display["CSS_APPLICANT_NAME"]; $CSS_FATHER_NAME=$row_display["CSS_FATHER_NAME"]; $CSS_SPOUSE_NAME=$row_display["CSS_SPOUSE_NAME"]; $CSS_SPOUSE_NATIONALITY=$row_display["CSS_SPOUSE_NATIONALITY"]; $CSS_NATIONALITY_STATUS=$row_display["CSS_NATIONALITY_STATUS"]; $CSS_APPLICANT_NATIONALITY=$row_display["CSS_APPLICANT_NATIONALITY"]; $PSYCHOLOGICAL_TEST=$row_display["PSYCHOLOGICAL_TEST"]; $PSYCHOLOGICAL_CENTRE=$row_display["PSYCHOLOGICAL_CENTRE"]; $CSS_APPLICANT_MOBILE=$row_display["CSS_APPLICANT_MOBILE"]; $CSS_APP_DISCIPLINE=$row_display["CSS_APP_DISCIPLINE"]; $CSS_SPOUSE_AGE=$row_display["CSS_SPOUSE_AGE"]; $CSS_SPOUSE_EDUCATION=$row_display["CSS_SPOUSE_EDUCATION"]; $CSS_SPOUSE_OCCUPATION=$row_display["CSS_SPOUSE_OCCUPATION"]; $CSS_SPOUSE_DESIGNATION=$row_display["CSS_SPOUSE_DESIGNATION"]; $CSS_OLD_NIC=$row_display["CSS_OLD_NIC"]; $CSS_NEW_NIC=$row_display["CSS_NEW_NIC"]; $CSS_GENDER=$row_display["CSS_GENDER"]; $CSS_MARITAL_STATUS=$row_display["CSS_MARITAL_STATUS"]; $CSS_RELIGION=$row_display["CSS_RELIGION"]; $CSS_DOB=$row_display["CSS_DOB"]; $CSS_AGE_RELAXATION=$row_display["CSS_AGE_RELAXATION"]; $CSS_DOMICILE=$row_display["CSS_DOMICILE"]; $GR_DISTRICT_DOMICILE=$row_display["CSS_DISTRICT_DOMICILE"]; $CSS_APPLICANT_EMAIL=$row_display["CSS_APPLICANT_EMAIL"]; $CSS_APPLICANT_PHONE_OFF=$row_display["CSS_APPLICANT_PHONE_OFF"]; $CSS_APPLICANT_PHONE_RES=$row_display["CSS_APPLICANT_PHONE_RES"]; $CSS_APPLICANT_FAX=$row_display["CSS_APPLICANT_FAX"]; $CSS_POSTAL_ADD1=$row_display["CSS_POSTAL_ADD1"]; $CSS_POSTAL_ADD2=$row_display["CSS_POSTAL_ADD2"]; $CSS_PARMANENT_ADD1=$row_display["CSS_PARMANENT_ADD1"]; $CSS_PARMANENT_ADD2=$row_display["CSS_PARMANENT_ADD2"]; $CSS_CENTER=$row_display["CSS_CENTER"]; $CSS_AGEREX1=$row_display["CSS_AGEREX1"]; $CSS_AGEREX2=$row_display["CSS_AGEREX2"]; $CSS_AGEREX3=$row_display["CSS_AGEREX3"]; $CSS_AGEREX4=$row_display["CSS_AGEREX4"]; $CSS_AGEREX5=$row_display["CSS_AGEREX5"]; $CSS_AGEREX6=$row_display["CSS_AGEREX6"]; $CSS_AGEREX7=$row_display["CSS_AGEREX7"]; $CSS_AGEREX8=$row_display["CSS_AGEREX8"]; /*if($aid!=0){ $jobid=returnfield("select CSS_RECIEPT_ID from CSS_JOB_RECIEPT where CSS_APPLICANT_ID=$aid","CSS_RECIEPT_ID"); if ($jobid!=0){ $postBPS=returnfield("select CSS_JOB_SCALE from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_JOB_SCALE"); $postName=returnfield("select CSS_JOB_TITLE from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_JOB_TITLE"); $ministryId=returnfield("select CSS_JOB_MINISTRY from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_JOB_MINISTRY"); $ministryName=returnfield("select MINISTRY_NAME from CSS_MINISTRIES where MINISTRY_ID=$ministryId","MINISTRY_NAME"); $departmentId=returnfield("select CSS_JOB_DEPT from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_JOB_DEPT"); $deptName=returnfield("select CSS_DEPARTMENT_NAME from CSS_MIN_DEPT where CSS_DEPARTMENT_ID=$departmentId","CSS_DEPARTMENT_NAME"); $advid=returnfield("select CSS_ADVERT_ID from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_ADVERT_ID"); } if ($advid!=0){ $diaryNo=returnfield("select CSS_DIARY_NO from CSS_BATCH_DIARY where CSS_ADVERTISEMENT_ID=$advid","CSS_DIARY_NO"); $batchNo=returnfield("select CSS_BATCH_NO from CSS_BATCH_DIARY where CSS_ADVERTISEMENT_ID=$advid","CSS_BATCH_NO"); $advid=returnfield("select CSS_ADVERTISEMENT_NO from CSS_POST_ADVERTISEMENT where CSS_ADVERTISEMENT_ID=$advid","CSS_ADVERTISEMENT_NO"); } }*/ $query_tr="select * from css_job_reciept where css_applicant_id=$aid"; $query_tr1=OCIParse($conn,$query_tr); OCIExecute($query_tr1); OCIFetchInto($query_tr1,$query_treasury,OCI_ASSOC); $print_date=returnfield("select sysdate as PRINT_DATE from dual","PRINT_DATE"); $rt="select * from DOMICILE where DOMICILE_CODE=$CSS_DOMICILE"; $tt=OCIParse($conn,$rt); OCIExecute($tt); OCIFetchInto($tt,$art,OCI_ASSOC); } } $temp.="

$\"logo\"$

Website: www.fpsc.gov.pk Email: fpsc@fpsc.gov.pk Fax: 051-9213386-9203410

FEDERAL PUBLIC SERVICE COMMISSION
Sector F-5/1, Aga Khan Road,ISLAMABAD

Application Form No

$aid

Print Date:
$print_date

APPLICATION FORM FOR COMPETITIVE EXAMINATION (CE) - 2011

For Official Use Only

To be filled by the Candidate

Please Attach Photograph

Receiving Stamp of FPSC

Application Fee Paid:"; if ($query_treasury['CSS_AMOUNT']>0) { $temp.=" YES"; } else { $temp.=" NO"; } $temp.="
Original Treasury Receipt of Rs. ".$query_treasury['CSS_AMOUNT']."
Treasury No. ".$query_treasury['CSS_TREASURY_NO']."
Date ".$query_treasury['CSS_DATE']."
Bank Name".$query_treasury['CSS_BANK_NAME']."

Batch No.

Diary No.

"; if($GR_DISTRICT_DOMICILE!=0){ $district_name=returnfield("select GR_DISTRICT from DISTRICT where GR_DISTRICT_ID=".$GR_DISTRICT_DOMICILE."","GR_DISTRICT"); } if($aid!=0){ $sql="select CSS_CENTER_ID from CSS_JOB_RECIEPT where CSS_APPLICANT_ID=".$aid." and CSS_ADVERTISEMENT_ID=".$_GET["jid"].""; $center_id=returnfield($sql,"CSS_CENTER_ID"); } if($center_id!=0){ $center_name=returnfield("select CENTER_NAME from CENTER where CENTER_ID=".$center_id."","CENTER_NAME"); } $temp.="

Personal Information

1) Name: (Write in Capital Letters and spell as per your Matriculation Certificate):

".$CSS_APPLICANT_NAME."

2) (a) Father's Name:

".$CSS_FATHER_NAME."

2) (b) Husband's Name (For female married candidates):

".$CSS_SPOUSE_NAME."

3) Date of Birth(Exact As per Matric. Certificate)

".$CSS_DOB."

b) Age on Closing Date

4) (a)Religion

".$CSS_RELIGION."

b)If Non-Muslim, whether desired to be examined in Islamiat

".$CSS_islamiat."

5) (a)Gender

".$CSS_GENDER."

b) Marital Status

".$CSS_MARITAL_STATUS."

6) Postal Address

".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."

7) Permanent Address

".$CSS_PARMANENT_ADD1.", ".$CSS_PARMANENT_ADD2."

8) Particulars about Spouse/Fiancee:-

(a) Age:-

".$CSS_SPOUSE_AGE."

b) Nationality

".$CSS_SPOUSE_NATIONALITY."

".$CSS_SPOUSE_EDUCATION."

d) Occupation:

".$CSS_SPOUSE_OCCUPATION."

9) Examination Centre:

".$center_name."

10) (a)Domicile:

".$art['DOMICILE_NAME']."

b) District of Domicile:

".$district_name."

11) (a)Email:

".$CSS_APPLICANT_EMAIL."

b)Phone Office:

".$CSS_APPLICANT_PHONE_OFF."

(c)Phone Residence:

".$CSS_APPLICANT_PHONE_RES."

d)Mobile No.: ".$CSS_APPLICANT_MOBILE."

12) CNIC No:

".$CSS_NEW_NIC."

13) Relaxation Claimed:

"; if($CSS_AGEREX1==1) $temp.="Not Claimed (Within Age limit)"; if($CSS_AGEREX1==2) $temp.="Govt. Servant including serving in Armed Forces"; if($CSS_AGEREX1==3) $temp.="Armed Forces Released / Retired Commissioned Officer/ Personnel."; if($CSS_AGEREX1==4) $temp.="Schedule Caste"; if($CSS_AGEREX1==5) $temp.="Budhist Community"; if($CSS_AGEREX1==6) $temp.="Azad Kashmir"; if($CSS_AGEREX1==7) $temp.="Northen Areas"; if($CSS_AGEREX1==8) $temp.="Recognized Tribal Areas"; if($CSS_AGEREX1==9) $temp.="Disabled Candidate"; $temp.="

Applicant's Signature

Date

14) Education Record

"; OCIFreeStatement($rs_display); $display_sql= "select * from CSS_APP_EDUCATION where CSS_APPLICANT_ID=$aid order by css_start_date"; //echo $display_sql; exit; $temp14.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display10, OCI_ASSOC); do{ $i=$i+1; $CSS_EXAMINATION=$row_display10["CSS_EXAMINATION"]; $CSS_DATE_RESULT=$row_display10["CSS_DATE_RESULT"]; $CSS_GRADE=$row_display10["CSS_GRADE"]; $CSS_CGP=$row_display10["CSS_CGP"]; $CSS_DIVISION=$row_display10["CSS_DIVISION"]; /* if (strlen($CSS_GRADE)>0) $gdc="Grade=".$CSS_GRADE; if (strlen($CSS_DIVISION)>0) $gdc="Division=".$CSS_DIVISION; if (intval($CSS_CGP)>0) $gdc="CGP=".$CSS_CGP; echo $gdc; */ if (strlen($CSS_GRADE)>0) $gdc="Grade:".$CSS_GRADE; if ($CSS_DIVISION!='NULL') $gdc="Div:".$CSS_DIVISION; if (intval($CSS_CGP)>0) $gdc="CGP:".$CSS_CGP; //echo $gdc; $CSS_UNIVERSITY_ID=$row_display10["CSS_UNIVERSITY_ID"]; $CSS_BOARD_OTHER=$row_display10["CSS_BOARD_OTHER"]; $CSS_LOCATION=$row_display10["CSS_LOCATION"]; //echo $CSS_UNIVERSITY_ID; if ($CSS_UNIVERSITY_ID==""){ $University=0; }else{ $University=$CSS_UNIVERSITY_ID; } if(strlen(trim($University)) != '') { if(getUnviName($University)=='Other'){ $UnvIns=$Institute; }else{ $UnvIns=getUnviName($University); } } $CSS_ELIGIBLITY=$row_display10["CSS_ELIGIBLITY"]; $CSS_START_DATE=$row_display10["CSS_START_DATE"]; $CSS_END_DATE=$row_display10["CSS_END_DATE"]; $CSS_MAJOR_SUBJECTS=$row_display10["CSS_MAJOR_SUBJECTS"]; $CSS_ACADEMIC_AWARDS=$row_display10["CSS_ACADEMIC_AWARDS"]; $CSS_EXTRA_ACTIVITIES=$row_display10["CSS_EXTRA_ACTIVITIES"]; $temp14.=""; }while (OCIFetchInto($rs_display,$row_display10,OCI_ASSOC)); } $temp14.="

S. No.	School/ College/ University Location	From Date	To Date	Examination Passed	Date of Result Announccement	Division /Grade /CGPA	Board/University	Major Subjects	Distinctions achieved/ Academic Awards ets.	R/ M/ F
".$i."	".$CSS_LOCATION."	".$CSS_START_DATE."	".$CSS_END_DATE."	".$CSS_EXAMINATION."	".$CSS_DATE_RESULT."	".$gdc."	".$UnvIns."	".$CSS_MAJOR_SUBJECTS."	".$CSS_ACADEMIC_AWARDS."	".$CSS_ELIGIBLITY."

"; $temp.= $temp14; $temp.="

15) Extra Activities

"; OCIFreeStatement($rs_display); //OCIFreeStatement($row_display); $display_sql= "select * from CSS_APP_EXTRA_CURRICULUM where CSS_APPLICANT_ID=$aid order by css_from_date"; //echo $display_sql; exit; $temp.=""; if($rs_display = OCIParse($conn, $display_sql)) { //echo "----ahahahah"; $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display12, OCI_ASSOC); do{ $i=$i+1; $CSS_FROM_DATES=$row_display12["CSS_FROM_DATE"]; $CSS_TO_DATES=$row_display12["CSS_TO_DATE"]; $CSS_ACTIVITIES=$row_display12["CSS_EXTRA_CURRICULUM_ACT"]; //echo $CSS_FROM_DATES."---".$CSS_TO_DATES; $temp16.=""; }while (OCIFetchInto($rs_display,$row_display12,OCI_ASSOC)); } $temp16.="

S. No.	From Date	To Date	Extra Curricular Activities/ Sports/ Hobbies
".$i."	".$CSS_FROM_DATES."	".$CSS_TO_DATES."	".$CSS_ACTIVITIES."

"; $temp.=$temp16; $temp.="

16) Disciplinary Action/ Conviction

"; $temp.="

".$CSS_APP_DISCIPLINE."

"; $temp.="

15) Employment Record

"; OCIFreeStatement($rs_display); $display_sql= "select * from CSS_APP_EMPLOYMENT where CSS_APPLICANT_ID=$aid order by css_from_date"; //echo $display_sql; exit; $temp15.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display11, OCI_ASSOC); do{ $i=$i+1; $CSS_POST_TITLE=$row_display11["CSS_POST_TITLE"]; $CSS_DEPT_NAME=$row_display11["CSS_DEPT_NAME"]; $CSS_MINISTRY_NAME=$row_display11["CSS_MINISTRY_NAME"]; $CSS_FIRM_NAME=$row_display11["CSS_FIRM_NAME"]; $CSS_FROM_DATE=$row_display11["CSS_FROM_DATE"]; $CSS_TO_DATE=$row_display11["CSS_TO_DATE"]; $CSS_ORGANIZATION_TYPE=$row_display11["CSS_ORGANIZATION_TYPE"]; $CSS_JOB_STATUS=$row_display11["CSS_JOB_STATUS"]; $CSS_BASIC_SCALE=$row_display11["CSS_BASIC_SCALE"]; $temp15.=""; }while (OCIFetchInto($rs_display,$row_display11,OCI_ASSOC)); } $temp15.="

S. No.	Post and office held	Name of Organiztion	From	To	Type Of Organization	Basic Scale / Grade
".$i."	".$CSS_POST_TITLE."	".$CSS_MINISTRY_NAME."	".$CSS_FROM_DATE."	".$CSS_TO_DATE."	".$CSS_ORGANIZATION_TYPE."	".$CSS_BASIC_SCALE."

"; $temp.=$temp15; $temp.="

17) Particulars about Parents

"; OCIFreeStatement($rs_display); $display_sql= "Select * from CSS_APP_PARENTS where CSS_APPLICANT_ID=$aid order by CSS_PARENT_NAME"; //echo $display_sql; exit; $temp2.=""; $i=0; if($rs_display = OCIParse($conn, $display_sql)) { //echo "you are in..."; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display13, OCI_ASSOC); do{ $i=$i+1; $eid=$row_display13["CSS_APPLICANT_PARENTS_IDS"]; $CSS_PARENT_TYPE=$row_display13["CSS_PARENT_TYPE"]; $CSS_PARENT_AGE=$row_display13["CSS_PARENT_AGE"]; $CSS_PARENT_QUALIFICATION=$row_display13["CSS_PARENT_QUALIFICATION"]; $CSS_PARENT_OCCUPATION=$row_display13["CSS_PARENT_OCCUPATION"]; $CSS_PARENT_OCC_BIRTH=$row_display13["PARENT_OCCUPATION_BIRTH"]; $CSS_PARENT_ALIVE_DEAD=$row_display13["PARENT_ALIVE_DEAD"]; $CSS_FAMILY_INCOME=$row_display13["CSS_FAMILY_INCOME"]; $CSS_PARENT_OTHER_INCOME=$row_display13["OTHER_SOURCE"]; $temp2.=" "; }while (OCIFetchInto($rs_display,$row_display13,OCI_ASSOC)); } $temp2.="

S No.	Parent	Age	Qualification	Occupation/ Designation Present	Occupation/ Designation (at time of your birth)	Alive or Dead	Annual Income	Other Source of income/ supporting income
".$i."	".$CSS_PARENT_TYPE."	".$CSS_PARENT_AGE."	".$CSS_PARENT_QUALIFICATION."	".$CSS_PARENT_OCCUPATION."	".$CSS_PARENT_OCC_BIRTH."	".$CSS_PARENT_ALIVE_DEAD."	".$CSS_FAMILY_INCOME."	".$CSS_PARENT_OTHER_INCOME."

"; $temp.=$temp2; //Disability area $temp.="

18) Disability Claimed

"; OCIFreeStatement($rs_display); $display_sql_dis= "Select * from css_app_disability where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; if($rs_display = OCIParse($conn, $display_sql_dis)) { //echo "you are in..."; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display1357, OCI_ASSOC); $DISID=$row_display1357["CSS_DISABLITY_ID"]; $CSS_DISABILITY_TYPE=$row_display1357["CSS_DISABLITY_TYPE"]; $CSS_DISABLITY_ASS_WRITER=$row_display1357["CSS_DISABLITY_ASS_WRITER"]; $CSS_DISABLITY_ASS_COMP=$row_display1357["CSS_DISABLITY_ASS_COMP"]; $CSS_DISABLITY_ASS_AUDIO=$row_display1357["CSS_DISABLITY_ASS_AUDIO"]; $CSS_DISABLITY_ASS_BRAILLE=$row_display1357["CSS_DISABLITY_ASS_BRAILLE"]; } $temp2357.=""; } else { $temp2357.="NO"; } $temp2357.="

Whether Disabled?	"; if($CSS_AGEREX1==9) { $temp2357.="YES ($CSS_DISABILITY_TYPE)	"; if($CSS_DISABLITY_ASS_WRITER == 1) { $temp2357.="Helper/Writer, "; } if($CSS_DISABLITY_ASS_COMP == 1) { $temp2357.="Computer"; } $temp2357.="

"; $temp.=$temp2357; $temp.="

19) Languages Information

"; OCIFreeStatement($rs_display); $display_sql= "Select * from CSS_APP_LANGUAGE where CSS_APPLICANT_ID=$aid order by CSS_APPLICANT_LANGUAGE_ID desc"; //echo $display_sql;// exit; $temp22.=""; $i=0; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display14, OCI_ASSOC); do{ $i=$i+1; $CSS_LANGUAGE=$row_display14["CSS_LANGUAGE"]; $CSS_READ=$row_display14["CSS_READ"]; $CSS_WRITE=$row_display14["CSS_WRITE"]; $CSS_SPEAK=$row_display14["CSS_SPEAK"]; $CSS_DIPLOMA=$row_display14["CSS_DIPLOMA"]; if (strlen($CSS_DIPLOMA)=='') $CSS_DIPLOMA=" "; $temp22.=""; }while (OCIFetchInto($rs_display,$row_display14,OCI_ASSOC)); } $temp22.="

S. No	Name of Language	Read	Write	Speak	Certificate/Diploma. If any
".$i."	".$CSS_LANGUAGE."	".$CSS_READ."	".$CSS_WRITE."	".$CSS_SPEAK."	".$CSS_DIPLOMA."

"; $temp.=$temp22; $temp.="

20) Brothers/ Sisters Information

"; OCIFreeStatement($rs_display); $display_sql= "select * from CSS_APP_BROTHERS_SISTERS where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; $temp122.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display15, OCI_ASSOC); do{ $i=$i+1; $CSS_APP_BROTHERS_SISTERS_IDS=$row_display15["CSS_APP_BROTHERS_SISTERS_IDS"]; $CSS_NAME=$row_display15["CSS_NAME"]; $CSS_EXAMINATION=$row_display15["CSS_EXAMINATION"]; $CSS_AGE=$row_display15["CSS_AGE"]; $CSS_OCCUPATION=$row_display15["CSS_OCCUPATION"]; $CSS_BROTHER_OR_SISTER=$row_display15["CSS_BROTHER_OR_SISTER"]; $temp122.=""; }while (OCIFetchInto($rs_display,$row_display15,OCI_ASSOC)); } $temp122.="

S. No.	Name	B,S,SB,SS OR X	Age	Occupation	Education
".$i."	".$CSS_NAME."	".$CSS_BROTHER_OR_SISTER."	".$CSS_AGE."	".$CSS_OCCUPATION."	".$CSS_EXAMINATION."

"; $temp.=$temp122; $temp.="

21) Near Relations Information

"; OCIFreeStatement($rs_display); $display_sql= "Select * from CSS_APP_RELATIVE where CSS_APPLICANT_ID=$aid order by CSS_NAME"; //echo $display_sql; $temp3.=""; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display16, OCI_ASSOC); $i=0; do{ $i=$i+1; $CSS_APPLICANT_RELATIVE_IDS = $row_display16["CSS_APPLICANT_RELATIVE_IDS"]; $CSS_NAME = $row_display16["CSS_NAME"]; $CSS_RELATIONSHIP = $row_display16["CSS_RELATIONSHIP"]; $CSS_DEPARTMENT = $row_display16["CSS_DEPARTMENT"]; $CSS_PLACE_DUTY = $row_display16["CSS_PLACE_DUTY"]; $temp3.=""; }while (OCIFetchInto($rs_display,$row_display16,OCI_ASSOC)); } $temp3.="

S. No.	Name of Relative	Relationship	Post held/ Department	Place of duty
".$i."	". $CSS_NAME."	".$CSS_RELATIONSHIP."	".$CSS_DEPARTMENT."	".$CSS_PLACE_DUTY."

"; $temp.=$temp3; $temp.="

22) Detail of previous attempt for Competitive Examinations (CSS)

"; OCIFreeStatement($rs_display); $display_sql= "Select * from CSS_APP_PRE_ATTEMPT where CSS_APPLICANT_ID=$aid"; $temp4.=""; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display17, OCI_ASSOC); $i=0; do{ $i=$i+1; $CSS_APP_PRE_CSS_IDS = $row_display17["CSS_APP_PRE_CSS_IDS"]; $CSS_APP_YEAR = $row_display17["CSS_APP_YEAR"]; $CSS_APP_ROLL_NO = $row_display17["CSS_APP_ROLL_NO"]; $CSS_APP_RESULT = $row_display17["CSS_APP_RESULT"]; $CSS_APP_DISCIPLINE = $row_display17["CSS_APP_DISCIPLINE"]; $CSS_APP_EXAMINATION = $row_display17["CSS_APP_EXAMINATION"]; $temp4.=" "; }while (OCIFetchInto($rs_display,$row_display17,OCI_ASSOC)); } $temp4.="

S. No.	Year	Roll No.	Examination	Result
".$i."	".$CSS_APP_YEAR."	".$CSS_APP_ROLL_NO."	".$CSS_APP_EXAMINATION."	".$CSS_APP_RESULT."

"; $temp.=$temp4; $temp.="

23) Disciplinary Action/ Conviction

"; OCIFreeStatement($rs_display); $display_sql= "Select CSS_APP_DISCIPLINE from CSS_APP_PRE_ATTEMPT where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; $temp133.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display18, OCI_ASSOC); do{ $i=$i+1; $CSS_APP_DISCIPLINE=$row_display18["CSS_APP_DISCIPLINE"]; $temp133.=""; }while (OCIFetchInto($rs_display,$row_display18,OCI_ASSOC)); } $temp133.="

". strtoupper($CSS_APP_DISCIPLINE)."

"; $temp.=$temp133; $temp.="

24) Optional Subjects (600 Marks)

"; OCIFreeStatement($rs_display); $temp166.=""; $sql="select a.*,b.* from CSS_SUBJECT_CHOOSED a,CSS_APP_SUBJECT b where CSS_APPLICANT_ID=$aid and a.CSS_SUBJECT_ID=b.CSS_SUBJECT_ID and CSS_ADVERTISEMENT_ID=$_GET[jid]"; //echo $sql; exit; $rs111 = OCIParse($conn,$sql); OCIExecute($rs111); while(OCIFetchInto($rs111,$arr111,OCI_ASSOC)) { $temp166.=""; } $temp166.="

Subjects (Code No)	Subjects	Marks
$arr111[CSS_SUBJECT_ID]	$arr111[CSS_SUBJECTS]	$arr111[CSS_SUBJECT_MARKS]

"; for($j=0;$j<12;$j++) { $counter[$j]=""; } $sql3="select * from CSS_OCC_SELECTION where CSS_APPLICANT_ID=$aid and CSS_ADVERTISEMENT_ID=$_GET[jid]"; $rs3=OCIParse($conn,$sql3); OCIExecute($rs3); OCIFetchInto($rs3,$arr3,OCI_ASSOC); $sqle="select * from CSS_OCC_GROUPS"; $rse=OCIParse($conn,$sqle); OCIExecute($rse); $count=1; $temp166.="
"; while(OCIFetchInto($rse,$arre,OCI_ASSOC)) { if($arr3["CSS_OCC1_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos1"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC2_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos2"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC3_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos3"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC4_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos4"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC5_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos5"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC6_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos6"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC7_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos7"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC8_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos8"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC9_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos9"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC10_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos10"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC11_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos11"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC12_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos12"]=$arre["CSS_GROUP_NAME"]; } } for($i=1;$i<=12;$i++) { $p="pos".$i; $temp166.="

25) CSS Applicant Occupational Groups.

"; } $temp166.="

$i	".$counter["pos".$i]."

"; $temp.=$temp166; $temp.="

27) Checklist
1) Please confirm if the following documents have been attached with the application form

Yes

Original Treasury Receipt for Rs. 1000/-

Recent 4 Photographs (attested on back side, mentioning name and father's name)

Attested copy of Computerized National Identity Card

Attested copy of Matriculation Certificate showing date of birth, Provisional Certificated/Result Card/Marks Sheet is not acceptable

Attested copy of Degree(s)

Attested copy of self Domicile Certificate

Certificate for Buddhist and Scheduled Caste Candidates

Certificate for Provinical/Federal Tribal Areas candidates and those belonging to Gilgit-Baltistan

Certificate from Kashmir Affairs Division for Azad Kashmir Nationals

Certificate for Minoritites

Departmental Permission Certificate (for Government Servants)

In case of Ex-Employees of Armed Forces of Pakistan No Objection Certificate from relevant authority

In case of Disabled candidates, certificate of disability from the competent authority

Whether you have signed the application? (First Page)

2)	I have read and understood 'Rules for Competitive Examination', 'Regulations for Physical Examination' and 'Instructions to Candidates' before filling the applicationa form and agree to abide by them.
3)	I certify that the statements made by me in the application are ture to the best of my knowledge and belief. I understand that if any of the above statement is false in any material respect of omits any material information relevant to my previous examinations, service, etc. my application is liable to be rejected an if appoineted my appointment is liable to be terminated.

Applicant's Signature

Place

Date

".$jobformat." Roll No.

Name: ".$GR_APPLICANT_NAME."