APPS.PA_RETENTION_PKG dependencies on PA_RETN_INVOICE_DETAILS

Line 3444: INSERT INTO pa_retn_invoice_details

3440: END LOOP;
3441:
3442: -- Reverse Retention Invoice Details
3443:
3444: INSERT INTO pa_retn_invoice_details
3445: ( RETN_INVOICE_DETAIL_ID, PROJECT_ID, DRAFT_INVOICE_NUM,
3446: LINE_NUM , PROJECT_RETENTION_ID, TOTAL_RETAINED,
3447: INVPROC_CURRENCY_CODE, PROJFUNC_CURRENCY_CODE,
3448: PROJFUNC_TOTAL_RETAINED, PROJECT_CURRENCY_CODE,

Line 3457: pa_retn_invoice_details_s.nextval,

3453: LAST_UPDATE_DATE,
3454: LAST_UPDATED_BY,
3455: PROGRAM_ID )
3456: SELECT
3457: pa_retn_invoice_details_s.nextval,
3458: p_project_id,
3459: TmpInvoiceNum,
3460: rtndet.line_num,
3461: rtndet.project_retention_id,

Line 3475: FROM pa_retn_invoice_details rtndet

3471: sysdate, p_request_id,
3472: sysdate, l_created_by,
3473: sysdate, LastUpdatedBy,
3474: l_program_id
3475: FROM pa_retn_invoice_details rtndet
3476: WHERE rtndet.project_id = p_project_id
3477: AND rtndet.draft_invoice_num = p_draft_invoice_num;
3478:
3479: ELSIF p_invoice_type ='PROJECT_INVOICE' THEN

Line 3626: DELETE FROM pa_retn_invoice_details

3622: IF g1_debug_mode = 'Y' THEN
3623: pa_retention_util.write_log('Invoice_Delete_Action: ' || 'Delete Retention Invoice Details ');
3624: END IF;
3625:
3626: DELETE FROM pa_retn_invoice_details
3627: WHERE project_id = p_project_id
3628: AND draft_invoice_num = p_draft_invoice_num;
3629:
3630: -- Call to delete the mc records