DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on FND_GLOBAL

Line 183: FND_GLOBAL.user_id, --last_updated_by

179: l_vendor_name_list(i),
180: p_group_id,
181: p_po_user_id,
182: SYSDATE, --creation_date
183: FND_GLOBAL.user_id, --last_updated_by
184: SYSDATE, --last_update_date
185: FND_GLOBAL.conc_login_id, --last_update_login
186: FND_GLOBAL.conc_request_id --request_id
187: );

Line 185: FND_GLOBAL.conc_login_id, --last_update_login

181: p_po_user_id,
182: SYSDATE, --creation_date
183: FND_GLOBAL.user_id, --last_updated_by
184: SYSDATE, --last_update_date
185: FND_GLOBAL.conc_login_id, --last_update_login
186: FND_GLOBAL.conc_request_id --request_id
187: );
188:
189:

Line 186: FND_GLOBAL.conc_request_id --request_id

182: SYSDATE, --creation_date
183: FND_GLOBAL.user_id, --last_updated_by
184: SYSDATE, --last_update_date
185: FND_GLOBAL.conc_login_id, --last_update_login
186: FND_GLOBAL.conc_request_id --request_id
187: );
188:
189:
190: --------------------------------------------------

Line 407: FND_GLOBAL.user_id, --last_updated_by

403: l_po_shipment_num_list(i),
404: l_unit_price_list(i),
405: p_po_user_id,
406: SYSDATE, --creation_date
407: FND_GLOBAL.user_id, --last_updated_by
408: SYSDATE, --last_update_date
409: FND_GLOBAL.conc_login_id --last_update_login
410: );
411:

Line 409: FND_GLOBAL.conc_login_id --last_update_login

405: p_po_user_id,
406: SYSDATE, --creation_date
407: FND_GLOBAL.user_id, --last_updated_by
408: SYSDATE, --last_update_date
409: FND_GLOBAL.conc_login_id --last_update_login
410: );
411:
412: END IF; /* l_po_line_loc_id_list.count > 0 */
413:

Line 5241: FND_GLOBAL.user_id, --bugfix:4681253

5237: base_amount,
5238: amount_applicable_to_discount,
5239: payment_method_code, --4552701
5240: exclusive_payment_flag,
5241: FND_GLOBAL.user_id, --bugfix:4681253
5242: FND_GLOBAL.user_id, --bugfix:4681253
5243: batch_id
5244: FROM ap_ppa_invoices_gt
5245: WHERE instruction_id = p_instruction_id

Line 5242: FND_GLOBAL.user_id, --bugfix:4681253

5238: amount_applicable_to_discount,
5239: payment_method_code, --4552701
5240: exclusive_payment_flag,
5241: FND_GLOBAL.user_id, --bugfix:4681253
5242: FND_GLOBAL.user_id, --bugfix:4681253
5243: batch_id
5244: FROM ap_ppa_invoices_gt
5245: WHERE instruction_id = p_instruction_id
5246: AND instr_status_flag = 'Y';

Line 5596: FND_GLOBAL.user_id, --created_by

5592: vendor_id,
5593: vendor_site_id,
5594: wfapproval_status,
5595: SYSDATE, --creation_date
5596: FND_GLOBAL.user_id, --created_by
5597: FND_GLOBAL.user_id, --last_updated_by
5598: SYSDATE, --last_update_date
5599: FND_GLOBAL.conc_login_id, --last_update_login
5600: SYSDATE, --4681253

Line 5597: FND_GLOBAL.user_id, --last_updated_by

5593: vendor_site_id,
5594: wfapproval_status,
5595: SYSDATE, --creation_date
5596: FND_GLOBAL.user_id, --created_by
5597: FND_GLOBAL.user_id, --last_updated_by
5598: SYSDATE, --last_update_date
5599: FND_GLOBAL.conc_login_id, --last_update_login
5600: SYSDATE, --4681253
5601: APPLICATION_ID ,

Line 5599: FND_GLOBAL.conc_login_id, --last_update_login

