DBA Data[Home] [Help]

APPS.WSH_CUST_MERGE dependencies on FND_GLOBAL

Line 723: last_updated_by = fnd_global.user_id,

719: FORALL updCnt in l_deliveryDetailRowidTab.FIRST..l_deliveryDetailRowidTab.LAST
720: UPDATE Wsh_Delivery_Details Wdd
721: SET Customer_Id = l_customerIdTab(updCnt),
722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,
725: program_application_id = fnd_global.prog_appl_id,
726: program_id = fnd_global.conc_program_id,
727: program_update_date = SYSDATE

Line 724: last_update_login = fnd_global.conc_login_id,

720: UPDATE Wsh_Delivery_Details Wdd
721: SET Customer_Id = l_customerIdTab(updCnt),
722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,
725: program_application_id = fnd_global.prog_appl_id,
726: program_id = fnd_global.conc_program_id,
727: program_update_date = SYSDATE
728: WHERE rowid = l_deliveryDetailRowidTab(updCnt);

Line 725: program_application_id = fnd_global.prog_appl_id,

721: SET Customer_Id = l_customerIdTab(updCnt),
722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,
725: program_application_id = fnd_global.prog_appl_id,
726: program_id = fnd_global.conc_program_id,
727: program_update_date = SYSDATE
728: WHERE rowid = l_deliveryDetailRowidTab(updCnt);
729:

Line 726: program_id = fnd_global.conc_program_id,

722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,
725: program_application_id = fnd_global.prog_appl_id,
726: program_id = fnd_global.conc_program_id,
727: program_update_date = SYSDATE
728: WHERE rowid = l_deliveryDetailRowidTab(updCnt);
729:
730: --

Line 800: last_updated_by = fnd_global.user_id,

796: UPDATE WSH_DELIVERY_ASSIGNMENTS
797: SET parent_delivery_detail_id = null,
798: delivery_id = null,
799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,
801: last_update_login = fnd_global.conc_login_id,
802: program_application_id = fnd_global.prog_appl_id,
803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE

Line 801: last_update_login = fnd_global.conc_login_id,

797: SET parent_delivery_detail_id = null,
798: delivery_id = null,
799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,
801: last_update_login = fnd_global.conc_login_id,
802: program_application_id = fnd_global.prog_appl_id,
803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE
805: WHERE rowid = l_deliveryAssgRowidTab(unassignDelCnt);

Line 802: program_application_id = fnd_global.prog_appl_id,

798: delivery_id = null,
799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,
801: last_update_login = fnd_global.conc_login_id,
802: program_application_id = fnd_global.prog_appl_id,
803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE
805: WHERE rowid = l_deliveryAssgRowidTab(unassignDelCnt);
806:

Line 803: program_id = fnd_global.conc_program_id,

799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,
801: last_update_login = fnd_global.conc_login_id,
802: program_application_id = fnd_global.prog_appl_id,
803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE
805: WHERE rowid = l_deliveryAssgRowidTab(unassignDelCnt);
806:
807: setARMessageRowCount( 'WSH_DELIVERY_ASSIGNMENTS', SQL%ROWCOUNT );

Line 1022: p_logging_entity_id => Fnd_Global.user_id,

1018: x_exception_id => l_exception_id,
1019: p_exception_location_id => G_TO_LOCATION_ID,
1020: p_logged_at_location_id => G_TO_LOCATION_ID,
1021: p_logging_entity => 'SHIPPER',
1022: p_logging_entity_id => Fnd_Global.user_id,
1023: p_exception_name => 'WSH_CUSTOMER_MERGE_CHANGE',
1024: p_message => l_message_text,
1025: p_severity => 'LOW',
1026: p_manually_logged => 'N',

Line 2030: p_logging_entity_id => Fnd_Global.user_id,

2026: x_exception_id => l_exception_id,
2027: p_exception_location_id => G_TO_LOCATION_ID,
2028: p_logged_at_location_id => G_TO_LOCATION_ID,
2029: p_logging_entity => 'SHIPPER',
2030: p_logging_entity_id => Fnd_Global.user_id,
2031: p_exception_name => 'WSH_CUSTOMER_MERGE_CHANGE',
2032: p_message => l_message_text,
2033: p_severity => 'LOW',
2034: p_manually_logged => 'N',

Line 2763: p_logging_entity_id => Fnd_Global.user_id,

2759: x_exception_id => l_exception_id,
2760: p_exception_location_id => G_TO_LOCATION_ID,
2761: p_logged_at_location_id => G_TO_LOCATION_ID,
2762: p_logging_entity => 'SHIPPER',
2763: p_logging_entity_id => Fnd_Global.user_id,
2764: p_exception_name => 'WSH_CUSTOMER_MERGE_CHANGE',
2765: p_message => l_message_text,
2766: p_severity => 'LOW',
2767: p_manually_logged => 'N',