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_PACKETS

Line 193: from pa_bc_packets

189: ,p_project_id IN NUMBER DEFAULT NULL) IS
190:
191: cursor c_pkt_proj is
192: select distinct project_id project_id
193: from pa_bc_packets
194: where status_code = 'A'
195: and substr(result_code ,1,1) = 'P'
196: --PA.M
197: and (Pa_Bc_Packets.Project_Id = P_Project_Id

Line 197: and (Pa_Bc_Packets.Project_Id = P_Project_Id

193: from pa_bc_packets
194: where status_code = 'A'
195: and substr(result_code ,1,1) = 'P'
196: --PA.M
197: and (Pa_Bc_Packets.Project_Id = P_Project_Id
198: Or P_ProjecT_Id is NULL) ;
199:
200: cursor c_bc_packets(l_project_id in number) is
201: select pbc.budget_version_id

Line 264: , pa_bc_packets pbc

260: , pbc.burden_method_code
261: , pbc.document_header_id_2
262: , pbc.document_distribution_type
263: from pa_budget_versions pbv
264: , pa_bc_packets pbc
265: , pa_budget_entry_methods pbm
266: where pbc.status_code = 'A'
267: and substr(pbc.result_code ,1,1) = 'P'
268: and pbc.balance_posted_flag = 'N'

Line 297: , pa_bc_packets pbc

293: , PA_SWEEPER.GetBCBalEndDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date, pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
294: /*Bug 3007393*/
295: /*, pbc.org_id*/
296: from pa_budget_versions pbv
297: , pa_bc_packets pbc
298: , pa_budget_entry_methods pbm
299: where pbc.status_code = 'A'
300: and substr(pbc.result_code ,1,1) = 'P'
301: and pbc.balance_posted_flag = 'N'

Line 342: from pa_bc_packets

338: l_profile_value varchar2(255) := FND_PROFILE.VALUE('PA_MAINTAIN_FC_PACKETS'); -- Added for Bug 4588095
339:
340: cursor c_delete_pkts is
341: select rowid
342: from pa_bc_packets
343: where status_code in ('X', 'V', 'L')
344: -- and (trunc(sysdate) - trunc(creation_date)) >= FND_PROFILE.VALUE_SPECIFIC('PA_MAINTAIN_FC_PACKETS'); Modified for Bug 4588095
345: and (trunc(sysdate) - trunc(creation_date)) >= l_profile_value
346: union all

Line 348: from pa_bc_packets pbc

344: -- and (trunc(sysdate) - trunc(creation_date)) >= FND_PROFILE.VALUE_SPECIFIC('PA_MAINTAIN_FC_PACKETS'); Modified for Bug 4588095
345: and (trunc(sysdate) - trunc(creation_date)) >= l_profile_value
346: union all
347: select rowid
348: from pa_bc_packets pbc
349: where pbc.status_code in ('P')
350: and ((pbc.session_id is not null and
351: pbc.serial_id is not null and
352: NOT EXISTS (SELECT 'x'

Line 366: from pa_bc_packets

362: )
363: )
364: union all
365: select rowid
366: from pa_bc_packets
367: where status_code in ('I')
368: and (trunc(sysdate) - trunc(creation_date)) >= 3
369: union all
370: select rowid

Line 371: from pa_bc_packets pbc

367: where status_code in ('I')
368: and (trunc(sysdate) - trunc(creation_date)) >= 3
369: union all
370: select rowid
371: from pa_bc_packets pbc
372: where pbc.status_code in ('S','F','T','R')
373: and (trunc(sysdate) - trunc(pbc.creation_date)) >= l_profile_value
374: and ((pbc.bc_event_id is null) OR
375: (pbc.bc_event_id is not null AND

Line 651: delete from pa_bc_packets

647: exit;
648: end if;
649:
650: FORALL i in l_RowIdTab.first..l_RowIdTab.last
651: delete from pa_bc_packets
652: where rowid = l_RowIdTab(i);
653:
654: /*Code Changes for Bug No.2984871 start */
655: l_rowcount:=sql%rowcount;

Line 665: pa_debug.g_err_stage := 'Log: Last Deleted ' || to_char(l_rowcount) || ' records from PA_BC_PACKETS older than ' || l_profile_value || ' days';

661: pa_funds_control_utils.print_message('Close c_delete_pkts');
662:
663: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
664: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
665: pa_debug.g_err_stage := 'Log: Last Deleted ' || to_char(l_rowcount) || ' records from PA_BC_PACKETS older than ' || l_profile_value || ' days';
666: pa_debug.write_file('LOG',pa_debug.g_err_stage);
667: END IF;
668: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
669: pa_funds_control_utils.print_message('No of Deleted old packets in pa_bc_packets = ' || to_char(l_rowcount));

Line 669: pa_funds_control_utils.print_message('No of Deleted old packets in pa_bc_packets = ' || to_char(l_rowcount));

665: pa_debug.g_err_stage := 'Log: Last Deleted ' || to_char(l_rowcount) || ' records from PA_BC_PACKETS older than ' || l_profile_value || ' days';
666: pa_debug.write_file('LOG',pa_debug.g_err_stage);
667: END IF;
668: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
669: pa_funds_control_utils.print_message('No of Deleted old packets in pa_bc_packets = ' || to_char(l_rowcount));
670:
671: --deleting rows older than 'X' days which is set in the profile
672: --(batch_id of -999 are those belonging to actuals)
673: /*

Line 696: --Loop for distinct project in pa_bc_packets

692: pa_debug.g_err_stage := 'Log: Entering Loop';
693: pa_debug.write_file('LOG',pa_debug.g_err_stage);
694: END IF;
695:
696: --Loop for distinct project in pa_bc_packets
697: FOR eRec in c_pkt_proj LOOP
698:
699: l_project_id := eRec.project_id;
700: pa_funds_control_utils.print_message('*******************************************************');

Line 921: --Insert into pa_bc_commitments_all if bc_commitment_id is null in pa_bc_packets

917: END IF;
918:
919: pa_funds_control_utils.print_message('Inserting Commitments');
920:
921: --Insert into pa_bc_commitments_all if bc_commitment_id is null in pa_bc_packets
922: FORALL k in l_PktIdTab.FIRST..l_PktIdTab.LAST
923: insert into pa_bc_commitments_all(
924: bc_commitment_id,
925: packet_id,

Line 1186: UPDATE pa_bc_packets pbc

1182: pa_debug.write_file('LOG', 'Pkt FIRST = ' || l_StsUpdPktIdTab.FIRST || ' LAST = '|| l_StsUpdPktIdTab.LAST );
1183: pa_debug.write_file('LOG', 'Bc Pkt FIRST = ' || l_StsUpdBcPktIdTab.FIRST || ' LAST = '|| l_StsUpdBcPktIdTab.LAST );
1184: END IF;
1185: FORALL m in l_StsUpdPktIdTab.FIRST..l_StsUpdPktIdTab.LAST
1186: UPDATE pa_bc_packets pbc
1187: SET pbc.status_code = 'X',
1188: pbc.balance_posted_flag = 'Y',
1189: pbc.last_update_date = sysdate,
1190: pbc.last_update_login = fnd_global.login_id,

Line 1367: --Update status_code and balance_posted_flag in pa_bc_packets

1363: END IF;
1364:
1365: pa_funds_control_utils.print_message('Update status_code and balance_posted_flag');
1366:
1367: --Update status_code and balance_posted_flag in pa_bc_packets
1368: FORALL m in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1369: UPDATE pa_bc_packets pbc
1370: SET pbc.status_code = 'X',
1371: pbc.balance_posted_flag = 'Y',

Line 1369: UPDATE pa_bc_packets pbc

1365: pa_funds_control_utils.print_message('Update status_code and balance_posted_flag');
1366:
1367: --Update status_code and balance_posted_flag in pa_bc_packets
1368: FORALL m in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1369: UPDATE pa_bc_packets pbc
1370: SET pbc.status_code = 'X',
1371: pbc.balance_posted_flag = 'Y',
1372: pbc.last_update_date = sysdate,
1373: pbc.last_update_login = fnd_global.login_id,