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 602: TYPE t_pa_pkt_hist IS TABLE OF PA_BC_PACKETS_HIST%ROWTYPE;

598:
599: PROCEDURE populate_hist_table
600: IS
601:
602: TYPE t_pa_pkt_hist IS TABLE OF PA_BC_PACKETS_HIST%ROWTYPE;
603:
604: l_pa_pkt_hist t_pa_pkt_hist := t_pa_pkt_hist();
605: l_profile_value varchar2(255) := FND_PROFILE.VALUE('PA_MAINTAIN_FC_PACKETS');
606: CURSOR c_bc_pkts_x IS

Line 608: FROM pa_bc_packets

604: l_pa_pkt_hist t_pa_pkt_hist := t_pa_pkt_hist();
605: l_profile_value varchar2(255) := FND_PROFILE.VALUE('PA_MAINTAIN_FC_PACKETS');
606: CURSOR c_bc_pkts_x IS
607: SELECT *
608: FROM pa_bc_packets
609: WHERE status_code = 'X'
610: AND funds_process_mode <> 'B'
611: AND (trunc(sysdate) - trunc(creation_date)) >= l_profile_value;
612:

Line 632: pa_debug.g_err_stage := 'Log: No. of records to insert in pa_bc_packets_hist ' || l_pa_pkt_hist.count;

628: EXIT WHEN l_pa_pkt_hist.COUNT =0;
629:
630:
631: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
632: pa_debug.g_err_stage := 'Log: No. of records to insert in pa_bc_packets_hist ' || l_pa_pkt_hist.count;
633: pa_debug.write_file('LOG',pa_debug.g_err_stage);
634: END IF;
635:
636:

Line 638: INSERT INTO PA_BC_PACKETS_HIST VALUES l_pa_pkt_hist(i);

634: END IF;
635:
636:
637: FORALL i IN l_pa_pkt_hist.FIRST .. l_pa_pkt_hist.LAST
638: INSERT INTO PA_BC_PACKETS_HIST VALUES l_pa_pkt_hist(i);
639:
640: END LOOP;
641: CLOSE c_bc_pkts_x;
642:

Line 715: delete from pa_bc_packets

711: exit;
712: end if;
713:
714: FORALL i in l_RowIdTab.first..l_RowIdTab.last
715: delete from pa_bc_packets
716: where rowid = l_RowIdTab(i);
717:
718: /*Code Changes for Bug No.2984871 start */
719: l_rowcount:=sql%rowcount;

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

725: pa_funds_control_utils.print_message('Close c_delete_pkts');
726:
727: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
728: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
729: pa_debug.g_err_stage := 'Log: Last Deleted ' || to_char(l_rowcount) || ' records from PA_BC_PACKETS older than ' || l_profile_value || ' days';
730: pa_debug.write_file('LOG',pa_debug.g_err_stage);
731: END IF;
732: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
733: pa_funds_control_utils.print_message('No of Deleted old packets in pa_bc_packets = ' || to_char(l_rowcount));

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

729: pa_debug.g_err_stage := 'Log: Last Deleted ' || to_char(l_rowcount) || ' records from PA_BC_PACKETS older than ' || l_profile_value || ' days';
730: pa_debug.write_file('LOG',pa_debug.g_err_stage);
731: END IF;
732: /* Bug 2984871: Replaced sql%rwocount with l_rowcount in the below statement */
733: pa_funds_control_utils.print_message('No of Deleted old packets in pa_bc_packets = ' || to_char(l_rowcount));
734:
735: --deleting rows older than 'X' days which is set in the profile
736: --(batch_id of -999 are those belonging to actuals)
737: /*

Line 760: --Loop for distinct project in pa_bc_packets

756: pa_debug.g_err_stage := 'Log: Entering Loop';
757: pa_debug.write_file('LOG',pa_debug.g_err_stage);
758: END IF;
759:
760: --Loop for distinct project in pa_bc_packets
761: FOR eRec in c_pkt_proj LOOP
762:
763: l_project_id := eRec.project_id;
764: pa_funds_control_utils.print_message('*******************************************************');

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

981: END IF;
982:
983: pa_funds_control_utils.print_message('Inserting Commitments');
984:
985: --Insert into pa_bc_commitments_all if bc_commitment_id is null in pa_bc_packets
986: FORALL k in l_PktIdTab.FIRST..l_PktIdTab.LAST
987: insert into pa_bc_commitments_all(
988: bc_commitment_id,
989: packet_id,

Line 1250: UPDATE pa_bc_packets pbc

1246: pa_debug.write_file('LOG', 'Pkt FIRST = ' || l_StsUpdPktIdTab.FIRST || ' LAST = '|| l_StsUpdPktIdTab.LAST );
1247: pa_debug.write_file('LOG', 'Bc Pkt FIRST = ' || l_StsUpdBcPktIdTab.FIRST || ' LAST = '|| l_StsUpdBcPktIdTab.LAST );
1248: END IF;
1249: FORALL m in l_StsUpdPktIdTab.FIRST..l_StsUpdPktIdTab.LAST
1250: UPDATE pa_bc_packets pbc
1251: SET pbc.status_code = 'X',
1252: pbc.balance_posted_flag = 'Y',
1253: pbc.last_update_date = sysdate,
1254: pbc.last_update_login = fnd_global.login_id,

Line 1431: --Update status_code and balance_posted_flag in pa_bc_packets

1427: END IF;
1428:
1429: pa_funds_control_utils.print_message('Update status_code and balance_posted_flag');
1430:
1431: --Update status_code and balance_posted_flag in pa_bc_packets
1432: FORALL m in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1433: UPDATE pa_bc_packets pbc
1434: SET pbc.status_code = 'X',
1435: pbc.balance_posted_flag = 'Y',

Line 1433: UPDATE pa_bc_packets pbc

1429: pa_funds_control_utils.print_message('Update status_code and balance_posted_flag');
1430:
1431: --Update status_code and balance_posted_flag in pa_bc_packets
1432: FORALL m in l_InsProjectTab.FIRST..l_InsProjectTab.LAST
1433: UPDATE pa_bc_packets pbc
1434: SET pbc.status_code = 'X',
1435: pbc.balance_posted_flag = 'Y',
1436: pbc.last_update_date = sysdate,
1437: pbc.last_update_login = fnd_global.login_id,