984: , l_parent_object_id2 -- R12Genealogy Enhancements
985: , SYSDATE
986: , -1
987: , SYSDATE + 10
988: , fnd_global.user_id
989: , p_start_date_active
990: , p_end_date_active
991: , p_genealogy_origin
992: , p_origin_txn_id
1008: , NULL
1009: , NULL
1010: , NULL
1011: , NULL
1012: , fnd_global.conc_request_id
1013: , fnd_global.prog_appl_id
1014: , fnd_global.conc_program_id
1015: , SYSDATE
1016: );
1009: , NULL
1010: , NULL
1011: , NULL
1012: , fnd_global.conc_request_id
1013: , fnd_global.prog_appl_id
1014: , fnd_global.conc_program_id
1015: , SYSDATE
1016: );
1017:
1010: , NULL
1011: , NULL
1012: , fnd_global.conc_request_id
1013: , fnd_global.prog_appl_id
1014: , fnd_global.conc_program_id
1015: , SYSDATE
1016: );
1017:
1018: IF (l_debug = 1) THEN mydebug( 'Inserted a New Record ' ); END IF;
1305: , last_updated_by = -1
1306: , end_date_active = p_end_date_active
1307: , update_txn_id = p_update_txn_id
1308: , last_update_login = -1
1309: , request_id = fnd_global.conc_request_id
1310: , program_application_id = fnd_global.prog_appl_id
1311: , program_id = fnd_global.conc_program_id
1312: , program_update_date = SYSDATE
1313: WHERE object_id = l_object_id
1306: , end_date_active = p_end_date_active
1307: , update_txn_id = p_update_txn_id
1308: , last_update_login = -1
1309: , request_id = fnd_global.conc_request_id
1310: , program_application_id = fnd_global.prog_appl_id
1311: , program_id = fnd_global.conc_program_id
1312: , program_update_date = SYSDATE
1313: WHERE object_id = l_object_id
1314: AND end_date_active IS NULL;
1307: , update_txn_id = p_update_txn_id
1308: , last_update_login = -1
1309: , request_id = fnd_global.conc_request_id
1310: , program_application_id = fnd_global.prog_appl_id
1311: , program_id = fnd_global.conc_program_id
1312: , program_update_date = SYSDATE
1313: WHERE object_id = l_object_id
1314: AND end_date_active IS NULL;
1315:
2856: , end_date_active = l_end_date_active
2857: , update_txn_id = p_update_txn_id
2858: , last_update_login = -1
2859: , request_id = -1
2860: , program_application_id = fnd_global.prog_appl_id
2861: , program_id = fnd_global.conc_program_id
2862: , program_update_date = SYSDATE
2863: WHERE end_date_active IS NULL
2864: AND parent_object_id = l_object_id
2857: , update_txn_id = p_update_txn_id
2858: , last_update_login = -1
2859: , request_id = -1
2860: , program_application_id = fnd_global.prog_appl_id
2861: , program_id = fnd_global.conc_program_id
2862: , program_update_date = SYSDATE
2863: WHERE end_date_active IS NULL
2864: AND parent_object_id = l_object_id
2865: AND parent_object_id2 IS NULL
2892: , last_updated_by = -1
2893: , end_date_active = l_end_date_active
2894: , update_txn_id = p_update_txn_id
2895: , last_update_login = -1
2896: , request_id = fnd_global.conc_request_id
2897: , program_application_id = fnd_global.prog_appl_id
2898: , program_id = fnd_global.conc_program_id
2899: , program_update_date = SYSDATE
2900: WHERE end_date_active IS NULL
2893: , end_date_active = l_end_date_active
2894: , update_txn_id = p_update_txn_id
2895: , last_update_login = -1
2896: , request_id = fnd_global.conc_request_id
2897: , program_application_id = fnd_global.prog_appl_id
2898: , program_id = fnd_global.conc_program_id
2899: , program_update_date = SYSDATE
2900: WHERE end_date_active IS NULL
2901: AND parent_object_id = l_object_id
2894: , update_txn_id = p_update_txn_id
2895: , last_update_login = -1
2896: , request_id = fnd_global.conc_request_id
2897: , program_application_id = fnd_global.prog_appl_id
2898: , program_id = fnd_global.conc_program_id
2899: , program_update_date = SYSDATE
2900: WHERE end_date_active IS NULL
2901: AND parent_object_id = l_object_id
2902: AND parent_object_id2 = l_object_id2
2927: , end_date_active = l_end_date_active
2928: , update_txn_id = p_update_txn_id
2929: , last_update_login = -1
2930: , request_id = -1
2931: , program_application_id = fnd_global.prog_appl_id
2932: , program_id = fnd_global.conc_program_id
2933: , program_update_date = SYSDATE
2934: WHERE end_date_active IS NULL
2935: AND object_id = l_object_id
2928: , update_txn_id = p_update_txn_id
2929: , last_update_login = -1
2930: , request_id = -1
2931: , program_application_id = fnd_global.prog_appl_id
2932: , program_id = fnd_global.conc_program_id
2933: , program_update_date = SYSDATE
2934: WHERE end_date_active IS NULL
2935: AND object_id = l_object_id
2936: AND object_id2 IS NULL
2962: , last_updated_by = -1
2963: , end_date_active = l_end_date_active
2964: , update_txn_id = p_update_txn_id
2965: , last_update_login = -1
2966: , request_id = fnd_global.conc_request_id
2967: , program_application_id = fnd_global.prog_appl_id
2968: , program_id = fnd_global.conc_program_id
2969: , program_update_date = SYSDATE
2970: WHERE end_date_active IS NULL
2963: , end_date_active = l_end_date_active
2964: , update_txn_id = p_update_txn_id
2965: , last_update_login = -1
2966: , request_id = fnd_global.conc_request_id
2967: , program_application_id = fnd_global.prog_appl_id
2968: , program_id = fnd_global.conc_program_id
2969: , program_update_date = SYSDATE
2970: WHERE end_date_active IS NULL
2971: AND object_id = l_object_id
2964: , update_txn_id = p_update_txn_id
2965: , last_update_login = -1
2966: , request_id = fnd_global.conc_request_id
2967: , program_application_id = fnd_global.prog_appl_id
2968: , program_id = fnd_global.conc_program_id
2969: , program_update_date = SYSDATE
2970: WHERE end_date_active IS NULL
2971: AND object_id = l_object_id
2972: AND object_id2 = l_object_id2