APPS.PQH_DE_CHILD_SEQ_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 33: 6. The procedure PER_CONTACT_RELATIONSHIPS_PKG.Update_Row updates the Child Contact record in

29: 2. Cursor C_Emp_Children finds all the chldren of a employee in the Business Group in the order of Date of Birth.
30: 3. Cursor C_Children_Disability finds Disability information of a Person(Child)
31: 4. Cursor C_Children_Qualification finds Qualification details of a Person(Child)
32: 5. Cursor C_Child_Military_Info finds Military Service/ Civil Service info of the Person(Child)
33: 6. The procedure PER_CONTACT_RELATIONSHIPS_PKG.Update_Row updates the Child Contact record in
34: PER_CONTACT_RELATIONSHIPS to change the Sequence Number.
35:
36: -------------------------------------------------------------------------------------------------*/
37:

Line 34: PER_CONTACT_RELATIONSHIPS to change the Sequence Number.

30: 3. Cursor C_Children_Disability finds Disability information of a Person(Child)
31: 4. Cursor C_Children_Qualification finds Qualification details of a Person(Child)
32: 5. Cursor C_Child_Military_Info finds Military Service/ Civil Service info of the Person(Child)
33: 6. The procedure PER_CONTACT_RELATIONSHIPS_PKG.Update_Row updates the Child Contact record in
34: PER_CONTACT_RELATIONSHIPS to change the Sequence Number.
35:
36: -------------------------------------------------------------------------------------------------*/
37:
38: PROCEDURE REGENERATE_SEQ_NUM(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY NUMBER, pBusiness_grp_id IN NUMBER, pEffective_date IN VARCHAR2) is

Line 151: from PER_CONTACT_RELATIONSHIPS pcr,

147: pei.pei_information1,
148: pei.pei_information2,
149: pei.pei_information3
150:
151: from PER_CONTACT_RELATIONSHIPS pcr,
152: PER_PEOPLE_F pap,
153: PER_PEOPLE_EXTRA_INFO pei
154: where
155: pcr.Contact_Relationship_Id in

Line 158: from PER_CONTACT_RELATIONSHIPS xpcr,

154: where
155: pcr.Contact_Relationship_Id in
156: (select
157: xpcr.Contact_Relationship_Id
158: from PER_CONTACT_RELATIONSHIPS xpcr,
159: PER_ALL_PEOPLE_F xpap
160: where xpcr.BUSINESS_GROUP_ID=lBusiness_group_id
161: and xpcr.PERSON_ID=xpap.PERSON_ID
162: and xpap.PERSON_ID=lPerson_id

Line 341: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(

337: end if;*/
338: end if; -- DATE_OF_BIRTH
339: if (update_flag=true)
340: then
341: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(
342: X_Rowid => C2.Rowid,
343: X_Contact_Relationship_Id => c2.Contact_Relationship_Id,
344: X_Business_Group_Id => C2.Business_Group_Id,
345: X_Person_Id => C2.Person_Id,

Line 406: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(

402: X_Dependent_Flag => C2.Dependent_Flag,
403: X_Beneficiary_Flag => C2.Beneficiary_Flag
404: );
405: ELSE
406: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(
407: X_Rowid => C2.Rowid,
408: X_Contact_Relationship_Id => c2.Contact_Relationship_Id,
409: X_Business_Group_Id => C2.Business_Group_Id,
410: X_Person_Id => C2.Person_Id,

Line 524: 5. The procedure PER_CONTACT_RELATIONSHIPS_PKG.Update_Row updates the Child Contact record in

520: 1. Cursor finds all Employees in the Business Group who want child sequence number to be auto generated.
521: 2. Cursor finds all the chldren of a employee in the Business Group in the order of Date of Birth.
522: 3. Cursor finds Disability information of a Person(Child)
523: 4. Cursor finds Qualification details of a Person(Child)
524: 5. The procedure PER_CONTACT_RELATIONSHIPS_PKG.Update_Row updates the Child Contact record in
525: PER_CONTACT_RELATIONSHIPS to change the Sequence Number.
526:
527: -------------------------------------------------------------------------------------------------*/
528: FUNCTION DEFAULT_SEQ_NUM (parent_id IN NUMBER, bg_id IN NUMBER, session_date IN date) RETURN NUMBER IS

Line 525: PER_CONTACT_RELATIONSHIPS to change the Sequence Number.

521: 2. Cursor finds all the chldren of a employee in the Business Group in the order of Date of Birth.
522: 3. Cursor finds Disability information of a Person(Child)
523: 4. Cursor finds Qualification details of a Person(Child)
524: 5. The procedure PER_CONTACT_RELATIONSHIPS_PKG.Update_Row updates the Child Contact record in
525: PER_CONTACT_RELATIONSHIPS to change the Sequence Number.
526:
527: -------------------------------------------------------------------------------------------------*/
528: FUNCTION DEFAULT_SEQ_NUM (parent_id IN NUMBER, bg_id IN NUMBER, session_date IN date) RETURN NUMBER IS
529:

Line 556: from PER_CONTACT_RELATIONSHIPS pcr

552: FETCH IS_Emp_OF_Business_Grp into c_Emp_Cur;
553:
554: if IS_Emp_OF_Business_Grp%FOUND then
555: select max(nvl(pcr.cont_information6,0)) into seq_num
556: from PER_CONTACT_RELATIONSHIPS pcr
557: where
558: pcr.BUSINESS_GROUP_ID=bg_id
559: and pcr.PERSON_ID=parent_id
560: and nvl(pcr.DATE_START,session_date) <=session_date