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 844: --Update the balances if the record exists in pa_bc_balances

840: END IF;
841:
842: pa_funds_control_utils.print_message('Before update of balances');
843:
844: --Update the balances if the record exists in pa_bc_balances
845: FORALL i in l_PktIdTab.FIRST..l_PktIdTab.LAST
846: UPDATE pa_bc_balances pb
847: SET pb.last_update_date = sysdate,
848: pb.last_update_login = fnd_global.login_id,

Line 846: UPDATE pa_bc_balances pb

842: pa_funds_control_utils.print_message('Before update of balances');
843:
844: --Update the balances if the record exists in pa_bc_balances
845: FORALL i in l_PktIdTab.FIRST..l_PktIdTab.LAST
846: UPDATE pa_bc_balances pb
847: SET pb.last_update_date = sysdate,
848: pb.last_update_login = fnd_global.login_id,
849: pb.last_updated_by = fnd_global.user_id,
850: pb.request_id = fnd_global.conc_request_id,

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

1298: pa_debug.g_err_stage := 'Log: Before inserting balances';
1299: pa_debug.write_file('LOG',pa_debug.g_err_stage);
1300: END IF;
1301:
1302: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');
1303:
1304: --Insert into pa_bc_balances
1305: FORALL p in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1306: insert into pa_bc_balances(project_id

Line 1304: --Insert into pa_bc_balances

1300: END IF;
1301:
1302: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');
1303:
1304: --Insert into pa_bc_balances
1305: FORALL p in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1306: insert into pa_bc_balances(project_id
1307: ,task_id
1308: ,top_task_id

Line 1306: insert into pa_bc_balances(project_id

1302: pa_funds_control_utils.print_message('Before inserting into pa_bc_balances');
1303:
1304: --Insert into pa_bc_balances
1305: FORALL p in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1306: insert into pa_bc_balances(project_id
1307: ,task_id
1308: ,top_task_id
1309: ,resource_list_member_id
1310: ,set_of_books_id