DBA Data[Home] [Help]

APPS.PA_RETN_BILLING_PKG dependencies on PA_DISTRIBUTION_WARNINGS

Line 620: INSERT INTO PA_DISTRIBUTION_WARNINGS (

616: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'Insert Warning ');
617: END IF;
618:
619:
620: INSERT INTO PA_DISTRIBUTION_WARNINGS (
621: DRAFT_INVOICE_NUM, PROJECT_ID,
622: LAST_UPDATE_DATE, LAST_UPDATED_BY,
623: CREATION_DATE, CREATED_BY,
624: REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 638: INSERT INTO PA_DISTRIBUTION_WARNINGS (

634: -- This insert is for project level rejection reason. This will be shown
635: -- in the invoice exception report
636: IF NVL(TmpRetnBillInvFmtID,0) = 0 THEN
637:
638: INSERT INTO PA_DISTRIBUTION_WARNINGS (
639: DRAFT_INVOICE_NUM, PROJECT_ID,
640: LAST_UPDATE_DATE, LAST_UPDATED_BY,
641: CREATION_DATE, CREATED_BY,
642: REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 2064: INSERT INTO PA_DISTRIBUTION_WARNINGS (

2060: pa_retention_util.write_log('Invoice_Generation_Exceptions: ' || 'Insert Warning ');
2061: END IF;
2062:
2063:
2064: INSERT INTO PA_DISTRIBUTION_WARNINGS (
2065: DRAFT_INVOICE_NUM, PROJECT_ID,
2066: LAST_UPDATE_DATE, LAST_UPDATED_BY,
2067: CREATION_DATE, CREATED_BY,
2068: REQUEST_ID, PROGRAM_APPLICATION_ID,