APPS.PA_FUND_REVAL_PVT dependencies on PA_DISTRIBUTION_WARNINGS

Line 1296: INSERT INTO PA_DISTRIBUTION_WARNINGS

1292: CLOSE rej_reason;
1293:
1294: END IF;
1295:
1296: INSERT INTO PA_DISTRIBUTION_WARNINGS
1297: (
1298: PROJECT_ID, AGREEMENT_ID, TASK_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1299: CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID,
1300: PROGRAM_ID, PROGRAM_UPDATE_DATE, WARNING_MESSAGE_CODE, WARNING_MESSAGE

Line 1624: INSERT INTO PA_DISTRIBUTION_WARNINGS

1620: error code /messages defined specifically for it. Also dependent
1621: on budget model */
1622: /*Bug 3986205 : Replaced p_project_id with G_ProjLvlGlobRec.project_id in the following INSERT statement */
1623:
1624: INSERT INTO PA_DISTRIBUTION_WARNINGS
1625: (
1626: PROJECT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1627: CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_APPLICATION_ID,
1628: PROGRAM_ID, PROGRAM_UPDATE_DATE, WARNING_MESSAGE_CODE, WARNING_MESSAGE

Line 9971: DELETE from pa_distribution_warnings

9967: PA_FUND_REVAL_UTIL.Log_Message(p_message => PA_DEBUG.g_err_stage);
9968:
9969: END IF;
9970:
9971: DELETE from pa_distribution_warnings
9972: WHERE request_id = p_request_id;
9973:
9974: COMMIT;
9975: