APPS.PA_IC_INV_UTILS dependencies on PA_DISTRIBUTION_WARNINGS

Line 216: Update pa_distribution_warnings

212: last_update_login = l_user_id
213: where project_id = P_Project_Id
214: and draft_invoice_num = l_err_invoice_num;
215:
216: Update pa_distribution_warnings
217: set draft_invoice_num = l_new_invoice_num,
218: last_update_date = SYSDATE,
219: last_update_login = l_user_id
220: where project_id = P_Project_Id

Line 361: FROM pa_distribution_warnings

357: /* Fix for bug 7034356 starts here */
358: IF (P_REJN_LOOKUP_CODE = 'NO_INV_LINES') THEN
359: SELECT COUNT(*)
360: INTO l_cnt
361: FROM pa_distribution_warnings
362: WHERE project_id = p_project_id
363: AND draft_invoice_num = P_DRAFT_INVOICE_NUM;
364: END IF;
365:

Line 409: INSERT INTO PA_DISTRIBUTION_WARNINGS

405: IF g1_debug_mode = 'Y' THEN
406: pa_ic_inv_utils.log_message('Rows updated in DI = '||SQL%rowcount);
407: END IF;
408:
409: INSERT INTO PA_DISTRIBUTION_WARNINGS
410: (
411: DRAFT_INVOICE_NUM, PROJECT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
412: CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID,
413: PROGRAM_ID, PROGRAM_UPDATE_DATE, WARNING_MESSAGE

Line 423: pa_ic_inv_utils.log_message('Rows Inserted in pa_distribution_warnings = '||SQL%rowcount);

419: l_program_id, SYSDATE, l_rejection_reason
420: );
421:
422: IF g1_debug_mode = 'Y' THEN
423: pa_ic_inv_utils.log_message('Rows Inserted in pa_distribution_warnings = '||SQL%rowcount);
424: pa_debug.g_err_stage := ' Done Mark Inv Error ';
425: pa_ic_inv_utils.log_message('Mark_Inv_Error: ' || pa_debug.g_err_stage);
426: END IF;
427: END IF; /* Added for bug 7034356*/