1001: , l_parent_object_id2 -- R12Genealogy Enhancements
1002: , SYSDATE
1003: , -1
1004: , SYSDATE + 10
1005: , fnd_global.user_id
1006: , p_start_date_active
1007: , p_end_date_active
1008: , p_genealogy_origin
1009: , p_origin_txn_id
1025: , NULL
1026: , NULL
1027: , NULL
1028: , NULL
1029: , fnd_global.conc_request_id
1030: , fnd_global.prog_appl_id
1031: , fnd_global.conc_program_id
1032: , SYSDATE
1033: );
1026: , NULL
1027: , NULL
1028: , NULL
1029: , fnd_global.conc_request_id
1030: , fnd_global.prog_appl_id
1031: , fnd_global.conc_program_id
1032: , SYSDATE
1033: );
1034:
1027: , NULL
1028: , NULL
1029: , fnd_global.conc_request_id
1030: , fnd_global.prog_appl_id
1031: , fnd_global.conc_program_id
1032: , SYSDATE
1033: );
1034:
1035: IF (l_debug = 1) THEN mydebug( 'Inserted a New Record ' ); END IF;
1325: , last_updated_by = -1
1326: , end_date_active = p_end_date_active
1327: , update_txn_id = p_update_txn_id
1328: , last_update_login = -1
1329: , request_id = fnd_global.conc_request_id
1330: , program_application_id = fnd_global.prog_appl_id
1331: , program_id = fnd_global.conc_program_id
1332: , program_update_date = SYSDATE
1333: WHERE object_id = l_object_id
1326: , end_date_active = p_end_date_active
1327: , update_txn_id = p_update_txn_id
1328: , last_update_login = -1
1329: , request_id = fnd_global.conc_request_id
1330: , program_application_id = fnd_global.prog_appl_id
1331: , program_id = fnd_global.conc_program_id
1332: , program_update_date = SYSDATE
1333: WHERE object_id = l_object_id
1334: AND end_date_active IS NULL;
1327: , update_txn_id = p_update_txn_id
1328: , last_update_login = -1
1329: , request_id = fnd_global.conc_request_id
1330: , program_application_id = fnd_global.prog_appl_id
1331: , program_id = fnd_global.conc_program_id
1332: , program_update_date = SYSDATE
1333: WHERE object_id = l_object_id
1334: AND end_date_active IS NULL;
1335:
2879: , end_date_active = l_end_date_active
2880: , update_txn_id = p_update_txn_id
2881: , last_update_login = -1
2882: , request_id = -1
2883: , program_application_id = fnd_global.prog_appl_id
2884: , program_id = fnd_global.conc_program_id
2885: , program_update_date = SYSDATE
2886: WHERE end_date_active IS NULL
2887: AND parent_object_id = l_object_id
2880: , update_txn_id = p_update_txn_id
2881: , last_update_login = -1
2882: , request_id = -1
2883: , program_application_id = fnd_global.prog_appl_id
2884: , program_id = fnd_global.conc_program_id
2885: , program_update_date = SYSDATE
2886: WHERE end_date_active IS NULL
2887: AND parent_object_id = l_object_id
2888: AND parent_object_id2 IS NULL
2915: , last_updated_by = -1
2916: , end_date_active = l_end_date_active
2917: , update_txn_id = p_update_txn_id
2918: , last_update_login = -1
2919: , request_id = fnd_global.conc_request_id
2920: , program_application_id = fnd_global.prog_appl_id
2921: , program_id = fnd_global.conc_program_id
2922: , program_update_date = SYSDATE
2923: WHERE end_date_active IS NULL
2916: , end_date_active = l_end_date_active
2917: , update_txn_id = p_update_txn_id
2918: , last_update_login = -1
2919: , request_id = fnd_global.conc_request_id
2920: , program_application_id = fnd_global.prog_appl_id
2921: , program_id = fnd_global.conc_program_id
2922: , program_update_date = SYSDATE
2923: WHERE end_date_active IS NULL
2924: AND parent_object_id = l_object_id
2917: , update_txn_id = p_update_txn_id
2918: , last_update_login = -1
2919: , request_id = fnd_global.conc_request_id
2920: , program_application_id = fnd_global.prog_appl_id
2921: , program_id = fnd_global.conc_program_id
2922: , program_update_date = SYSDATE
2923: WHERE end_date_active IS NULL
2924: AND parent_object_id = l_object_id
2925: AND parent_object_id2 = l_object_id2
2950: , end_date_active = l_end_date_active
2951: , update_txn_id = p_update_txn_id
2952: , last_update_login = -1
2953: , request_id = -1
2954: , program_application_id = fnd_global.prog_appl_id
2955: , program_id = fnd_global.conc_program_id
2956: , program_update_date = SYSDATE
2957: WHERE end_date_active IS NULL
2958: AND object_id = l_object_id
2951: , update_txn_id = p_update_txn_id
2952: , last_update_login = -1
2953: , request_id = -1
2954: , program_application_id = fnd_global.prog_appl_id
2955: , program_id = fnd_global.conc_program_id
2956: , program_update_date = SYSDATE
2957: WHERE end_date_active IS NULL
2958: AND object_id = l_object_id
2959: AND object_id2 IS NULL
2985: , last_updated_by = -1
2986: , end_date_active = l_end_date_active
2987: , update_txn_id = p_update_txn_id
2988: , last_update_login = -1
2989: , request_id = fnd_global.conc_request_id
2990: , program_application_id = fnd_global.prog_appl_id
2991: , program_id = fnd_global.conc_program_id
2992: , program_update_date = SYSDATE
2993: WHERE end_date_active IS NULL
2986: , end_date_active = l_end_date_active
2987: , update_txn_id = p_update_txn_id
2988: , last_update_login = -1
2989: , request_id = fnd_global.conc_request_id
2990: , program_application_id = fnd_global.prog_appl_id
2991: , program_id = fnd_global.conc_program_id
2992: , program_update_date = SYSDATE
2993: WHERE end_date_active IS NULL
2994: AND object_id = l_object_id
2987: , update_txn_id = p_update_txn_id
2988: , last_update_login = -1
2989: , request_id = fnd_global.conc_request_id
2990: , program_application_id = fnd_global.prog_appl_id
2991: , program_id = fnd_global.conc_program_id
2992: , program_update_date = SYSDATE
2993: WHERE end_date_active IS NULL
2994: AND object_id = l_object_id
2995: AND object_id2 = l_object_id2