DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on FND_GLOBAL

Line 432: l_job_header_rec.created_by := fnd_global.user_id;

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:

Line 433: l_job_header_rec.last_updated_by := fnd_global.user_id;

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

Line 434: l_job_header_rec.last_update_login := fnd_global.login_id;

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

Line 589: l_job_details_rec.created_by := fnd_global.user_id;

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:

Line 590: l_job_details_rec.last_updated_by := fnd_global.user_id;

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

Line 591: l_job_details_rec.last_update_login := fnd_global.login_id;

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:

Line 766: l_transactions_interface_rec.created_by := fnd_global.user_id;

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:

Line 767: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;

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

Line 768: l_transactions_interface_rec.last_update_login := fnd_global.login_id;

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

Line 962: l_created_by := fnd_global.user_id;

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:

Line 963: l_last_updated_by := fnd_global.user_id;

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

Line 964: l_last_update_login := fnd_global.login_id;

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

Line 1075: l_created_by := fnd_global.user_id;

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:

Line 1076: l_last_updated_by := fnd_global.user_id;

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

Line 1077: l_last_update_login := fnd_global.login_id;

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

Line 1183: l_created_by_name := fnd_global.user_name;

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:

Line 1184: l_last_updated_by := fnd_global.user_id;

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:

Line 1185: l_last_updated_by_name := fnd_global.user_name;

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

Line 1186: l_last_update_login := fnd_global.login_id;

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

Line 1317: l_created_by := fnd_global.user_id;

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;

Line 1318: l_created_by_name := fnd_global.user_name;

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:

Line 1319: l_last_updated_by := fnd_global.user_id;

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:

Line 1320: l_last_updated_by_name := fnd_global.user_name;

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:

Line 1321: l_last_update_login := fnd_global.login_id;

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

Line 2617: l_last_updated_by := fnd_global.user_id;

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

Line 2618: l_last_update_login := fnd_global.login_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;

Line 3764: l_last_updated_by := fnd_global.user_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

Line 3765: l_last_update_login := fnd_global.login_id;

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:

Line 4297: l_created_by := fnd_global.user_id;

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:

Line 4298: l_last_updated_by := fnd_global.user_id;

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:

Line 4299: l_last_update_login := fnd_global.login_id;

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:

Line 4764: l_created_by := fnd_global.user_id;

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

Line 4765: l_last_updated_by := fnd_global.user_id;

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:

Line 4766: l_last_update_login := fnd_global.login_id;

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

Line 5138: l_created_by := fnd_global.user_id;

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

Line 5139: l_last_updated_by := fnd_global.user_id;

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

Line 5140: l_last_update_login := fnd_global.login_id;

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;

Line 5821: L_user_id := fnd_global.user_id;

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',

Line 6476: l_user_id := fnd_global.user_id;

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',