eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on FND_GLOBAL

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

460: -- Populate the row who columns
461:
462: l_job_header_rec.creation_date := SYSDATE;
463: l_job_header_rec.last_update_date := SYSDATE;
464: l_job_header_rec.created_by := fnd_global.user_id;
465: l_job_header_rec.last_updated_by := fnd_global.user_id;
466: l_job_header_rec.last_update_login := fnd_global.login_id;
467:
468:

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

461:
462: l_job_header_rec.creation_date := SYSDATE;
463: l_job_header_rec.last_update_date := SYSDATE;
464: l_job_header_rec.created_by := fnd_global.user_id;
465: l_job_header_rec.last_updated_by := fnd_global.user_id;
466: l_job_header_rec.last_update_login := fnd_global.login_id;
467:
468:
469: --insert into table wip_job_schedule_interface

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

462: l_job_header_rec.creation_date := SYSDATE;
463: l_job_header_rec.last_update_date := SYSDATE;
464: l_job_header_rec.created_by := fnd_global.user_id;
465: l_job_header_rec.last_updated_by := fnd_global.user_id;
466: l_job_header_rec.last_update_login := fnd_global.login_id;
467:
468:
469: --insert into table wip_job_schedule_interface
470: BEGIN

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

623: -- Populate the row who columns
624:
625: l_job_details_rec.creation_date := SYSDATE;
626: l_job_details_rec.last_update_date := SYSDATE;
627: l_job_details_rec.created_by := fnd_global.user_id;
628: l_job_details_rec.last_updated_by := fnd_global.user_id;
629: l_job_details_rec.last_update_login := fnd_global.login_id;
630:
631:

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

624:
625: l_job_details_rec.creation_date := SYSDATE;
626: l_job_details_rec.last_update_date := SYSDATE;
627: l_job_details_rec.created_by := fnd_global.user_id;
628: l_job_details_rec.last_updated_by := fnd_global.user_id;
629: l_job_details_rec.last_update_login := fnd_global.login_id;
630:
631:
632: BEGIN

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

625: l_job_details_rec.creation_date := SYSDATE;
626: l_job_details_rec.last_update_date := SYSDATE;
627: l_job_details_rec.created_by := fnd_global.user_id;
628: l_job_details_rec.last_updated_by := fnd_global.user_id;
629: l_job_details_rec.last_update_login := fnd_global.login_id;
630:
631:
632: BEGIN
633:

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

802: -- Populate the row who columns
803:
804: l_transactions_interface_rec.creation_date := SYSDATE;
805: l_transactions_interface_rec.last_update_date := SYSDATE;
806: l_transactions_interface_rec.created_by := fnd_global.user_id;
807: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;
808: l_transactions_interface_rec.last_update_login := fnd_global.login_id;
809:
810:

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

803:
804: l_transactions_interface_rec.creation_date := SYSDATE;
805: l_transactions_interface_rec.last_update_date := SYSDATE;
806: l_transactions_interface_rec.created_by := fnd_global.user_id;
807: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;
808: l_transactions_interface_rec.last_update_login := fnd_global.login_id;
809:
810:
811: --insert into table mtl_transactions_interface

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

804: l_transactions_interface_rec.creation_date := SYSDATE;
805: l_transactions_interface_rec.last_update_date := SYSDATE;
806: l_transactions_interface_rec.created_by := fnd_global.user_id;
807: l_transactions_interface_rec.last_updated_by := fnd_global.user_id;
808: l_transactions_interface_rec.last_update_login := fnd_global.login_id;
809:
810:
811: --insert into table mtl_transactions_interface
812: BEGIN

Line 1002: l_created_by := fnd_global.user_id;

998: -- Populate the row who columns
999:
1000: l_creation_date := SYSDATE;
1001: l_last_update_date := SYSDATE;
1002: l_created_by := fnd_global.user_id;
1003: l_last_updated_by := fnd_global.user_id;
1004: l_last_update_login := fnd_global.login_id;
1005:
1006:

Line 1003: l_last_updated_by := fnd_global.user_id;

999:
1000: l_creation_date := SYSDATE;
1001: l_last_update_date := SYSDATE;
1002: l_created_by := fnd_global.user_id;
1003: l_last_updated_by := fnd_global.user_id;
1004: l_last_update_login := fnd_global.login_id;
1005:
1006:
1007: --insert into table mtl_transactions_interface

Line 1004: l_last_update_login := fnd_global.login_id;

