DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG dependencies on FND_GLOBAL

Line 57: last_updated_by = fnd_global.user_id,

53: UPDATE csd_repairs
54: SET repair_mode = 'WIP',
55: auto_process_rma = 'N',
56: last_update_date = sysdate,
57: last_updated_by = fnd_global.user_id,
58: last_update_login = fnd_global.login_id
59: WHERE rowid = rowid_mig(j);
60: IF SQL%NOTFOUND then
61: Raise error_process;

Line 58: last_update_login = fnd_global.login_id

54: SET repair_mode = 'WIP',
55: auto_process_rma = 'N',
56: last_update_date = sysdate,
57: last_updated_by = fnd_global.user_id,
58: last_update_login = fnd_global.login_id
59: WHERE rowid = rowid_mig(j);
60: IF SQL%NOTFOUND then
61: Raise error_process;
62: End If;

Line 381: ,FND_GLOBAL.USER_ID

377: ,l_prod_txn_status
378: ,l_prod_txn_code
379: ,sysdate
380: ,l_creation_date
381: ,FND_GLOBAL.USER_ID
382: ,FND_GLOBAL.USER_ID
383: ,FND_GLOBAL.LOGIN_ID
384: ,NULL
385: ,NULL

Line 382: ,FND_GLOBAL.USER_ID

378: ,l_prod_txn_code
379: ,sysdate
380: ,l_creation_date
381: ,FND_GLOBAL.USER_ID
382: ,FND_GLOBAL.USER_ID
383: ,FND_GLOBAL.LOGIN_ID
384: ,NULL
385: ,NULL
386: ,NULL

Line 383: ,FND_GLOBAL.LOGIN_ID

379: ,sysdate
380: ,l_creation_date
381: ,FND_GLOBAL.USER_ID
382: ,FND_GLOBAL.USER_ID
383: ,FND_GLOBAL.LOGIN_ID
384: ,NULL
385: ,NULL
386: ,NULL
387: ,NULL

Line 624: ,FND_GLOBAL.USER_ID

620: ,l_work_summary
621: ,l_lead_time
622: ,l_lead_time_uom
623: ,l_estimate_date
624: ,FND_GLOBAL.USER_ID
625: ,FND_GLOBAL.USER_ID
626: ,sysdate
627: ,FND_GLOBAL.LOGIN_ID
628: ,1

Line 625: ,FND_GLOBAL.USER_ID

621: ,l_lead_time
622: ,l_lead_time_uom
623: ,l_estimate_date
624: ,FND_GLOBAL.USER_ID
625: ,FND_GLOBAL.USER_ID
626: ,sysdate
627: ,FND_GLOBAL.LOGIN_ID
628: ,1
629: ,l_estimate_freeze_flag);

Line 627: ,FND_GLOBAL.LOGIN_ID

623: ,l_estimate_date
624: ,FND_GLOBAL.USER_ID
625: ,FND_GLOBAL.USER_ID
626: ,sysdate
627: ,FND_GLOBAL.LOGIN_ID
628: ,1
629: ,l_estimate_freeze_flag);
630:
631: EXCEPTION

Line 791: ,FND_GLOBAL.USER_ID

787: VALUES (
788: CSD_REPAIR_ESTIMATE_LINES_S1.nextval
789: ,l_repair_estimate_id
790: ,l_creation_date
791: ,FND_GLOBAL.USER_ID
792: ,FND_GLOBAL.USER_ID
793: ,sysdate
794: ,FND_GLOBAL.LOGIN_ID
795: ,1

Line 792: ,FND_GLOBAL.USER_ID

788: CSD_REPAIR_ESTIMATE_LINES_S1.nextval
789: ,l_repair_estimate_id
790: ,l_creation_date
791: ,FND_GLOBAL.USER_ID
792: ,FND_GLOBAL.USER_ID
793: ,sysdate
794: ,FND_GLOBAL.LOGIN_ID
795: ,1
796: ,l_estimate_detail_id

Line 794: ,FND_GLOBAL.LOGIN_ID

790: ,l_creation_date
791: ,FND_GLOBAL.USER_ID
792: ,FND_GLOBAL.USER_ID
793: ,sysdate
794: ,FND_GLOBAL.LOGIN_ID
795: ,1
796: ,l_estimate_detail_id
797: ,l_item_cost);
798: EXCEPTION

Line 897: last_update_login = fnd_global.login_id,

893: BEGIN
894: UPDATE csd_repair_job_xref
895: SET inventory_item_id = inventory_item_id_mig(j),
896: last_update_date = sysdate,
897: last_update_login = fnd_global.login_id,
898: last_updated_by = fnd_global.user_id
899: WHERE rowid = rowid_mig(j);
900: EXCEPTION
901: WHEN OTHERS THEN

Line 898: last_updated_by = fnd_global.user_id

894: UPDATE csd_repair_job_xref
895: SET inventory_item_id = inventory_item_id_mig(j),
896: last_update_date = sysdate,
897: last_update_login = fnd_global.login_id,
898: last_updated_by = fnd_global.user_id
899: WHERE rowid = rowid_mig(j);
900: EXCEPTION
901: WHEN OTHERS THEN
902: -- when errored rollback and insert the message into

Line 1004: last_update_login = fnd_global.login_id,

1000: book_sales_order_flag = l_book_sales_order_flag,
1001: release_sales_order_flag = l_release_sales_order_flag,
1002: seeded_flag = l_seeded_flag,
1003: last_update_date = sysdate,
1004: last_update_login = fnd_global.login_id,
1005: last_updated_by = fnd_global.user_id
1006: WHERE rowid = rowid_mig(j);
1007: EXCEPTION
1008: WHEN OTHERS THEN

Line 1005: last_updated_by = fnd_global.user_id

1001: release_sales_order_flag = l_release_sales_order_flag,
1002: seeded_flag = l_seeded_flag,
1003: last_update_date = sysdate,
1004: last_update_login = fnd_global.login_id,
1005: last_updated_by = fnd_global.user_id
1006: WHERE rowid = rowid_mig(j);
1007: EXCEPTION
1008: WHEN OTHERS THEN
1009: -- when errored rollback and insert the message into