DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on FND_GLOBAL

Line 184: FND_GLOBAL.user_id, --last_updated_by

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

Line 186: FND_GLOBAL.conc_login_id, --last_update_login

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

Line 187: FND_GLOBAL.conc_request_id --request_id

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

Line 408: FND_GLOBAL.user_id, --last_updated_by

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

Line 410: FND_GLOBAL.conc_login_id --last_update_login

406: p_po_user_id,
407: SYSDATE, --creation_date
408: FND_GLOBAL.user_id, --last_updated_by
409: SYSDATE, --last_update_date
410: FND_GLOBAL.conc_login_id --last_update_login
411: );
412:
413: --Introduced below UPDATE for bug#9573078
414: -- and commented in CREATE_INSTRUCTIONS procedure

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

5591: base_amount,
5592: amount_applicable_to_discount,
5593: payment_method_code, --4552701
5594: exclusive_payment_flag,
5595: FND_GLOBAL.user_id, --bugfix:4681253
5596: FND_GLOBAL.user_id, --bugfix:4681253
5597: batch_id,
5598: org_id
5599: FROM ap_ppa_invoices_gt

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

5592: amount_applicable_to_discount,
5593: payment_method_code, --4552701
5594: exclusive_payment_flag,
5595: FND_GLOBAL.user_id, --bugfix:4681253
5596: FND_GLOBAL.user_id, --bugfix:4681253
5597: batch_id,
5598: org_id
5599: FROM ap_ppa_invoices_gt
5600: WHERE instruction_id = p_instruction_id

Line 6051: FND_GLOBAL.user_id, --created_by

6047: vendor_id,
6048: vendor_site_id,
6049: wfapproval_status,
6050: SYSDATE, --creation_date
6051: FND_GLOBAL.user_id, --created_by
6052: FND_GLOBAL.user_id, --last_updated_by
6053: SYSDATE, --last_update_date
6054: FND_GLOBAL.conc_login_id, --last_update_login
6055: SYSDATE, --4681253

Line 6052: FND_GLOBAL.user_id, --last_updated_by

6048: vendor_site_id,
6049: wfapproval_status,
6050: SYSDATE, --creation_date
6051: FND_GLOBAL.user_id, --created_by
6052: FND_GLOBAL.user_id, --last_updated_by
6053: SYSDATE, --last_update_date
6054: FND_GLOBAL.conc_login_id, --last_update_login
6055: SYSDATE, --4681253
6056: APPLICATION_ID ,

Line 6054: FND_GLOBAL.conc_login_id, --last_update_login

6050: SYSDATE, --creation_date
6051: FND_GLOBAL.user_id, --created_by
6052: FND_GLOBAL.user_id, --last_updated_by
6053: SYSDATE, --last_update_date
6054: FND_GLOBAL.conc_login_id, --last_update_login
6055: SYSDATE, --4681253
6056: APPLICATION_ID ,
6057: BANK_CHARGE_BEARER ,
6058: DELIVERY_CHANNEL_CODE ,

Line 6432: FND_GLOBAL.user_id, --created_by

6428: tax_rate,
6429: wfapproval_status,
6430: pa_quantity,
6431: SYSDATE, --creation_date
6432: FND_GLOBAL.user_id, --created_by
6433: FND_GLOBAL.user_id, --last_updated_by
6434: SYSDATE, --last_update_date
6435: FND_GLOBAL.conc_login_id, --last_update_login
6436: FND_GLOBAL.prog_appl_id, --program_application_id

Line 6433: FND_GLOBAL.user_id, --last_updated_by

6429: wfapproval_status,
6430: pa_quantity,
6431: SYSDATE, --creation_date
6432: FND_GLOBAL.user_id, --created_by
6433: FND_GLOBAL.user_id, --last_updated_by
6434: SYSDATE, --last_update_date
6435: FND_GLOBAL.conc_login_id, --last_update_login
6436: FND_GLOBAL.prog_appl_id, --program_application_id
6437: FND_GLOBAL.conc_program_id,--program_id

Line 6435: FND_GLOBAL.conc_login_id, --last_update_login

6431: SYSDATE, --creation_date
6432: FND_GLOBAL.user_id, --created_by
6433: FND_GLOBAL.user_id, --last_updated_by
6434: SYSDATE, --last_update_date
6435: FND_GLOBAL.conc_login_id, --last_update_login
6436: FND_GLOBAL.prog_appl_id, --program_application_id
6437: FND_GLOBAL.conc_program_id,--program_id
6438: SYSDATE, -- program_update_date
6439: FND_GLOBAL.conc_request_id --request_id

Line 6436: FND_GLOBAL.prog_appl_id, --program_application_id

6432: FND_GLOBAL.user_id, --created_by
6433: FND_GLOBAL.user_id, --last_updated_by
6434: SYSDATE, --last_update_date
6435: FND_GLOBAL.conc_login_id, --last_update_login
6436: FND_GLOBAL.prog_appl_id, --program_application_id
6437: FND_GLOBAL.conc_program_id,--program_id
6438: SYSDATE, -- program_update_date
6439: FND_GLOBAL.conc_request_id --request_id
6440: FROM ap_ppa_invoice_lines_gt

