APPS.PA_ACTION_SETS_PUB dependencies on PA_ACTION_SET_REPORT_TEMP

Line 1364: DELETE from pa_action_set_report_temp;

1360:
1361: BEGIN
1362: /*
1363: --TESTING
1364: DELETE from pa_action_set_report_temp;
1365: INSERT INTO pa_action_set_report_temp(action_set_line_id,
1366: project_number,
1367: object_name)
1368: select action_set_line_id, 'OBJ NAME', 'PROJ NAME'

Line 1365: INSERT INTO pa_action_set_report_temp(action_set_line_id,

1361: BEGIN
1362: /*
1363: --TESTING
1364: DELETE from pa_action_set_report_temp;
1365: INSERT INTO pa_action_set_report_temp(action_set_line_id,
1366: project_number,
1367: object_name)
1368: select action_set_line_id, 'OBJ NAME', 'PROJ NAME'
1369: from pa_action_set_lines;

Line 1382: DELETE FROM pa_action_set_report_temp;

1378: FND_FILE.PUT_LINE(FND_FILE.LOG,'concurrent request id='||FND_GLOBAL.CONC_REQUEST_ID);
1379:
1380: END IF;
1381:
1382: DELETE FROM pa_action_set_report_temp;
1383:
1384: IF p_action_set_type_code IS NULL THEN
1385: SELECT action_set_type_code BULK COLLECT INTO l_action_set_type_code_tbl
1386: FROM pa_action_set_types;

Line 1414: INSERT INTO pa_action_set_report_temp(action_set_line_id,

1410:
1411: IF l_action_set_line_id_tbl.COUNT > 0 THEN
1412:
1413: FORALL k IN l_action_set_line_id_tbl.FIRST .. l_action_set_line_id_tbl.LAST
1414: INSERT INTO pa_action_set_report_temp(action_set_line_id,
1415: project_number,
1416: object_name)
1417: VALUES(l_action_set_line_id_tbl(k),
1418: l_project_number_tbl(k),