APPS.PA_SWEEPER dependencies on FND_PROFILE

Line 338: l_profile_value varchar2(255) := FND_PROFILE.VALUE('PA_MAINTAIN_FC_PACKETS'); -- Added for Bug 4588095

334: , pbc.status_code;
335: /*Bug 3007393*/
336: /*, pbc.org_id;*/
337:
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

Line 344: -- and (trunc(sysdate) - trunc(creation_date)) >= FND_PROFILE.VALUE_SPECIFIC('PA_MAINTAIN_FC_PACKETS'); Modified for Bug 4588095

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
347: select rowid
348: from pa_bc_packets pbc

Line 605: l_profile_value varchar2(255) := FND_PROFILE.VALUE('PA_MAINTAIN_FC_PACKETS');

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
607: SELECT *
608: FROM pa_bc_packets
609: WHERE status_code = 'X'

Line 659: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

655:
656: --Initialize the message table for FND_MSG_PUB
657: fnd_msg_pub.initialize;
658:
659: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
660: l_debug_mode := NVL(l_debug_mode, 'N');
661:
662: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
663:

Line 741: and (trunc(sysdate) - trunc(last_update_date)) >= FND_PROFILE.VALUE_SPECIFIC('PA_MAINTAIN_FC_PACKETS');

737: /*
738: The below delete is removed for R12
739: delete from gl_bc_packets
740: where je_batch_id = -999
741: and (trunc(sysdate) - trunc(last_update_date)) >= FND_PROFILE.VALUE_SPECIFIC('PA_MAINTAIN_FC_PACKETS');
742: */
743:
744: /*Code Changes for Bug No.2984871 start */
745: l_rowcount:=sql%rowcount;