5595: SYSDATE, --creation_date
5596: FND_GLOBAL.user_id, --created_by
5597: FND_GLOBAL.user_id, --last_updated_by
5598: SYSDATE, --last_update_date
5599: FND_GLOBAL.conc_login_id, --last_update_login
5600: SYSDATE, --4681253
5601: APPLICATION_ID ,
5602: BANK_CHARGE_BEARER ,
5603: DELIVERY_CHANNEL_CODE ,

Line 5974: FND_GLOBAL.user_id, --created_by

5970: tax_rate,
5971: wfapproval_status,
5972: pa_quantity,
5973: SYSDATE, --creation_date
5974: FND_GLOBAL.user_id, --created_by
5975: FND_GLOBAL.user_id, --last_updated_by
5976: SYSDATE, --last_update_date
5977: FND_GLOBAL.conc_login_id, --last_update_login
5978: FND_GLOBAL.prog_appl_id, --program_application_id

Line 5975: FND_GLOBAL.user_id, --last_updated_by

5971: wfapproval_status,
5972: pa_quantity,
5973: SYSDATE, --creation_date
5974: FND_GLOBAL.user_id, --created_by
5975: FND_GLOBAL.user_id, --last_updated_by
5976: SYSDATE, --last_update_date
5977: FND_GLOBAL.conc_login_id, --last_update_login
5978: FND_GLOBAL.prog_appl_id, --program_application_id
5979: FND_GLOBAL.conc_program_id,--program_id

Line 5977: FND_GLOBAL.conc_login_id, --last_update_login

5973: SYSDATE, --creation_date
5974: FND_GLOBAL.user_id, --created_by
5975: FND_GLOBAL.user_id, --last_updated_by
5976: SYSDATE, --last_update_date
5977: FND_GLOBAL.conc_login_id, --last_update_login
5978: FND_GLOBAL.prog_appl_id, --program_application_id
5979: FND_GLOBAL.conc_program_id,--program_id
5980: SYSDATE, -- program_update_date
5981: FND_GLOBAL.conc_request_id --request_id

Line 5978: FND_GLOBAL.prog_appl_id, --program_application_id

5974: FND_GLOBAL.user_id, --created_by
5975: FND_GLOBAL.user_id, --last_updated_by
5976: SYSDATE, --last_update_date
5977: FND_GLOBAL.conc_login_id, --last_update_login
5978: FND_GLOBAL.prog_appl_id, --program_application_id
5979: FND_GLOBAL.conc_program_id,--program_id
5980: SYSDATE, -- program_update_date
5981: FND_GLOBAL.conc_request_id --request_id
5982: FROM ap_ppa_invoice_lines_gt

Line 5979: FND_GLOBAL.conc_program_id,--program_id

5975: FND_GLOBAL.user_id, --last_updated_by
5976: SYSDATE, --last_update_date
5977: FND_GLOBAL.conc_login_id, --last_update_login
5978: FND_GLOBAL.prog_appl_id, --program_application_id
5979: FND_GLOBAL.conc_program_id,--program_id
5980: SYSDATE, -- program_update_date
5981: FND_GLOBAL.conc_request_id --request_id
5982: FROM ap_ppa_invoice_lines_gt
5983: WHERE instruction_id = p_instruction_id

Line 5981: FND_GLOBAL.conc_request_id --request_id

5977: FND_GLOBAL.conc_login_id, --last_update_login
5978: FND_GLOBAL.prog_appl_id, --program_application_id
5979: FND_GLOBAL.conc_program_id,--program_id
5980: SYSDATE, -- program_update_date
5981: FND_GLOBAL.conc_request_id --request_id
5982: FROM ap_ppa_invoice_lines_gt
5983: WHERE instruction_id = p_instruction_id
5984: AND invoice_id = l_ppa_invoice_id
5985: AND adj_type = 'PPA';

Line 6200: FND_GLOBAL.user_id, --created_by,

6196: task_id,
6197: type_1099,
6198: unit_price,
6199: SYSDATE, --creation_date,
6200: FND_GLOBAL.user_id, --created_by,
6201: FND_GLOBAL.user_id, --last_updated_by,
6202: SYSDATE, --last_update_date,
6203: FND_GLOBAL.conc_login_id, --last_update_login,
6204: FND_GLOBAL.prog_appl_id, --program_application_id,

