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.PA_SWEEPER dependencies on PA_BC_BALANCES

Line 9: -- If TPC = 'N' then get the start_date from pa_bc_balances where EI date falls

5: -- Purpose : Based on TPC, returns the start date
6: -- Changed 5/29 to check for GL date, PA date when TPC = G, P resp.
7: -- If TPC = GL then selects GL period start date where the given GL date falls.
8: -- If TPC = PA then selects PA period start date where the given PA date falls.
9: -- If TPC = 'N' then get the start_date from pa_bc_balances where EI date falls
10: -- for the given task, budget_version and RLMI.
11: FUNCTION GetBCBalStartDate(
12: p_time_phase_code in varchar2,
13: p_project_id in number,

Line 59: FROM pa_bc_balances

55: WHERE project_id = p_project_id;
56:
57: CURSOR c_prj_budg IS
58: SELECT MIN(start_date)
59: FROM pa_bc_balances
60: WHERE project_id = p_project_id
61: AND budget_version_id = p_bdgt_version;
62:
63: BEGIN

Line 101: -- If TPC = 'N' then get the end_date from pa_bc_balances where EI date falls

97: -- Purpose : Based on TPC, returns the end date
98: -- Changed 5/29 to check for GL date, PA date when TPC = G, P resp.
99: -- If TPC = GL then selects GL period end date where the given GL date falls.
100: -- If TPC = PA then selects PA period end date where the given PA date falls.
101: -- If TPC = 'N' then get the end_date from pa_bc_balances where EI date falls
102: -- for the given task, budget_version and RLMI.
103: FUNCTION GetBCBalEndDate(
104: p_time_phase_code in varchar2,
105: p_project_id in number,

Line 151: FROM pa_bc_balances

147: WHERE project_id = p_project_id;
148:
149: CURSOR c_prj_budg IS
150: SELECT MAX(end_date)
151: FROM pa_bc_balances
152: WHERE project_id = p_project_id
153: AND budget_version_id = p_bdgt_version;
154:
155: BEGIN

Line 308: from pa_bc_balances pb

304: and pbc.project_id = pbv.project_id
305: and pbc.project_id = l_project_id
306: and not exists (
307: select 'X'
308: from pa_bc_balances pb
309: where pb.project_id = l_project_id
310: AND pb.task_id = pbc.task_id
311: AND pb.resource_list_member_id = pbc.resource_list_member_id
312: AND pb.set_of_books_id = pbc.set_of_books_id

Line 908: --Update the balances if the record exists in pa_bc_balances

904: END IF;
905:
906: pa_funds_control_utils.print_message('Before update of balances');
907:
908: --Update the balances if the record exists in pa_bc_balances
909: FORALL i in l_PktIdTab.FIRST..l_PktIdTab.LAST
910: UPDATE pa_bc_balances pb
911: SET pb.last_update_date = sysdate,
912: pb.last_update_login = fnd_global.login_id,

Line 910: UPDATE pa_bc_balances pb

906: pa_funds_control_utils.print_message('Before update of balances');
907:
908: --Update the balances if the record exists in pa_bc_balances
909: FORALL i in l_PktIdTab.FIRST..l_PktIdTab.LAST
910: UPDATE pa_bc_balances pb
911: SET pb.last_update_date = sysdate,
912: pb.last_update_login = fnd_global.login_id,
913: pb.last_updated_by = fnd_global.user_id,
914: pb.request_id = fnd_global.conc_request_id,

Line 1366: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');

1362: pa_debug.g_err_stage := 'Log: Before inserting balances';
1363: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1364: END IF;
1365:
1366: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');
1367:
1368: --Insert into pa_bc_balances
1369: FORALL p in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1370: insert into pa_bc_balances(project_id

Line 1368: --Insert into pa_bc_balances

1364: END IF;
1365:
1366: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');
1367:
1368: --Insert into pa_bc_balances
1369: FORALL p in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1370: insert into pa_bc_balances(project_id
1371: ,task_id
1372: ,top_task_id

Line 1370: insert into pa_bc_balances(project_id

1366: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');
1367:
1368: --Insert into pa_bc_balances
1369: FORALL p in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1370: insert into pa_bc_balances(project_id
1371: ,task_id
1372: ,top_task_id
1373: ,resource_list_member_id
1374: ,set_of_books_id