APPS.PA_SWEEPER dependencies on PA_BC_PACKETS_HIST

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 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: