DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on FND_GLOBAL

Line 383: FND_GLOBAL.USER_ID,

379: SYSDATE,
380: -- Bug 7383484 (Base bug 7296715)
381: -- The User Id is hardcoded to 5 (APPSMGR). It is changed to populate correct value.
382: -- '5',
383: FND_GLOBAL.USER_ID,
384: p_check_date,
385: l_inv_curr_int_amt,
386: l_int_invoice_amt,
387: 0,

Line 405: FND_GLOBAL.USER_ID,

401: l_payment_num,
402: SYSDATE,
403: -- Bug 7383484 (Base bug 7296715)
404: --'5',
405: FND_GLOBAL.USER_ID,
406: l_exclusive_payment_flag,
407: l_org_id,
408: l_external_bank_account_id,
409: p_checkrun_id,

Line 1232: last_updated_by = FND_GLOBAL.USER_ID,

1228: 'CREDIT TOO LOW',null),
1229: last_update_date = sysdate,
1230: -- Bug 7383484 (Base bug 7296715)
1231: -- last_updated_by = 5
1232: last_updated_by = FND_GLOBAL.USER_ID,
1233: due_date = l_documents(i).due_date -- Bug 5357689
1234: where invoice_id = l_documents(i).invoice_id
1235: and payment_num = l_documents(i).payment_num
1236: and checkrun_id= p_checkrun_id;

Line 1267: last_updated_by = FND_GLOBAL.USER_ID

1263: dont_pay_reason_code = 'CREDIT TOO LOW',
1264: last_update_date = sysdate,
1265: -- Bug 7383484 (Base bug 7296715)
1266: -- last_updated_by = 5
1267: last_updated_by = FND_GLOBAL.USER_ID
1268: where checkrun_id = p_checkrun_id
1269: and payment_grouping_number in
1270: (select asi2.payment_grouping_number
1271: from ap_selected_invoices_all asi2

Line 1461: fnd_global.conc_request_id, --4737467

1457: payments_review_settings,
1458: document_rejection_level_code,
1459: payment_rejection_level_code,
1460: party_id,
1461: fnd_global.conc_request_id, --4737467
1462: payment_document_id, --7315136
1463: transfer_priority --7315136
1464: from AP_PAYMENT_TEMPLATES
1465: where template_id = p_template_id;

Line 1902: ,FND_GLOBAL.USER_ID last_updated_by

1898: ,SYSDATE last_update_date
1899: -- Bug 7383484 (Base bug 7296715)
1900: -- The User Id is hardcoded to 5 (APPSMGR). It is changed to populate correct value.
1901: -- ,5 last_updated_by
1902: ,FND_GLOBAL.USER_ID last_updated_by
1903: ,SYSDATE creation_date
1904: -- Bug 7383484 (Base bug 7296715)
1905: -- ,5 created_by
1906: ,FND_GLOBAL.USER_ID created_by

Line 1906: ,FND_GLOBAL.USER_ID created_by

1902: ,FND_GLOBAL.USER_ID last_updated_by
1903: ,SYSDATE creation_date
1904: -- Bug 7383484 (Base bug 7296715)
1905: -- ,5 created_by
1906: ,FND_GLOBAL.USER_ID created_by
1907: ,NULL last_update_login
1908: ,inv.vendor_id vendor_id
1909: ,inv.vendor_site_id vendor_site_id
1910: ,suppliers.segment1 vendor_num

Line 2196: ,FND_GLOBAL.USER_ID last_updated_by

2192: ,SYSDATE last_update_date
2193: -- Bug 7383484 (Base bug 7296715)
2194: -- The User Id is hardcoded to 5 (APPSMGR). It is changed to populate correct value.
2195: -- ,5 last_updated_by
2196: ,FND_GLOBAL.USER_ID last_updated_by
2197: ,SYSDATE creation_date
2198: -- Bug 7383484 (Base bug 7296715)
2199: -- ,5 created_by
2200: ,FND_GLOBAL.USER_ID created_by

Line 2200: ,FND_GLOBAL.USER_ID created_by

2196: ,FND_GLOBAL.USER_ID last_updated_by
2197: ,SYSDATE creation_date
2198: -- Bug 7383484 (Base bug 7296715)
2199: -- ,5 created_by
2200: ,FND_GLOBAL.USER_ID created_by
2201: ,NULL last_update_login
2202: ,inv.vendor_id vendor_id
2203: ,inv.vendor_site_id vendor_site_id
2204: ,suppliers.segment1 vendor_num

Line 3676: FND_GLOBAL.USER_ID,

3672:
3673:
3674: AP_WITHHOLDING_PKG.AP_WITHHOLD_AUTOSELECT(
3675: l_payment_process_request_name,
3676: FND_GLOBAL.USER_ID,
3677: FND_GLOBAL.LOGIN_ID,
3678: FND_GLOBAL.PROG_APPL_ID,
3679: FND_GLOBAL.CONC_PROGRAM_ID,
3680: FND_GLOBAL.CONC_REQUEST_ID,

Line 3677: FND_GLOBAL.LOGIN_ID,

3673:
3674: AP_WITHHOLDING_PKG.AP_WITHHOLD_AUTOSELECT(
3675: l_payment_process_request_name,
3676: FND_GLOBAL.USER_ID,
3677: FND_GLOBAL.LOGIN_ID,
3678: FND_GLOBAL.PROG_APPL_ID,
3679: FND_GLOBAL.CONC_PROGRAM_ID,
3680: FND_GLOBAL.CONC_REQUEST_ID,
3681: l_checkrun_id);

Line 3678: FND_GLOBAL.PROG_APPL_ID,

3674: AP_WITHHOLDING_PKG.AP_WITHHOLD_AUTOSELECT(
3675: l_payment_process_request_name,
3676: FND_GLOBAL.USER_ID,
3677: FND_GLOBAL.LOGIN_ID,
3678: FND_GLOBAL.PROG_APPL_ID,
3679: FND_GLOBAL.CONC_PROGRAM_ID,
3680: FND_GLOBAL.CONC_REQUEST_ID,
3681: l_checkrun_id);
3682:

Line 3679: FND_GLOBAL.CONC_PROGRAM_ID,

3675: l_payment_process_request_name,
3676: FND_GLOBAL.USER_ID,
3677: FND_GLOBAL.LOGIN_ID,
3678: FND_GLOBAL.PROG_APPL_ID,
3679: FND_GLOBAL.CONC_PROGRAM_ID,
3680: FND_GLOBAL.CONC_REQUEST_ID,
3681: l_checkrun_id);
3682:
3683: --Bug6459578

Line 3680: FND_GLOBAL.CONC_REQUEST_ID,

3676: FND_GLOBAL.USER_ID,
3677: FND_GLOBAL.LOGIN_ID,
3678: FND_GLOBAL.PROG_APPL_ID,
3679: FND_GLOBAL.CONC_PROGRAM_ID,
3680: FND_GLOBAL.CONC_REQUEST_ID,
3681: l_checkrun_id);
3682:
3683: --Bug6459578
3684: l_debug_info := 'Calling ap_custom_withholding_pkg';