1000: l_creation_date := SYSDATE;
1001: l_last_update_date := SYSDATE;
1002: l_created_by := fnd_global.user_id;
1003: l_last_updated_by := fnd_global.user_id;
1004: l_last_update_login := fnd_global.login_id;
1005:
1006:
1007: --insert into table mtl_transactions_interface
1008: BEGIN

Line 1115: l_created_by := fnd_global.user_id;

1111: -- Populate the row who columns
1112:
1113: l_creation_date := SYSDATE;
1114: l_last_update_date := SYSDATE;
1115: l_created_by := fnd_global.user_id;
1116: l_last_updated_by := fnd_global.user_id;
1117: l_last_update_login := fnd_global.login_id;
1118:
1119:

Line 1116: l_last_updated_by := fnd_global.user_id;

1112:
1113: l_creation_date := SYSDATE;
1114: l_last_update_date := SYSDATE;
1115: l_created_by := fnd_global.user_id;
1116: l_last_updated_by := fnd_global.user_id;
1117: l_last_update_login := fnd_global.login_id;
1118:
1119:
1120: --insert into table mtl_transactions_interface

Line 1117: l_last_update_login := fnd_global.login_id;

1113: l_creation_date := SYSDATE;
1114: l_last_update_date := SYSDATE;
1115: l_created_by := fnd_global.user_id;
1116: l_last_updated_by := fnd_global.user_id;
1117: l_last_update_login := fnd_global.login_id;
1118:
1119:
1120: --insert into table mtl_transactions_interface
1121: BEGIN

Line 1223: l_created_by_name := fnd_global.user_name;

1219: -- Populate the row who columns
1220:
1221: l_creation_date := SYSDATE;
1222: l_last_update_date := SYSDATE;
1223: l_created_by_name := fnd_global.user_name;
1224: l_last_updated_by := fnd_global.user_id;
1225: l_last_updated_by_name := fnd_global.user_name;
1226: l_last_update_login := fnd_global.login_id;
1227:

Line 1224: l_last_updated_by := fnd_global.user_id;

1220:
1221: l_creation_date := SYSDATE;
1222: l_last_update_date := SYSDATE;
1223: l_created_by_name := fnd_global.user_name;
1224: l_last_updated_by := fnd_global.user_id;
1225: l_last_updated_by_name := fnd_global.user_name;
1226: l_last_update_login := fnd_global.login_id;
1227:
1228:

Line 1225: l_last_updated_by_name := fnd_global.user_name;

1221: l_creation_date := SYSDATE;
1222: l_last_update_date := SYSDATE;
1223: l_created_by_name := fnd_global.user_name;
1224: l_last_updated_by := fnd_global.user_id;
1225: l_last_updated_by_name := fnd_global.user_name;
1226: l_last_update_login := fnd_global.login_id;
1227:
1228:
1229: --insert into table wip_cost_txn_interface

Line 1226: l_last_update_login := fnd_global.login_id;

1222: l_last_update_date := SYSDATE;
1223: l_created_by_name := fnd_global.user_name;
1224: l_last_updated_by := fnd_global.user_id;
1225: l_last_updated_by_name := fnd_global.user_name;
1226: l_last_update_login := fnd_global.login_id;
1227:
1228:
1229: --insert into table wip_cost_txn_interface
1230: BEGIN

Line 1357: l_created_by := fnd_global.user_id;

1353: -- Populate the row who columns
1354:
1355: l_creation_date := SYSDATE;
1356: l_last_update_date := SYSDATE;
1357: l_created_by := fnd_global.user_id;
1358: l_created_by_name := fnd_global.user_name;
1359: l_last_updated_by := fnd_global.user_id;
1360: l_last_updated_by_name := fnd_global.user_name;
1361: l_last_update_login := fnd_global.login_id;

Line 1358: l_created_by_name := fnd_global.user_name;

1354:
1355: l_creation_date := SYSDATE;
1356: l_last_update_date := SYSDATE;
1357: l_created_by := fnd_global.user_id;
1358: l_created_by_name := fnd_global.user_name;
1359: l_last_updated_by := fnd_global.user_id;
1360: l_last_updated_by_name := fnd_global.user_name;
1361: l_last_update_login := fnd_global.login_id;
1362:

Line 1359: l_last_updated_by := fnd_global.user_id;

