APPS.PA_PURGE_BILLING dependencies on PA_DRAFT_INV_ITEMS_AR

Line 1882: PA_DRAFT_INV_ITEMS_AR ar

1878: mc.Conversion_Date,
1879: mc.Rate_Type
1880: from Pa_Mc_Draft_Inv_Items mc,
1881: -- PA_MC_DRAFT_INV_ITMS_AR ar Bug 2590517
1882: PA_DRAFT_INV_ITEMS_AR ar
1883: where ar.Purge_Project_Id = p_project_id
1884: and mc.Project_Id = ar.Purge_Project_Id
1885: and mc.Draft_Invoice_Num = ar.Draft_Invoice_Num
1886: and mc.Line_Num = ar.Line_Num;

Line 1958: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_ITEMS_AR') ;

1954: -- in the commit size.
1955:
1956: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1957:
1958: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_ITEMS_AR') ;
1959: insert into PA_DRAFT_INV_ITEMS_AR (
1960: PURGE_BATCH_ID,
1961: PURGE_RELEASE,
1962: PURGE_PROJECT_ID,

Line 1959: insert into PA_DRAFT_INV_ITEMS_AR (

1955:
1956: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1957:
1958: pa_debug.debug( ' ->Before insert into PA_DRAFT_INV_ITEMS_AR') ;
1959: insert into PA_DRAFT_INV_ITEMS_AR (
1960: PURGE_BATCH_ID,
1961: PURGE_RELEASE,
1962: PURGE_PROJECT_ID,
1963: PROJECT_ID,

Line 2098: pa_debug.debug( ' ->After insert into PA_DRAFT_INV_ITEMS_AR') ;

2094: l_NoOfRecordsIns := SQL%ROWCOUNT ;
2095: /*Code Changes for Bug No.2984871 end */
2096:
2097:
2098: pa_debug.debug( ' ->After insert into PA_DRAFT_INV_ITEMS_AR') ;
2099:
2100: /*Code Changes for Bug No.2984871 start */
2101: if l_NoOfRecordsIns > 0 then
2102: /*Code Changes for Bug No.2984871 end */

Line 2127: PA_DRAFT_INV_ITEMS_AR dii2

2123: where (dii.rowid)
2124: in
2125: ( select dii1.rowid
2126: from pa_draft_invoice_items dii1,
2127: PA_DRAFT_INV_ITEMS_AR dii2
2128: where dii2.draft_invoice_num = dii1.draft_invoice_num
2129: and dii2.line_num = dii1.line_num
2130: and dii2.project_id = dii1.project_id
2131: and dii2.purge_project_id = p_project_id

Line 2138: from PA_DRAFT_INV_ITEMS_AR dii2

2134: /* Commented the delete statement and added the modified code below not to correlate queries */
2135: /* delete from pa_draft_invoice_items dii
2136: where (dii.project_id, dii.draft_invoice_num) in
2137: ( select dii2.project_id, dii2.draft_invoice_num
2138: from PA_DRAFT_INV_ITEMS_AR dii2
2139: where dii2.line_num = dii.line_num
2140: and dii2.purge_project_id = p_project_id
2141: ) ;
2142: */

Line 2146: from PA_DRAFT_INV_ITEMS_AR dii2

2142: */
2143: delete from pa_draft_invoice_items dii
2144: where (dii.project_id, dii.draft_invoice_num, dii.line_num) in
2145: ( select dii2.project_id, dii2.draft_invoice_num, dii2.line_num
2146: from PA_DRAFT_INV_ITEMS_AR dii2
2147: where dii2.purge_project_id = p_project_id
2148: ) ;
2149:
2150: /*Code Changes for Bug No.2984871 start */