Line 3819: FND_GLOBAL.user_id,

3815: (select l_checkrun_id,
3816: asi.payment_currency_code,
3817: asp.base_currency_code,
3818: SYSDATE,
3819: FND_GLOBAL.user_id,
3820: SYSDATE,
3821: FND_GLOBAL.user_id,
3822: FND_GLOBAL.login_id
3823: from ap_selected_invoices_all asi,

Line 3821: FND_GLOBAL.user_id,

3817: asp.base_currency_code,
3818: SYSDATE,
3819: FND_GLOBAL.user_id,
3820: SYSDATE,
3821: FND_GLOBAL.user_id,
3822: FND_GLOBAL.login_id
3823: from ap_selected_invoices_all asi,
3824: ap_system_parameters_all asp
3825: where asi.payment_exchange_rate is null

Line 3822: FND_GLOBAL.login_id

3818: SYSDATE,
3819: FND_GLOBAL.user_id,
3820: SYSDATE,
3821: FND_GLOBAL.user_id,
3822: FND_GLOBAL.login_id
3823: from ap_selected_invoices_all asi,
3824: ap_system_parameters_all asp
3825: where asi.payment_exchange_rate is null
3826: and asp.org_id = asi.org_id

Line 4228: ,P_Last_Updated_By => FND_GLOBAL.USER_ID

4224: ,P_Payment_Num => rec_all_sel_invs.payment_num
4225: ,P_Checkrun_Name => l_Checkrun_Name
4226: ,P_Undo_Awt_Date => SYSDATE
4227: ,P_Calling_Module => 'AUTOSELECT'
4228: ,P_Last_Updated_By => FND_GLOBAL.USER_ID
4229: ,P_Last_Update_Login => FND_GLOBAL.LOGIN_ID
4230: ,P_Program_Application_Id => FND_GLOBAL.PROG_APPL_ID
4231: ,P_Program_Id => FND_GLOBAL.CONC_PROGRAM_ID
4232: ,P_Request_Id => FND_GLOBAL.CONC_REQUEST_ID

Line 4229: ,P_Last_Update_Login => FND_GLOBAL.LOGIN_ID

4225: ,P_Checkrun_Name => l_Checkrun_Name
4226: ,P_Undo_Awt_Date => SYSDATE
4227: ,P_Calling_Module => 'AUTOSELECT'
4228: ,P_Last_Updated_By => FND_GLOBAL.USER_ID
4229: ,P_Last_Update_Login => FND_GLOBAL.LOGIN_ID
4230: ,P_Program_Application_Id => FND_GLOBAL.PROG_APPL_ID
4231: ,P_Program_Id => FND_GLOBAL.CONC_PROGRAM_ID
4232: ,P_Request_Id => FND_GLOBAL.CONC_REQUEST_ID
4233: ,P_Awt_Success => undo_output

Line 4230: ,P_Program_Application_Id => FND_GLOBAL.PROG_APPL_ID

4226: ,P_Undo_Awt_Date => SYSDATE
4227: ,P_Calling_Module => 'AUTOSELECT'
4228: ,P_Last_Updated_By => FND_GLOBAL.USER_ID
4229: ,P_Last_Update_Login => FND_GLOBAL.LOGIN_ID
4230: ,P_Program_Application_Id => FND_GLOBAL.PROG_APPL_ID
4231: ,P_Program_Id => FND_GLOBAL.CONC_PROGRAM_ID
4232: ,P_Request_Id => FND_GLOBAL.CONC_REQUEST_ID
4233: ,P_Awt_Success => undo_output
4234: ,P_checkrun_id => p_checkrun_id );

