APPS.PA_RETN_BILLING_PKG dependencies on PA_RETN_INVOICE_DETAILS

Line 1177: SELECT pa_retn_invoice_details_s.NEXTVAL

1173:
1174:
1175: -- Select the sequence values
1176:
1177: SELECT pa_retn_invoice_details_s.NEXTVAL
1178: INTO l_detail_id
1179: FROM DUAL;
1180:
1181: IF g1_debug_mode = 'Y' THEN

Line 1182: pa_retention_util.write_log('Create_Retn_Invoice_Details: ' || 'Insert pa_retn_invoice_details');

1178: INTO l_detail_id
1179: FROM DUAL;
1180:
1181: IF g1_debug_mode = 'Y' THEN
1182: pa_retention_util.write_log('Create_Retn_Invoice_Details: ' || 'Insert pa_retn_invoice_details');
1183: END IF;
1184:
1185: -- Insert into the Retention Invoice Detail table
1186: INSERT INTO pa_retn_invoice_details

Line 1186: INSERT INTO pa_retn_invoice_details

1182: pa_retention_util.write_log('Create_Retn_Invoice_Details: ' || 'Insert pa_retn_invoice_details');
1183: END IF;
1184:
1185: -- Insert into the Retention Invoice Detail table
1186: INSERT INTO pa_retn_invoice_details
1187: ( RETN_INVOICE_DETAIL_ID,
1188: PROJECT_ID,
1189: DRAFT_INVOICE_NUM,
1190: LINE_NUM,