1355: l_creation_date := SYSDATE;
1356: l_last_update_date := SYSDATE;
1357: l_created_by := fnd_global.user_id;
1358: l_created_by_name := fnd_global.user_name;
1359: l_last_updated_by := fnd_global.user_id;
1360: l_last_updated_by_name := fnd_global.user_name;
1361: l_last_update_login := fnd_global.login_id;
1362:
1363:

Line 1360: l_last_updated_by_name := fnd_global.user_name;

1356: l_last_update_date := SYSDATE;
1357: l_created_by := fnd_global.user_id;
1358: l_created_by_name := fnd_global.user_name;
1359: l_last_updated_by := fnd_global.user_id;
1360: l_last_updated_by_name := fnd_global.user_name;
1361: l_last_update_login := fnd_global.login_id;
1362:
1363:
1364:

Line 1361: l_last_update_login := fnd_global.login_id;

1357: l_created_by := fnd_global.user_id;
1358: l_created_by_name := fnd_global.user_name;
1359: l_last_updated_by := fnd_global.user_id;
1360: l_last_updated_by_name := fnd_global.user_name;
1361: l_last_update_login := fnd_global.login_id;
1362:
1363:
1364:
1365: --insert into table wip_move_txn_interface

Line 1450: fnd_global.user_id,

1446: wip_entity_id,
1447: primary_quantity
1448: )
1449: SELECT
1450: fnd_global.user_id,
1451: SYSDATE,
1452: SYSDATE,
1453: fnd_global.login_id,
1454: fnd_global.user_id,

Line 1453: fnd_global.login_id,

1449: SELECT
1450: fnd_global.user_id,
1451: SYSDATE,
1452: SYSDATE,
1453: fnd_global.login_id,
1454: fnd_global.user_id,
1455: operation_seq_num,
1456: quantity_completed,
1457: p_interface_id,

Line 1454: fnd_global.user_id,

1450: fnd_global.user_id,
1451: SYSDATE,
1452: SYSDATE,
1453: fnd_global.login_id,
1454: fnd_global.user_id,
1455: operation_seq_num,
1456: quantity_completed,
1457: p_interface_id,
1458: p_wip_entity_id,

Line 1505: fnd_global.login_id,

1501: wro.inventory_item_id,
1502: wro.wip_entity_id,
1503: wro.operation_seq_num,
1504: to_number('1'),
1505: fnd_global.login_id,
1506: fnd_global.user_id created_by,
1507: sysdate creation_date,
1508: fnd_global.user_id last_updated_by,
1509: sysdate last_update_date

Line 1506: fnd_global.user_id created_by,

1502: wro.wip_entity_id,
1503: wro.operation_seq_num,
1504: to_number('1'),
1505: fnd_global.login_id,
1506: fnd_global.user_id created_by,
1507: sysdate creation_date,
1508: fnd_global.user_id last_updated_by,
1509: sysdate last_update_date
1510: FROM csd_repair_job_xref crj,wip_requirement_operations wro

Line 1508: fnd_global.user_id last_updated_by,

1504: to_number('1'),
1505: fnd_global.login_id,
1506: fnd_global.user_id created_by,
1507: sysdate creation_date,
1508: fnd_global.user_id last_updated_by,
1509: sysdate last_update_date
1510: FROM csd_repair_job_xref crj,wip_requirement_operations wro
1511: WHERE crj.wip_entity_id = wro.wip_entity_id
1512: AND crj.repair_line_id = p_repair_line_id

Line 1539: fnd_global.login_id,

1535: SELECT wro.inventory_item_id,
1536: wro.wip_entity_id,
1537: wro.operation_seq_num,
1538: to_number('1'),
1539: fnd_global.login_id,
1540: fnd_global.user_id created_by,
1541: sysdate creation_date,
1542: fnd_global.user_id last_updated_by,
1543: sysdate last_update_date

Line 1540: fnd_global.user_id created_by,

1536: wro.wip_entity_id,
1537: wro.operation_seq_num,
1538: to_number('1'),
1539: fnd_global.login_id,
1540: fnd_global.user_id created_by,
1541: sysdate creation_date,
1542: fnd_global.user_id last_updated_by,
1543: sysdate last_update_date
1544: FROM wip_requirement_operations wro

Line 1542: fnd_global.user_id last_updated_by,

