DBA Data[Home] [Help]

APPS.AR_UNPOSTED_ITEM_UPG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 47: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL

43:
44:
45: PROCEDURE upgrade_11i_cash_basis
46: (l_table_owner IN VARCHAR2, -- AR
47: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL
48: l_script_name IN VARCHAR2, -- ar120cbupi.sql
49: l_worker_id IN VARCHAR2,
50: l_num_workers IN VARCHAR2,
51: l_batch_size IN VARCHAR2)

Line 69: FROM ar_receivable_applications_all app,

65: CURSOR c_app(p_start_rowid IN ROWID,
66: p_end_rowid IN ROWID)
67: IS
68: SELECT app.*
69: FROM ar_receivable_applications_all app,
70: ar_system_parameters_all ars
71: WHERE app.status = 'APP'
72: AND app.upgrade_method IS NULL
73: AND app.org_id = ars.org_id

Line 333: FROM ar_receivable_applications_all

329: , NULL -- tax_link_id
330: , NULL -- tax_inc_flag
331: FROM (SELECT applied_customer_trx_id,
332: org_id
333: FROM ar_receivable_applications_all
334: WHERE status = 'APP'
335: AND upgrade_method IS NULL
336: AND posting_control_id = -3
337: AND rowid >= l_start_rowid

Line 796: UPDATE ar_receivable_applications_all

792: CLOSE c_app;
793:
794:
795: FORALL i IN l_ra_list.FIRST .. l_ra_list.LAST
796: UPDATE ar_receivable_applications_all
797: SET upgrade_method = 'R12_11ICASH_POST'
798: WHERE receivable_application_id = l_ra_list(i);
799:
800:

Line 832: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL

828:
829:
830: PROCEDURE upgrade_11i_cm_cash_basis
831: (l_table_owner IN VARCHAR2, -- AR
832: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL
833: l_script_name IN VARCHAR2, -- ar120cbupi.sql
834: l_worker_id IN VARCHAR2,
835: l_num_workers IN VARCHAR2,
836: l_batch_size IN VARCHAR2)

Line 854: FROM ar_receivable_applications_all app,

850: CURSOR c_app(p_start_rowid IN ROWID,
851: p_end_rowid IN ROWID)
852: IS
853: SELECT app.*
854: FROM ar_receivable_applications_all app,
855: ar_system_parameters_all ars
856: WHERE app.status = 'APP'
857: AND app.upgrade_method = 'R12_11ICASH_POST'
858: AND app.org_id = ars.org_id

Line 1119: FROM ar_receivable_applications_all

1115: , NULL -- tax_link_id
1116: , NULL -- tax_inc_flag
1117: FROM (SELECT customer_trx_id,
1118: org_id
1119: FROM ar_receivable_applications_all
1120: WHERE status = 'APP'
1121: AND upgrade_method = 'R12_11ICASH_POST'
1122: AND posting_control_id = -3
1123: AND customer_trx_id IS NOT NULL