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 1025: p_logging_entity_id => Fnd_Global.user_id,

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

Line 2033: p_logging_entity_id => Fnd_Global.user_id,

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

Line 2766: p_logging_entity_id => Fnd_Global.user_id,

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