1538: to_number('1'),
1539: fnd_global.login_id,
1540: fnd_global.user_id created_by,
1541: sysdate creation_date,
1542: fnd_global.user_id last_updated_by,
1543: sysdate last_update_date
1544: FROM wip_requirement_operations wro
1545: WHERE wro.wip_entity_id = p_wip_entity_id
1546: AND NOT EXISTS (SELECT 'exists'

Line 1569: fnd_global.login_id,

1565: SELECT wro.inventory_item_id,
1566: wro.wip_entity_id,
1567: wro.operation_seq_num,
1568: to_number('1'),
1569: fnd_global.login_id,
1570: fnd_global.user_id created_by,
1571: sysdate creation_date,
1572: fnd_global.user_id last_updated_by,
1573: sysdate last_update_date

Line 1570: fnd_global.user_id created_by,

1566: wro.wip_entity_id,
1567: wro.operation_seq_num,
1568: to_number('1'),
1569: fnd_global.login_id,
1570: fnd_global.user_id created_by,
1571: sysdate creation_date,
1572: fnd_global.user_id last_updated_by,
1573: sysdate last_update_date
1574: FROM wip_requirement_operations wro,csd_repair_job_xref crj

Line 1572: fnd_global.user_id last_updated_by,

1568: to_number('1'),
1569: fnd_global.login_id,
1570: fnd_global.user_id created_by,
1571: sysdate creation_date,
1572: fnd_global.user_id last_updated_by,
1573: sysdate last_update_date
1574: FROM wip_requirement_operations wro,csd_repair_job_xref crj
1575: WHERE crj.wip_entity_id = wro.wip_entity_id
1576: AND NOT EXISTS (SELECT 'exists'

Line 2962: l_last_updated_by := fnd_global.user_id;

2958:
2959: -- Populate the row who columns
2960:
2961: l_last_update_date := SYSDATE;
2962: l_last_updated_by := fnd_global.user_id;
2963: l_last_update_login := fnd_global.login_id;
2964:
2965:
2966: -- generate transaction_header_id

Line 2963: l_last_update_login := fnd_global.login_id;

2959: -- Populate the row who columns
2960:
2961: l_last_update_date := SYSDATE;
2962: l_last_updated_by := fnd_global.user_id;
2963: l_last_update_login := fnd_global.login_id;
2964:
2965:
2966: -- generate transaction_header_id
2967: open get_mtl_header_id;

Line 4201: l_last_updated_by := fnd_global.user_id;

4197:
4198: -- Populate the row who columns
4199:
4200: l_last_update_date := SYSDATE;
4201: l_last_updated_by := fnd_global.user_id;
4202: l_last_update_login := fnd_global.login_id;
4203:
4204:
4205: -- Populate the constant values

Line 4202: l_last_update_login := fnd_global.login_id;

4198: -- Populate the row who columns
4199:
4200: l_last_update_date := SYSDATE;
4201: l_last_updated_by := fnd_global.user_id;
4202: l_last_update_login := fnd_global.login_id;
4203:
4204:
4205: -- Populate the constant values
4206:

Line 4809: l_created_by := fnd_global.user_id;

4805: -- Populate the row who columns
4806:
4807: l_creation_date := SYSDATE;
4808: l_last_update_date := SYSDATE;
4809: l_created_by := fnd_global.user_id;
4810: l_last_updated_by := fnd_global.user_id;
4811: l_last_update_login := fnd_global.login_id;
4812:
4813:

Line 4810: l_last_updated_by := fnd_global.user_id;

4806:
4807: l_creation_date := SYSDATE;
4808: l_last_update_date := SYSDATE;
4809: l_created_by := fnd_global.user_id;
4810: l_last_updated_by := fnd_global.user_id;
4811: l_last_update_login := fnd_global.login_id;
4812:
4813:
4814:

Line 4811: l_last_update_login := fnd_global.login_id;

4807: l_creation_date := SYSDATE;
4808: l_last_update_date := SYSDATE;
4809: l_created_by := fnd_global.user_id;
4810: l_last_updated_by := fnd_global.user_id;
4811: l_last_update_login := fnd_global.login_id;
4812:
4813:
4814:
4815:

Line 5560: l_created_by := fnd_global.user_id;

5556: -- Populate the row who columns
5557:
5558: l_creation_date := SYSDATE;
5559: l_last_update_date := SYSDATE;
5560: l_created_by := fnd_global.user_id;
5561: l_last_updated_by := fnd_global.user_id;
5562: l_last_update_login := fnd_global.login_id;
5563:
5564: FOR res_ctr in p_res_txn_dtls_tbl.FIRST.. p_res_txn_dtls_tbl.LAST

Line 5561: l_last_updated_by := fnd_global.user_id;

5557:
5558: l_creation_date := SYSDATE;
5559: l_last_update_date := SYSDATE;
5560: l_created_by := fnd_global.user_id;
5561: l_last_updated_by := fnd_global.user_id;
5562: l_last_update_login := fnd_global.login_id;
5563:
5564: FOR res_ctr in p_res_txn_dtls_tbl.FIRST.. p_res_txn_dtls_tbl.LAST
5565:

Line 5562: l_last_update_login := fnd_global.login_id;

5558: l_creation_date := SYSDATE;
5559: l_last_update_date := SYSDATE;
5560: l_created_by := fnd_global.user_id;
5561: l_last_updated_by := fnd_global.user_id;
5562: l_last_update_login := fnd_global.login_id;
5563:
5564: FOR res_ctr in p_res_txn_dtls_tbl.FIRST.. p_res_txn_dtls_tbl.LAST
5565:
5566: LOOP

Line 5977: l_created_by := fnd_global.user_id;

5973:
5974: -- Get the data for the WHO columns
5975: l_creation_date := SYSDATE;
5976: l_last_update_date := SYSDATE;
5977: l_created_by := fnd_global.user_id;
5978: l_last_updated_by := fnd_global.user_id;
5979: l_last_update_login := fnd_global.login_id;
5980:
5981: FOR op_ctr in p_op_dtls_tbl.FIRST.. p_op_dtls_tbl.LAST

Line 5978: l_last_updated_by := fnd_global.user_id;

5974: -- Get the data for the WHO columns
5975: l_creation_date := SYSDATE;
5976: l_last_update_date := SYSDATE;
5977: l_created_by := fnd_global.user_id;
5978: l_last_updated_by := fnd_global.user_id;
5979: l_last_update_login := fnd_global.login_id;
5980:
5981: FOR op_ctr in p_op_dtls_tbl.FIRST.. p_op_dtls_tbl.LAST
5982: LOOP

Line 5979: l_last_update_login := fnd_global.login_id;

5975: l_creation_date := SYSDATE;
5976: l_last_update_date := SYSDATE;
5977: l_created_by := fnd_global.user_id;
5978: l_last_updated_by := fnd_global.user_id;
5979: l_last_update_login := fnd_global.login_id;
5980:
5981: FOR op_ctr in p_op_dtls_tbl.FIRST.. p_op_dtls_tbl.LAST
5982: LOOP
5983: -- l_operation_seq_num := p_op_dtls_tbl(op_ctr).operation_seq_num;

Line 6819: L_user_id := fnd_global.user_id;

6815:
6816: -- call procedures to insert a row in csd_repair_job_xref
6817: -- and csd_repair_history tables for the job created.
6818:
6819: L_user_id := fnd_global.user_id;
6820:
6821: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6822: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
6823: lc_mod_name||'beforecallxrefwrite',

Line 7690: l_user_id := fnd_global.user_id;

7686:
7687: -- call procedures to insert a row in csd_repair_job_xref
7688: -- and csd_repair_history tables for the job created.
7689:
7690: l_user_id := fnd_global.user_id;
7691:
7692: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
7693: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
7694: lc_mod_name||'beforecallxrefwrite',

Line 9727: ,p_LAST_UPDATED_BY => fnd_global.user_id

9723: CSD_WIP_TRANSACTION_DTLS_PKG.Update_Row (
9724: p_WIP_TRANSACTION_DETAIL_ID => l_txn_detail_id
9725: ,p_CREATED_BY => null
9726: ,p_CREATION_DATE => null
9727: ,p_LAST_UPDATED_BY => fnd_global.user_id
9728: ,p_LAST_UPDATE_DATE => sysdate
9729: ,p_LAST_UPDATE_LOGIN => fnd_global.login_id
9730: ,p_INVENTORY_ITEM_ID => null
9731: ,p_WIP_ENTITY_ID => null

Line 9729: ,p_LAST_UPDATE_LOGIN => fnd_global.login_id

9725: ,p_CREATED_BY => null
9726: ,p_CREATION_DATE => null
9727: ,p_LAST_UPDATED_BY => fnd_global.user_id
9728: ,p_LAST_UPDATE_DATE => sysdate
9729: ,p_LAST_UPDATE_LOGIN => fnd_global.login_id
9730: ,p_INVENTORY_ITEM_ID => null
9731: ,p_WIP_ENTITY_ID => null
9732: ,p_OPERATION_SEQ_NUM => null
9733: ,p_RESOURCE_SEQ_NUM => null