Line 6437: FND_GLOBAL.conc_program_id,--program_id

6433: FND_GLOBAL.user_id, --last_updated_by
6434: SYSDATE, --last_update_date
6435: FND_GLOBAL.conc_login_id, --last_update_login
6436: FND_GLOBAL.prog_appl_id, --program_application_id
6437: FND_GLOBAL.conc_program_id,--program_id
6438: SYSDATE, -- program_update_date
6439: FND_GLOBAL.conc_request_id --request_id
6440: FROM ap_ppa_invoice_lines_gt
6441: WHERE instruction_id = p_instruction_id

Line 6439: FND_GLOBAL.conc_request_id --request_id

6435: FND_GLOBAL.conc_login_id, --last_update_login
6436: FND_GLOBAL.prog_appl_id, --program_application_id
6437: FND_GLOBAL.conc_program_id,--program_id
6438: SYSDATE, -- program_update_date
6439: FND_GLOBAL.conc_request_id --request_id
6440: FROM ap_ppa_invoice_lines_gt
6441: WHERE instruction_id = p_instruction_id
6442: AND invoice_id = l_ppa_invoice_id;
6443: --Commented for bug#9573078.

Line 6666: FND_GLOBAL.user_id, --created_by,

6662: task_id,
6663: type_1099,
6664: unit_price,
6665: SYSDATE, --creation_date,
6666: FND_GLOBAL.user_id, --created_by,
6667: FND_GLOBAL.user_id, --last_updated_by,
6668: SYSDATE, --last_update_date,
6669: FND_GLOBAL.conc_login_id, --last_update_login,
6670: FND_GLOBAL.prog_appl_id, --program_application_id,

Line 6667: FND_GLOBAL.user_id, --last_updated_by,

6663: type_1099,
6664: unit_price,
6665: SYSDATE, --creation_date,
6666: FND_GLOBAL.user_id, --created_by,
6667: FND_GLOBAL.user_id, --last_updated_by,
6668: SYSDATE, --last_update_date,
6669: FND_GLOBAL.conc_login_id, --last_update_login,
6670: FND_GLOBAL.prog_appl_id, --program_application_id,
6671: FND_GLOBAL.conc_program_id, --program_id,

Line 6669: FND_GLOBAL.conc_login_id, --last_update_login,

6665: SYSDATE, --creation_date,
6666: FND_GLOBAL.user_id, --created_by,
6667: FND_GLOBAL.user_id, --last_updated_by,
6668: SYSDATE, --last_update_date,
6669: FND_GLOBAL.conc_login_id, --last_update_login,
6670: FND_GLOBAL.prog_appl_id, --program_application_id,
6671: FND_GLOBAL.conc_program_id, --program_id,
6672: SYSDATE, --program_update_date,
6673: FND_GLOBAL.conc_request_id, --request_id,

Line 6670: FND_GLOBAL.prog_appl_id, --program_application_id,

6666: FND_GLOBAL.user_id, --created_by,
6667: FND_GLOBAL.user_id, --last_updated_by,
6668: SYSDATE, --last_update_date,
6669: FND_GLOBAL.conc_login_id, --last_update_login,
6670: FND_GLOBAL.prog_appl_id, --program_application_id,
6671: FND_GLOBAL.conc_program_id, --program_id,
6672: SYSDATE, --program_update_date,
6673: FND_GLOBAL.conc_request_id, --request_id,
6674: 'N', --rcv_charge_addition_flag

Line 6671: FND_GLOBAL.conc_program_id, --program_id,

6667: FND_GLOBAL.user_id, --last_updated_by,
6668: SYSDATE, --last_update_date,
6669: FND_GLOBAL.conc_login_id, --last_update_login,
6670: FND_GLOBAL.prog_appl_id, --program_application_id,
6671: FND_GLOBAL.conc_program_id, --program_id,
6672: SYSDATE, --program_update_date,
6673: FND_GLOBAL.conc_request_id, --request_id,
6674: 'N', --rcv_charge_addition_flag
6675: /*Bug#10416960 */

Line 6673: FND_GLOBAL.conc_request_id, --request_id,

6669: FND_GLOBAL.conc_login_id, --last_update_login,
6670: FND_GLOBAL.prog_appl_id, --program_application_id,
6671: FND_GLOBAL.conc_program_id, --program_id,
6672: SYSDATE, --program_update_date,
6673: FND_GLOBAL.conc_request_id, --request_id,
6674: 'N', --rcv_charge_addition_flag
6675: /*Bug#10416960 */
6676: charge_applicable_to_dist_id,
6677: summary_tax_line_id,

Line 6885: FND_GLOBAL.conc_login_id,

