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 604: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

600:
601: --Initialize the message table for FND_MSG_PUB
602: fnd_msg_pub.initialize;
603:
604: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
605: l_debug_mode := NVL(l_debug_mode, 'N');
606:
607: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
608:

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

673: /*
674: The below delete is removed for R12
675: delete from gl_bc_packets
676: where je_batch_id = -999
677: and (trunc(sysdate) - trunc(last_update_date)) >= FND_PROFILE.VALUE_SPECIFIC('PA_MAINTAIN_FC_PACKETS');
678: */
679:
680: /*Code Changes for Bug No.2984871 start */
681: l_rowcount:=sql%rowcount;