Line 4231: ,P_Program_Id => FND_GLOBAL.CONC_PROGRAM_ID

4227: ,P_Calling_Module => 'AUTOSELECT'
4228: ,P_Last_Updated_By => FND_GLOBAL.USER_ID
4229: ,P_Last_Update_Login => FND_GLOBAL.LOGIN_ID
4230: ,P_Program_Application_Id => FND_GLOBAL.PROG_APPL_ID
4231: ,P_Program_Id => FND_GLOBAL.CONC_PROGRAM_ID
4232: ,P_Request_Id => FND_GLOBAL.CONC_REQUEST_ID
4233: ,P_Awt_Success => undo_output
4234: ,P_checkrun_id => p_checkrun_id );
4235:

Line 4232: ,P_Request_Id => FND_GLOBAL.CONC_REQUEST_ID

4228: ,P_Last_Updated_By => FND_GLOBAL.USER_ID
4229: ,P_Last_Update_Login => FND_GLOBAL.LOGIN_ID
4230: ,P_Program_Application_Id => FND_GLOBAL.PROG_APPL_ID
4231: ,P_Program_Id => FND_GLOBAL.CONC_PROGRAM_ID
4232: ,P_Request_Id => FND_GLOBAL.CONC_REQUEST_ID
4233: ,P_Awt_Success => undo_output
4234: ,P_checkrun_id => p_checkrun_id );
4235:
4236: END;

Line 4270: FND_GLOBAL.USER_ID,

4266:
4267: --redo awt
4268: AP_WITHHOLDING_PKG.AP_WITHHOLD_AUTOSELECT(
4269: l_checkrun_name,
4270: FND_GLOBAL.USER_ID,
4271: FND_GLOBAL.LOGIN_ID,
4272: FND_GLOBAL.PROG_APPL_ID,
4273: FND_GLOBAL.CONC_PROGRAM_ID,
4274: FND_GLOBAL.CONC_REQUEST_ID,

Line 4271: FND_GLOBAL.LOGIN_ID,

4267: --redo awt
4268: AP_WITHHOLDING_PKG.AP_WITHHOLD_AUTOSELECT(
4269: l_checkrun_name,
4270: FND_GLOBAL.USER_ID,
4271: FND_GLOBAL.LOGIN_ID,
4272: FND_GLOBAL.PROG_APPL_ID,
4273: FND_GLOBAL.CONC_PROGRAM_ID,
4274: FND_GLOBAL.CONC_REQUEST_ID,
4275: p_checkrun_id);

Line 4272: FND_GLOBAL.PROG_APPL_ID,

4268: AP_WITHHOLDING_PKG.AP_WITHHOLD_AUTOSELECT(
4269: l_checkrun_name,
4270: FND_GLOBAL.USER_ID,
4271: FND_GLOBAL.LOGIN_ID,
4272: FND_GLOBAL.PROG_APPL_ID,
4273: FND_GLOBAL.CONC_PROGRAM_ID,
4274: FND_GLOBAL.CONC_REQUEST_ID,
4275: p_checkrun_id);
4276:

Line 4273: FND_GLOBAL.CONC_PROGRAM_ID,

4269: l_checkrun_name,
4270: FND_GLOBAL.USER_ID,
4271: FND_GLOBAL.LOGIN_ID,
4272: FND_GLOBAL.PROG_APPL_ID,
4273: FND_GLOBAL.CONC_PROGRAM_ID,
4274: FND_GLOBAL.CONC_REQUEST_ID,
4275: p_checkrun_id);
4276:
4277: -- Bug 7492768 start