Line 6201: FND_GLOBAL.user_id, --last_updated_by,

6197: type_1099,
6198: unit_price,
6199: SYSDATE, --creation_date,
6200: FND_GLOBAL.user_id, --created_by,
6201: FND_GLOBAL.user_id, --last_updated_by,
6202: SYSDATE, --last_update_date,
6203: FND_GLOBAL.conc_login_id, --last_update_login,
6204: FND_GLOBAL.prog_appl_id, --program_application_id,
6205: FND_GLOBAL.conc_program_id, --program_id,

Line 6203: FND_GLOBAL.conc_login_id, --last_update_login,

6199: SYSDATE, --creation_date,
6200: FND_GLOBAL.user_id, --created_by,
6201: FND_GLOBAL.user_id, --last_updated_by,
6202: SYSDATE, --last_update_date,
6203: FND_GLOBAL.conc_login_id, --last_update_login,
6204: FND_GLOBAL.prog_appl_id, --program_application_id,
6205: FND_GLOBAL.conc_program_id, --program_id,
6206: SYSDATE, --program_update_date,
6207: FND_GLOBAL.conc_request_id, --request_id,

Line 6204: FND_GLOBAL.prog_appl_id, --program_application_id,

6200: FND_GLOBAL.user_id, --created_by,
6201: FND_GLOBAL.user_id, --last_updated_by,
6202: SYSDATE, --last_update_date,
6203: FND_GLOBAL.conc_login_id, --last_update_login,
6204: FND_GLOBAL.prog_appl_id, --program_application_id,
6205: FND_GLOBAL.conc_program_id, --program_id,
6206: SYSDATE, --program_update_date,
6207: FND_GLOBAL.conc_request_id, --request_id,
6208: 'N' --rcv_charge_addition_flag

Line 6205: FND_GLOBAL.conc_program_id, --program_id,

6201: FND_GLOBAL.user_id, --last_updated_by,
6202: SYSDATE, --last_update_date,
6203: FND_GLOBAL.conc_login_id, --last_update_login,
6204: FND_GLOBAL.prog_appl_id, --program_application_id,
6205: FND_GLOBAL.conc_program_id, --program_id,
6206: SYSDATE, --program_update_date,
6207: FND_GLOBAL.conc_request_id, --request_id,
6208: 'N' --rcv_charge_addition_flag
6209: FROM ap_ppa_invoice_dists_gt

Line 6207: FND_GLOBAL.conc_request_id, --request_id,

6203: FND_GLOBAL.conc_login_id, --last_update_login,
6204: FND_GLOBAL.prog_appl_id, --program_application_id,
6205: FND_GLOBAL.conc_program_id, --program_id,
6206: SYSDATE, --program_update_date,
6207: FND_GLOBAL.conc_request_id, --request_id,
6208: 'N' --rcv_charge_addition_flag
6209: FROM ap_ppa_invoice_dists_gt
6210: WHERE instruction_id = p_instruction_id
6211: AND invoice_id = l_ppa_invoice_id;

Line 6397: FND_GLOBAL.conc_login_id,

6393: CURSOR po_dists(c_po_line_location_id IN NUMBER) IS
6394: SELECT d.po_distribution_id,
6395: d.matched_uom_lookup_code,
6396: d.amount,
6397: FND_GLOBAL.conc_login_id,
6398: FND_GLOBAL.conc_request_id
6399: FROM ap_ppa_invoice_dists_gt d,
6400: ap_ppa_invoice_lines_gt l,
6401: po_distributions_all pd

Line 6398: FND_GLOBAL.conc_request_id

6394: SELECT d.po_distribution_id,
6395: d.matched_uom_lookup_code,
6396: d.amount,
6397: FND_GLOBAL.conc_login_id,
6398: FND_GLOBAL.conc_request_id
6399: FROM ap_ppa_invoice_dists_gt d,
6400: ap_ppa_invoice_lines_gt l,
6401: po_distributions_all pd
6402: WHERE l.instruction_id = d.instruction_id

Line 6453: FND_GLOBAL.user_id,

