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)
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
84:
85:
86:
87: l_org_id NUMBER := -9999;
88: l_app_rec ar_receivable_applications%ROWTYPE;
89: l_line_acctd_amt NUMBER;
90: l_tax_acctd_amt NUMBER;
91: l_frt_acctd_amt NUMBER;
92: l_chrg_acctd_amt NUMBER;
323: , NULL -- tax_link_id
324: , NULL -- tax_inc_flag
325: FROM (SELECT applied_customer_trx_id,
326: org_id
327: FROM ar_receivable_applications_all
328: WHERE status = 'APP'
329: AND upgrade_method IS NULL
330: AND posting_control_id = -3
331: AND rowid >= l_start_rowid
786: CLOSE c_app;
787:
788:
789: FORALL i IN l_ra_list.FIRST .. l_ra_list.LAST
790: UPDATE ar_receivable_applications_all
791: SET upgrade_method = 'R12_11ICASH_POST'
792: WHERE receivable_application_id = l_ra_list(i);
793:
794:
820:
821:
822: PROCEDURE upgrade_11i_cm_cash_basis
823: (l_table_owner IN VARCHAR2, -- AR
824: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL
825: l_script_name IN VARCHAR2, -- ar120cbupi.sql
826: l_worker_id IN VARCHAR2,
827: l_num_workers IN VARCHAR2,
828: l_batch_size IN VARCHAR2)
842: CURSOR c_app(p_start_rowid IN ROWID,
843: p_end_rowid IN ROWID)
844: IS
845: SELECT app.*
846: FROM ar_receivable_applications_all app,
847: ar_system_parameters_all ars
848: WHERE app.status = 'APP'
849: AND app.upgrade_method = 'R12_11ICASH_POST'
850: AND app.org_id = ars.org_id
863:
864:
865:
866: l_org_id NUMBER := -9999;
867: l_app_rec ar_receivable_applications%ROWTYPE;
868: l_line_acctd_amt NUMBER;
869: l_tax_acctd_amt NUMBER;
870: l_frt_acctd_amt NUMBER;
871: l_chrg_acctd_amt NUMBER;
1102: , NULL -- tax_link_id
1103: , NULL -- tax_inc_flag
1104: FROM (SELECT customer_trx_id,
1105: org_id
1106: FROM ar_receivable_applications_all
1107: WHERE status = 'APP'
1108: AND upgrade_method = 'R12_11ICASH_POST'
1109: AND posting_control_id = -3
1110: AND customer_trx_id IS NOT NULL