6881: CURSOR po_dists(c_po_line_location_id IN NUMBER) IS
6882: SELECT d.po_distribution_id,
6883: d.matched_uom_lookup_code,
6884: d.amount,
6885: FND_GLOBAL.conc_login_id,
6886: FND_GLOBAL.conc_request_id
6887: FROM ap_ppa_invoice_dists_gt d,
6888: ap_ppa_invoice_lines_gt l,
6889: po_distributions_all pd

Line 6886: FND_GLOBAL.conc_request_id

6882: SELECT d.po_distribution_id,
6883: d.matched_uom_lookup_code,
6884: d.amount,
6885: FND_GLOBAL.conc_login_id,
6886: FND_GLOBAL.conc_request_id
6887: FROM ap_ppa_invoice_dists_gt d,
6888: ap_ppa_invoice_lines_gt l,
6889: po_distributions_all pd
6890: --bug#9573078 Introduced new conditions to put join lines_gt

Line 6944: FND_GLOBAL.user_id,

6940: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
6941: 'AP_INVOICES_INTERFACE',
6942: p_instruction_rec.invoice_id,
6943: 'ORIGINAL INVOICE NOT VALIDATED',
6944: FND_GLOBAL.user_id,
6945: FND_GLOBAL.login_id,
6946: current_calling_sequence) <> TRUE) THEN
6947: --
6948: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 6945: FND_GLOBAL.login_id,

6941: 'AP_INVOICES_INTERFACE',
6942: p_instruction_rec.invoice_id,
6943: 'ORIGINAL INVOICE NOT VALIDATED',
6944: FND_GLOBAL.user_id,
6945: FND_GLOBAL.login_id,
6946: current_calling_sequence) <> TRUE) THEN
6947: --
6948: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
6949: AP_IMPORT_UTILITIES_PKG.Print(

Line 6989: FND_GLOBAL.user_id,

6985: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
6986: ('AP_INVOICES_INTERFACE',
6987: p_instruction_rec.invoice_id,
6988: 'ORIGINAL INVOICE HAS A HOLD',
6989: FND_GLOBAL.user_id,
6990: FND_GLOBAL.login_id,
6991: current_calling_sequence) <> TRUE) THEN
6992: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
6993: AP_IMPORT_UTILITIES_PKG.Print(

Line 6990: FND_GLOBAL.login_id,

6986: ('AP_INVOICES_INTERFACE',
6987: p_instruction_rec.invoice_id,
6988: 'ORIGINAL INVOICE HAS A HOLD',
6989: FND_GLOBAL.user_id,
6990: FND_GLOBAL.login_id,
6991: current_calling_sequence) <> TRUE) THEN
6992: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
6993: AP_IMPORT_UTILITIES_PKG.Print(
6994: AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 7036: FND_GLOBAL.user_id,

7032: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
7033: ('AP_INVOICES_INTERFACE',
7034: p_instruction_rec.invoice_id,
7035: 'NO SEQUENCE DEFINED FOR PPA',
7036: FND_GLOBAL.user_id,
7037: FND_GLOBAL.login_id,
7038: current_calling_sequence) <> TRUE) THEN
7039: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
7040: AP_IMPORT_UTILITIES_PKG.Print(

Line 7037: FND_GLOBAL.login_id,

7033: ('AP_INVOICES_INTERFACE',
7034: p_instruction_rec.invoice_id,
7035: 'NO SEQUENCE DEFINED FOR PPA',
7036: FND_GLOBAL.user_id,
7037: FND_GLOBAL.login_id,
7038: current_calling_sequence) <> TRUE) THEN
7039: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
7040: AP_IMPORT_UTILITIES_PKG.Print(
7041: AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 7857: last_updated_by = FND_GLOBAL.user_id,

7853: ELSE
7854:
7855: UPDATE po_distributions_all pd
7856: SET last_update_date = SYSDATE,
7857: last_updated_by = FND_GLOBAL.user_id,
7858: last_update_login = FND_GLOBAL.conc_login_id,
7859: request_id = FND_GLOBAL.conc_request_id,
7860: invoice_adjustment_flag = 'R'
7861: WHERE invoice_adjustment_flag = 'S'

Line 7858: last_update_login = FND_GLOBAL.conc_login_id,

7854:
7855: UPDATE po_distributions_all pd
7856: SET last_update_date = SYSDATE,
7857: last_updated_by = FND_GLOBAL.user_id,
7858: last_update_login = FND_GLOBAL.conc_login_id,
7859: request_id = FND_GLOBAL.conc_request_id,
7860: invoice_adjustment_flag = 'R'
7861: WHERE invoice_adjustment_flag = 'S'
7862: AND po_distribution_id IN (

Line 7859: request_id = FND_GLOBAL.conc_request_id,

7855: UPDATE po_distributions_all pd
7856: SET last_update_date = SYSDATE,
7857: last_updated_by = FND_GLOBAL.user_id,
7858: last_update_login = FND_GLOBAL.conc_login_id,
7859: request_id = FND_GLOBAL.conc_request_id,
7860: invoice_adjustment_flag = 'R'
7861: WHERE invoice_adjustment_flag = 'S'
7862: AND po_distribution_id IN (
7863: SELECT d.po_distribution_id