6449: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
6450: 'AP_INVOICES_INTERFACE',
6451: p_instruction_rec.invoice_id,
6452: 'ORIGINAL INVOICE NOT VALIDATED',
6453: FND_GLOBAL.user_id,
6454: FND_GLOBAL.login_id,
6455: current_calling_sequence) <> TRUE) THEN
6456: --
6457: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 6454: FND_GLOBAL.login_id,

6450: 'AP_INVOICES_INTERFACE',
6451: p_instruction_rec.invoice_id,
6452: 'ORIGINAL INVOICE NOT VALIDATED',
6453: FND_GLOBAL.user_id,
6454: FND_GLOBAL.login_id,
6455: current_calling_sequence) <> TRUE) THEN
6456: --
6457: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
6458: AP_IMPORT_UTILITIES_PKG.Print(

Line 6498: FND_GLOBAL.user_id,

6494: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
6495: ('AP_INVOICES_INTERFACE',
6496: p_instruction_rec.invoice_id,
6497: 'ORIGINAL INVOICE HAS A HOLD',
6498: FND_GLOBAL.user_id,
6499: FND_GLOBAL.login_id,
6500: current_calling_sequence) <> TRUE) THEN
6501: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
6502: AP_IMPORT_UTILITIES_PKG.Print(

Line 6499: FND_GLOBAL.login_id,

6495: ('AP_INVOICES_INTERFACE',
6496: p_instruction_rec.invoice_id,
6497: 'ORIGINAL INVOICE HAS A HOLD',
6498: FND_GLOBAL.user_id,
6499: FND_GLOBAL.login_id,
6500: current_calling_sequence) <> TRUE) THEN
6501: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
6502: AP_IMPORT_UTILITIES_PKG.Print(
6503: AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 6545: FND_GLOBAL.user_id,

6541: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
6542: ('AP_INVOICES_INTERFACE',
6543: p_instruction_rec.invoice_id,
6544: 'NO SEQUENCE DEFINED FOR PPA',
6545: FND_GLOBAL.user_id,
6546: FND_GLOBAL.login_id,
6547: current_calling_sequence) <> TRUE) THEN
6548: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
6549: AP_IMPORT_UTILITIES_PKG.Print(

Line 6546: FND_GLOBAL.login_id,

6542: ('AP_INVOICES_INTERFACE',
6543: p_instruction_rec.invoice_id,
6544: 'NO SEQUENCE DEFINED FOR PPA',
6545: FND_GLOBAL.user_id,
6546: FND_GLOBAL.login_id,
6547: current_calling_sequence) <> TRUE) THEN
6548: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
6549: AP_IMPORT_UTILITIES_PKG.Print(
6550: AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 6980: last_updated_by = FND_GLOBAL.user_id,

6976: ELSE
6977:
6978: UPDATE po_distributions_all pd
6979: SET last_update_date = SYSDATE,
6980: last_updated_by = FND_GLOBAL.user_id,
6981: last_update_login = FND_GLOBAL.conc_login_id,
6982: request_id = FND_GLOBAL.conc_request_id,
6983: invoice_adjustment_flag = 'R'
6984: WHERE invoice_adjustment_flag = 'S'

Line 6981: last_update_login = FND_GLOBAL.conc_login_id,

6977:
6978: UPDATE po_distributions_all pd
6979: SET last_update_date = SYSDATE,
6980: last_updated_by = FND_GLOBAL.user_id,
6981: last_update_login = FND_GLOBAL.conc_login_id,
6982: request_id = FND_GLOBAL.conc_request_id,
6983: invoice_adjustment_flag = 'R'
6984: WHERE invoice_adjustment_flag = 'S'
6985: AND po_distribution_id IN (

Line 6982: request_id = FND_GLOBAL.conc_request_id,

6978: UPDATE po_distributions_all pd
6979: SET last_update_date = SYSDATE,
6980: last_updated_by = FND_GLOBAL.user_id,
6981: last_update_login = FND_GLOBAL.conc_login_id,
6982: request_id = FND_GLOBAL.conc_request_id,
6983: invoice_adjustment_flag = 'R'
6984: WHERE invoice_adjustment_flag = 'S'
6985: AND po_distribution_id IN (
6986: SELECT d.po_distribution_id