[Home] [Help]
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:
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,
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,
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