APPS.PA_RETN_BILLING_PKG dependencies on PA_DRAFT_INVOICES

Line 93: FROM pa_draft_invoices_all

89: SELECT 'Y'
90: INTO ExistsFlag
91: FROM DUAL
92: WHERE EXISTS(SELECT NULL
93: FROM pa_draft_invoices_all
94: WHERE project_id = p_project_id
95: AND agreement_id = p_agreement_id
96: AND request_id = p_request_id
97: AND NVL(retention_invoice_flag,'N') = 'Y');

Line 422: SELECT PA_DRAFT_INVOICES_S.NEXTVAL

418: IF pa_billing.Globvars.InvoiceSetId IS NULL THEN
419:
420: -- Generate a set id, happens only user run the retention invoice generation
421:
422: SELECT PA_DRAFT_INVOICES_S.NEXTVAL
423: INTO TmpInvoiceSetId
424: FROM DUAL;
425:
426: ELSE

Line 442: FROM pa_draft_invoices_all p

438:
439:
440: SELECT NVL( MAX(p.draft_invoice_num) + 1, 1)
441: INTO TmpInvoiceNum
442: FROM pa_draft_invoices_all p
443: WHERE p.project_id = p_project_id;
444:
445: IF g1_debug_mode = 'Y' THEN
446: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'New Invoice Num : ' || TmpInvoiceNum);

Line 544: insert it into table pa_draft_invoices as ORG_ID. */

540: END IF;
541: END IF;
542:
543: /* Shared services changes: get org id from org context, and
544: insert it into table pa_draft_invoices as ORG_ID. */
545: l_org_id := MO_GLOBAL.get_current_org_id;
546:
547: -- Insert a new invoice header
548: /*Last 5 columns added for customer account relation enhancement bug no 2760630*/

Line 549: INSERT INTO PA_DRAFT_INVOICES (

545: l_org_id := MO_GLOBAL.get_current_org_id;
546:
547: -- Insert a new invoice header
548: /*Last 5 columns added for customer account relation enhancement bug no 2760630*/
549: INSERT INTO PA_DRAFT_INVOICES (
550: DRAFT_INVOICE_NUM, PROJECT_ID,
551: AGREEMENT_ID, LAST_UPDATE_DATE,
552: LAST_UPDATED_BY, CREATION_DATE,
553: CREATED_BY, TRANSFER_STATUS_CODE,

Line 700: UPDATE pa_draft_invoices_all

696: IF NVL(l_inv_amount,0) <> 0 AND NVL(l_pfc_amount,0) <> 0 THEN
697: l_projfunc_invtrans_rate := NVL(l_inv_amount,0)/NVL(l_pfc_amount,0);
698: END IF;
699:
700: UPDATE pa_draft_invoices_all
701: set inv_rate_date = NULL,
702: inv_exchange_rate = NULL,
703: projfunc_invtrans_rate_type = 'User',
704: projfunc_invtrans_rate_date = sysdate,

Line 1947: UPDATE PA_DRAFT_INVOICES

1943: IF g1_debug_mode = 'Y' THEN
1944: pa_retention_util.write_log('Retention_Billing_Processing: ' || 'Update MRC for Retention Invoices');
1945: END IF;
1946:
1947: UPDATE PA_DRAFT_INVOICES
1948: SET CREATION_DATE = sysdate
1949: WHERE REQUEST_ID = p_request_id
1950: AND NVL(retention_invoice_flag,'N') = 'Y';
1951:

Line 1968: FROM pa_draft_invoices

1964:
1965: PROCEDURE Update_Inv_Trans_Attributes (p_request_id IN NUMBER) IS
1966: CURSOR Retn_Inv_Project IS
1967: SELECT project_id
1968: FROM pa_draft_invoices
1969: WHERE request_id = p_request_id
1970: AND NVL(GENERATION_ERROR_FLAG,'N') ='N'
1971: AND NVL(retention_invoice_flag,'N') = 'Y'
1972: GROUP BY project_id;

Line 2011: FROM pa_draft_invoices_all di

2007: CURSOR cur_select_projects IS
2008: SELECT pr.project_id project_id
2009: FROM pa_projects pr, pa_project_types t
2010: WHERE NOT EXISTS (SELECT null
2011: FROM pa_draft_invoices_all di
2012: WHERE di.request_id = p_request_id
2013: AND di.project_id = pr.project_id
2014: AND NVL(di.retention_invoice_flag,'N') = 'Y')
2015: AND EXISTS( SELECT NULL