eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ARCHIVE_RETRIEVE dependencies on PSP_ENC_LINES_HISTORY

Line 1161: -- Insert data Into PSP_ENC_LINES_ARCH from PSP_ENC_LINES_HISTORY for the current period

1157: Fetch valid_period_cur Into l_time_period, l_period_name;
1158: Exit When valid_period_cur%NOTFOUND;
1159:
1160: -- Insert data into ARCHIVE tables from HISTORY tables
1161: -- Insert data Into PSP_ENC_LINES_ARCH from PSP_ENC_LINES_HISTORY for the current period
1162: -- Added enc_start_date,enc_end_date for Enh. Bug# 2259310.
1163: INSERT INTO PSP_ENC_LINES_ARCH
1164: (enc_line_id, business_group_id, enc_element_type_id,
1165: encumbrance_date, enc_line_type, schedule_line_id,

Line 1203: FROM PSP_ENC_LINES_HISTORY PELH

1199: pelh.payroll_action_id, pelh.orig_gl_code_combination_id, pelh.orig_project_id,
1200: pelh.orig_task_id, pelh.orig_award_id, pelh.orig_expenditure_org_id,
1201: pelh.orig_expenditure_type, pelh.hierarchy_code,
1202: pelh.hierarchy_start_date, pelh.hierarchy_end_date
1203: FROM PSP_ENC_LINES_HISTORY PELH
1204: WHERE PELH.time_period_id = l_time_period;
1205:
1206: -- Insert data Into PSP_ENC_SUMMARY_LINES_ARCH from PSP_ENC_SUMMARY_LINES for the current period
1207: INSERT INTO PSP_ENC_SUMMARY_LINES_ARCH

Line 1262: -- Delete from PSP_ENC_LINES_HISTORY for the current period

1258: FROM PSP_ENC_SUMMARY_LINES PESL
1259: WHERE PESL.time_period_id = l_time_period;
1260:
1261: -- Purge the archived data
1262: -- Delete from PSP_ENC_LINES_HISTORY for the current period
1263: DELETE PSP_ENC_LINES_HISTORY
1264: WHERE time_period_id = l_time_period;
1265:
1266: -- Delete from PSP_ENC_SUMMARY_LINES for the current period

Line 1263: DELETE PSP_ENC_LINES_HISTORY

1259: WHERE PESL.time_period_id = l_time_period;
1260:
1261: -- Purge the archived data
1262: -- Delete from PSP_ENC_LINES_HISTORY for the current period
1263: DELETE PSP_ENC_LINES_HISTORY
1264: WHERE time_period_id = l_time_period;
1265:
1266: -- Delete from PSP_ENC_SUMMARY_LINES for the current period
1267: DELETE PSP_ENC_SUMMARY_LINES

Line 1410: -- Insert data Into PSP_ENC_LINES_HISTORY from PSP_ENC_LINES_ARCH for the current period

1406: Fetch valid_period_cur Into l_time_period, l_period_name;
1407: Exit When valid_period_cur%NOTFOUND;
1408:
1409: -- Insert data into ARCHIVE tables from HISTORY tables
1410: -- Insert data Into PSP_ENC_LINES_HISTORY from PSP_ENC_LINES_ARCH for the current period
1411: -- Added enc_start_date,enc_end_date for Enh. Enc Redesign - Prorata.Bug # 2259310.
1412: INSERT INTO PSP_ENC_LINES_HISTORY
1413: (enc_line_id, business_group_id, enc_element_type_id,
1414: encumbrance_date, enc_line_type, schedule_line_id,

Line 1412: INSERT INTO PSP_ENC_LINES_HISTORY

1408:
1409: -- Insert data into ARCHIVE tables from HISTORY tables
1410: -- Insert data Into PSP_ENC_LINES_HISTORY from PSP_ENC_LINES_ARCH for the current period
1411: -- Added enc_start_date,enc_end_date for Enh. Enc Redesign - Prorata.Bug # 2259310.
1412: INSERT INTO PSP_ENC_LINES_HISTORY
1413: (enc_line_id, business_group_id, enc_element_type_id,
1414: encumbrance_date, enc_line_type, schedule_line_id,
1415: org_schedule_id, default_org_account_id, suspense_org_account_id,
1416: element_account_id, gl_project_flag, enc_summary_line_id,