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_ARCH

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 1163: INSERT INTO PSP_ENC_LINES_ARCH

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,
1166: org_schedule_id, default_org_account_id, suspense_org_account_id,
1167: element_account_id, gl_project_flag, enc_summary_line_id,

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 1452: FROM PSP_ENC_LINES_ARCH PELA

1448: pela.payroll_action_id, pela.orig_gl_code_combination_id, pela.orig_project_id,
1449: pela.orig_task_id, pela.orig_award_id, pela.orig_expenditure_org_id,
1450: pela.orig_expenditure_type, pela.hierarchy_code,
1451: pela.hierarchy_start_date, pela.hierarchy_end_date
1452: FROM PSP_ENC_LINES_ARCH PELA
1453: WHERE PELA.time_period_id = l_time_period;
1454:
1455: -- Insert data Into PSP_ENC_SUMMARY_LINES from PSP_ENC_SUMMARY_LINES_ARCH for the current period
1456: INSERT INTO PSP_ENC_SUMMARY_LINES

Line 1513: -- Delete from PSP_ENC_LINES_ARCH for the current period

1509: FROM PSP_ENC_SUMMARY_LINES_ARCH PESLA
1510: WHERE PESLA.time_period_id = l_time_period;
1511:
1512: -- Purge the archived data
1513: -- Delete from PSP_ENC_LINES_ARCH for the current period
1514: DELETE PSP_ENC_LINES_ARCH
1515: WHERE time_period_id = l_time_period;
1516:
1517: -- Delete from PSP_ENC_SUMMARY_LINES_ARCH for the current period

Line 1514: DELETE PSP_ENC_LINES_ARCH

1510: WHERE PESLA.time_period_id = l_time_period;
1511:
1512: -- Purge the archived data
1513: -- Delete from PSP_ENC_LINES_ARCH for the current period
1514: DELETE PSP_ENC_LINES_ARCH
1515: WHERE time_period_id = l_time_period;
1516:
1517: -- Delete from PSP_ENC_SUMMARY_LINES_ARCH for the current period
1518: DELETE PSP_ENC_SUMMARY_LINES_ARCH