Line 4274: FND_GLOBAL.CONC_REQUEST_ID,

4270: FND_GLOBAL.USER_ID,
4271: FND_GLOBAL.LOGIN_ID,
4272: FND_GLOBAL.PROG_APPL_ID,
4273: FND_GLOBAL.CONC_PROGRAM_ID,
4274: FND_GLOBAL.CONC_REQUEST_ID,
4275: p_checkrun_id);
4276:
4277: -- Bug 7492768 start
4278: select decode(nvl(inv_awt_exists_flag, 'N'), 'Y', 'REQUEST', document_rejection_level_code) document_rejection_level_code,

Line 4380: FND_GLOBAL.user_id,

4376: (select p_checkrun_id,
4377: asi.payment_currency_code,
4378: asp.base_currency_code,
4379: SYSDATE,
4380: FND_GLOBAL.user_id,
4381: SYSDATE,
4382: FND_GLOBAL.user_id,
4383: FND_GLOBAL.login_id
4384: from ap_selected_invoices_all asi,

Line 4382: FND_GLOBAL.user_id,

4378: asp.base_currency_code,
4379: SYSDATE,
4380: FND_GLOBAL.user_id,
4381: SYSDATE,
4382: FND_GLOBAL.user_id,
4383: FND_GLOBAL.login_id
4384: from ap_selected_invoices_all asi,
4385: ap_system_parameters_all asp
4386: where asi.payment_exchange_rate is null

Line 4383: FND_GLOBAL.login_id

4379: SYSDATE,
4380: FND_GLOBAL.user_id,
4381: SYSDATE,
4382: FND_GLOBAL.user_id,
4383: FND_GLOBAL.login_id
4384: from ap_selected_invoices_all asi,
4385: ap_system_parameters_all asp
4386: where asi.payment_exchange_rate is null
4387: and asp.org_id = asi.org_id

Line 4616: FND_GLOBAL.USER_ID,

4612:
4613: l_debug_info := 'undo awt';
4614:
4615: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL(l_checkrun_name,
4616: FND_GLOBAL.USER_ID,
4617: FND_GLOBAL.LOGIN_ID, -- Bug 5478602
4618: FND_GLOBAL.PROG_APPL_ID,
4619: FND_GLOBAL.CONC_PROGRAM_ID,
4620: FND_GLOBAL.CONC_REQUEST_ID,

Line 4617: FND_GLOBAL.LOGIN_ID, -- Bug 5478602

4613: l_debug_info := 'undo awt';
4614:
4615: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL(l_checkrun_name,
4616: FND_GLOBAL.USER_ID,
4617: FND_GLOBAL.LOGIN_ID, -- Bug 5478602
4618: FND_GLOBAL.PROG_APPL_ID,
4619: FND_GLOBAL.CONC_PROGRAM_ID,
4620: FND_GLOBAL.CONC_REQUEST_ID,
4621: p_checkrun_id,

Line 4618: FND_GLOBAL.PROG_APPL_ID,

4614:
4615: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL(l_checkrun_name,
4616: FND_GLOBAL.USER_ID,
4617: FND_GLOBAL.LOGIN_ID, -- Bug 5478602
4618: FND_GLOBAL.PROG_APPL_ID,
4619: FND_GLOBAL.CONC_PROGRAM_ID,
4620: FND_GLOBAL.CONC_REQUEST_ID,
4621: p_checkrun_id,
4622: null,

Line 4619: FND_GLOBAL.CONC_PROGRAM_ID,

4615: AP_WITHHOLDING_PKG.AP_WITHHOLD_CANCEL(l_checkrun_name,
4616: FND_GLOBAL.USER_ID,
4617: FND_GLOBAL.LOGIN_ID, -- Bug 5478602
4618: FND_GLOBAL.PROG_APPL_ID,
4619: FND_GLOBAL.CONC_PROGRAM_ID,
4620: FND_GLOBAL.CONC_REQUEST_ID,
4621: p_checkrun_id,
4622: null,
4623: null);

Line 4620: FND_GLOBAL.CONC_REQUEST_ID,

4616: FND_GLOBAL.USER_ID,
4617: FND_GLOBAL.LOGIN_ID, -- Bug 5478602
4618: FND_GLOBAL.PROG_APPL_ID,
4619: FND_GLOBAL.CONC_PROGRAM_ID,
4620: FND_GLOBAL.CONC_REQUEST_ID,
4621: p_checkrun_id,
4622: null,
4623: null);
4624: