428: -- Populate the row who columns
429:
430: l_job_header_rec.creation_date := SYSDATE;
431: l_job_header_rec.last_update_date := SYSDATE;
432: l_job_header_rec.created_by := fnd_global.user_id;
433: l_job_header_rec.last_updated_by := fnd_global.user_id;
434: l_job_header_rec.last_update_login := fnd_global.login_id;
435:
436:
429:
430: l_job_header_rec.creation_date := SYSDATE;
431: l_job_header_rec.last_update_date := SYSDATE;
432: l_job_header_rec.created_by := fnd_global.user_id;
433: l_job_header_rec.last_updated_by := fnd_global.user_id;
434: l_job_header_rec.last_update_login := fnd_global.login_id;
435:
436:
437: --insert into table wip_job_schedule_interface
430: l_job_header_rec.creation_date := SYSDATE;
431: l_job_header_rec.last_update_date := SYSDATE;
432: l_job_header_rec.created_by := fnd_global.user_id;
433: l_job_header_rec.last_updated_by := fnd_global.user_id;
434: l_job_header_rec.last_update_login := fnd_global.login_id;
435:
436:
437: --insert into table wip_job_schedule_interface
438: BEGIN
585: -- Populate the row who columns
586:
587: l_job_details_rec.creation_date := SYSDATE;
588: l_job_details_rec.last_update_date := SYSDATE;
589: l_job_details_rec.created_by := fnd_global.user_id;
590: l_job_details_rec.last_updated_by := fnd_global.user_id;
591: l_job_details_rec.last_update_login := fnd_global.login_id;
592:
593:
586:
587: l_job_details_rec.creation_date := SYSDATE;
588: l_job_details_rec.last_update_date := SYSDATE;
589: l_job_details_rec.created_by := fnd_global.user_id;
590: l_job_details_rec.last_updated_by := fnd_global.user_id;
591: l_job_details_rec.last_update_login := fnd_global.login_id;
592:
593:
594: BEGIN
587: l_job_details_rec.creation_date := SYSDATE;
588: l_job_details_rec.last_update_date := SYSDATE;
589: l_job_details_rec.created_by := fnd_global.user_id;
590: l_job_details_rec.last_updated_by := fnd_global.user_id;
591: l_job_details_rec.last_update_login := fnd_global.login_id;
592:
593:
594: BEGIN
595:
762: -- Populate the row who columns
763:
764: l_transactions_interface_rec.creation_date := SYSDATE;
765: l_transactions_interface_rec.last_update_date := SYSDATE;
766: l_transactions_interface_rec.created_by := fnd_global.user_id;
767: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;
768: l_transactions_interface_rec.last_update_login := fnd_global.login_id;
769:
770:
763:
764: l_transactions_interface_rec.creation_date := SYSDATE;
765: l_transactions_interface_rec.last_update_date := SYSDATE;
766: l_transactions_interface_rec.created_by := fnd_global.user_id;
767: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;
768: l_transactions_interface_rec.last_update_login := fnd_global.login_id;
769:
770:
771: --insert into table mtl_transactions_interface
764: l_transactions_interface_rec.creation_date := SYSDATE;
765: l_transactions_interface_rec.last_update_date := SYSDATE;
766: l_transactions_interface_rec.created_by := fnd_global.user_id;
767: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;
768: l_transactions_interface_rec.last_update_login := fnd_global.login_id;
769:
770:
771: --insert into table mtl_transactions_interface
772: BEGIN
958: -- Populate the row who columns
959:
960: l_creation_date := SYSDATE;
961: l_last_update_date := SYSDATE;
962: l_created_by := fnd_global.user_id;
963: l_last_updated_by := fnd_global.user_id;
964: l_last_update_login := fnd_global.login_id;
965:
966:
959:
960: l_creation_date := SYSDATE;
961: l_last_update_date := SYSDATE;
962: l_created_by := fnd_global.user_id;
963: l_last_updated_by := fnd_global.user_id;
964: l_last_update_login := fnd_global.login_id;
965:
966:
967: --insert into table mtl_transactions_interface
960: l_creation_date := SYSDATE;
961: l_last_update_date := SYSDATE;
962: l_created_by := fnd_global.user_id;
963: l_last_updated_by := fnd_global.user_id;
964: l_last_update_login := fnd_global.login_id;
965:
966:
967: --insert into table mtl_transactions_interface
968: BEGIN
1071: -- Populate the row who columns
1072:
1073: l_creation_date := SYSDATE;
1074: l_last_update_date := SYSDATE;
1075: l_created_by := fnd_global.user_id;
1076: l_last_updated_by := fnd_global.user_id;
1077: l_last_update_login := fnd_global.login_id;
1078:
1079:
1072:
1073: l_creation_date := SYSDATE;
1074: l_last_update_date := SYSDATE;
1075: l_created_by := fnd_global.user_id;
1076: l_last_updated_by := fnd_global.user_id;
1077: l_last_update_login := fnd_global.login_id;
1078:
1079:
1080: --insert into table mtl_transactions_interface
1073: l_creation_date := SYSDATE;
1074: l_last_update_date := SYSDATE;
1075: l_created_by := fnd_global.user_id;
1076: l_last_updated_by := fnd_global.user_id;
1077: l_last_update_login := fnd_global.login_id;
1078:
1079:
1080: --insert into table mtl_transactions_interface
1081: BEGIN
1179: -- Populate the row who columns
1180:
1181: l_creation_date := SYSDATE;
1182: l_last_update_date := SYSDATE;
1183: l_created_by_name := fnd_global.user_name;
1184: l_last_updated_by := fnd_global.user_id;
1185: l_last_updated_by_name := fnd_global.user_name;
1186: l_last_update_login := fnd_global.login_id;
1187:
1180:
1181: l_creation_date := SYSDATE;
1182: l_last_update_date := SYSDATE;
1183: l_created_by_name := fnd_global.user_name;
1184: l_last_updated_by := fnd_global.user_id;
1185: l_last_updated_by_name := fnd_global.user_name;
1186: l_last_update_login := fnd_global.login_id;
1187:
1188:
1181: l_creation_date := SYSDATE;
1182: l_last_update_date := SYSDATE;
1183: l_created_by_name := fnd_global.user_name;
1184: l_last_updated_by := fnd_global.user_id;
1185: l_last_updated_by_name := fnd_global.user_name;
1186: l_last_update_login := fnd_global.login_id;
1187:
1188:
1189: --insert into table wip_cost_txn_interface
1182: l_last_update_date := SYSDATE;
1183: l_created_by_name := fnd_global.user_name;
1184: l_last_updated_by := fnd_global.user_id;
1185: l_last_updated_by_name := fnd_global.user_name;
1186: l_last_update_login := fnd_global.login_id;
1187:
1188:
1189: --insert into table wip_cost_txn_interface
1190: BEGIN
1313: -- Populate the row who columns
1314:
1315: l_creation_date := SYSDATE;
1316: l_last_update_date := SYSDATE;
1317: l_created_by := fnd_global.user_id;
1318: l_created_by_name := fnd_global.user_name;
1319: l_last_updated_by := fnd_global.user_id;
1320: l_last_updated_by_name := fnd_global.user_name;
1321: l_last_update_login := fnd_global.login_id;
1314:
1315: l_creation_date := SYSDATE;
1316: l_last_update_date := SYSDATE;
1317: l_created_by := fnd_global.user_id;
1318: l_created_by_name := fnd_global.user_name;
1319: l_last_updated_by := fnd_global.user_id;
1320: l_last_updated_by_name := fnd_global.user_name;
1321: l_last_update_login := fnd_global.login_id;
1322:
1315: l_creation_date := SYSDATE;
1316: l_last_update_date := SYSDATE;
1317: l_created_by := fnd_global.user_id;
1318: l_created_by_name := fnd_global.user_name;
1319: l_last_updated_by := fnd_global.user_id;
1320: l_last_updated_by_name := fnd_global.user_name;
1321: l_last_update_login := fnd_global.login_id;
1322:
1323:
1316: l_last_update_date := SYSDATE;
1317: l_created_by := fnd_global.user_id;
1318: l_created_by_name := fnd_global.user_name;
1319: l_last_updated_by := fnd_global.user_id;
1320: l_last_updated_by_name := fnd_global.user_name;
1321: l_last_update_login := fnd_global.login_id;
1322:
1323:
1324:
1317: l_created_by := fnd_global.user_id;
1318: l_created_by_name := fnd_global.user_name;
1319: l_last_updated_by := fnd_global.user_id;
1320: l_last_updated_by_name := fnd_global.user_name;
1321: l_last_update_login := fnd_global.login_id;
1322:
1323:
1324:
1325: --insert into table wip_move_txn_interface
2613:
2614: -- Populate the row who columns
2615:
2616: l_last_update_date := SYSDATE;
2617: l_last_updated_by := fnd_global.user_id;
2618: l_last_update_login := fnd_global.login_id;
2619:
2620:
2621: -- generate transaction_header_id
2614: -- Populate the row who columns
2615:
2616: l_last_update_date := SYSDATE;
2617: l_last_updated_by := fnd_global.user_id;
2618: l_last_update_login := fnd_global.login_id;
2619:
2620:
2621: -- generate transaction_header_id
2622: open get_mtl_header_id;
3760:
3761: -- Populate the row who columns
3762:
3763: l_last_update_date := SYSDATE;
3764: l_last_updated_by := fnd_global.user_id;
3765: l_last_update_login := fnd_global.login_id;
3766:
3767:
3768: -- Populate the constant values
3761: -- Populate the row who columns
3762:
3763: l_last_update_date := SYSDATE;
3764: l_last_updated_by := fnd_global.user_id;
3765: l_last_update_login := fnd_global.login_id;
3766:
3767:
3768: -- Populate the constant values
3769:
4293: -- Populate the row who columns
4294:
4295: l_creation_date := SYSDATE;
4296: l_last_update_date := SYSDATE;
4297: l_created_by := fnd_global.user_id;
4298: l_last_updated_by := fnd_global.user_id;
4299: l_last_update_login := fnd_global.login_id;
4300:
4301:
4294:
4295: l_creation_date := SYSDATE;
4296: l_last_update_date := SYSDATE;
4297: l_created_by := fnd_global.user_id;
4298: l_last_updated_by := fnd_global.user_id;
4299: l_last_update_login := fnd_global.login_id;
4300:
4301:
4302:
4295: l_creation_date := SYSDATE;
4296: l_last_update_date := SYSDATE;
4297: l_created_by := fnd_global.user_id;
4298: l_last_updated_by := fnd_global.user_id;
4299: l_last_update_login := fnd_global.login_id;
4300:
4301:
4302:
4303:
4760: -- Populate the row who columns
4761:
4762: l_creation_date := SYSDATE;
4763: l_last_update_date := SYSDATE;
4764: l_created_by := fnd_global.user_id;
4765: l_last_updated_by := fnd_global.user_id;
4766: l_last_update_login := fnd_global.login_id;
4767:
4768: FOR res_ctr in p_res_txn_dtls_tbl.FIRST.. p_res_txn_dtls_tbl.LAST
4761:
4762: l_creation_date := SYSDATE;
4763: l_last_update_date := SYSDATE;
4764: l_created_by := fnd_global.user_id;
4765: l_last_updated_by := fnd_global.user_id;
4766: l_last_update_login := fnd_global.login_id;
4767:
4768: FOR res_ctr in p_res_txn_dtls_tbl.FIRST.. p_res_txn_dtls_tbl.LAST
4769:
4762: l_creation_date := SYSDATE;
4763: l_last_update_date := SYSDATE;
4764: l_created_by := fnd_global.user_id;
4765: l_last_updated_by := fnd_global.user_id;
4766: l_last_update_login := fnd_global.login_id;
4767:
4768: FOR res_ctr in p_res_txn_dtls_tbl.FIRST.. p_res_txn_dtls_tbl.LAST
4769:
4770: LOOP
5134:
5135: -- Get the data for the WHO columns
5136: l_creation_date := SYSDATE;
5137: l_last_update_date := SYSDATE;
5138: l_created_by := fnd_global.user_id;
5139: l_last_updated_by := fnd_global.user_id;
5140: l_last_update_login := fnd_global.login_id;
5141:
5142: FOR op_ctr in p_op_dtls_tbl.FIRST.. p_op_dtls_tbl.LAST
5135: -- Get the data for the WHO columns
5136: l_creation_date := SYSDATE;
5137: l_last_update_date := SYSDATE;
5138: l_created_by := fnd_global.user_id;
5139: l_last_updated_by := fnd_global.user_id;
5140: l_last_update_login := fnd_global.login_id;
5141:
5142: FOR op_ctr in p_op_dtls_tbl.FIRST.. p_op_dtls_tbl.LAST
5143: LOOP
5136: l_creation_date := SYSDATE;
5137: l_last_update_date := SYSDATE;
5138: l_created_by := fnd_global.user_id;
5139: l_last_updated_by := fnd_global.user_id;
5140: l_last_update_login := fnd_global.login_id;
5141:
5142: FOR op_ctr in p_op_dtls_tbl.FIRST.. p_op_dtls_tbl.LAST
5143: LOOP
5144: -- l_operation_seq_num := p_op_dtls_tbl(op_ctr).operation_seq_num;
5817:
5818: -- call procedures to insert a row in csd_repair_job_xref
5819: -- and csd_repair_history tables for the job created.
5820:
5821: L_user_id := fnd_global.user_id;
5822:
5823: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5824: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
5825: lc_mod_name||'beforecallxrefwrite',
6472:
6473: -- call procedures to insert a row in csd_repair_job_xref
6474: -- and csd_repair_history tables for the job created.
6475:
6476: l_user_id := fnd_global.user_id;
6477:
6478: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6479: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
6480: lc_mod_name||'beforecallxrefwrite',