APPS.PA_TXN_ACCUMS dependencies on FND_PROFILE

Line 39: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

35: x_err_stage IN OUT NOCOPY VARCHAR2,
36: x_err_code IN OUT NOCOPY NUMBER)
37: IS
38: x_err_stack VARCHAR2(255);
39: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
40:
41: BEGIN
42: x_err_code :=0;
43: x_err_stage := 'Getting the accumulation configuration';

Line 182: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

178: x_err_stage IN OUT NOCOPY VARCHAR2,
179: x_err_code IN OUT NOCOPY NUMBER)
180: IS
181: tot_recs_processed NUMBER;
182: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
183: /*Code Changes for Bug No.2984871 start */
184: l_rowcount number :=0;
185: /*Code Changes for Bug No.2984871 end */
186:

Line 263: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

259: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
260: x_err_stage IN OUT NOCOPY VARCHAR2,
261: x_err_code IN OUT NOCOPY NUMBER)
262: IS
263: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
264:
265:
266: BEGIN
267: x_err_code :=0;

Line 438: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

434: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
435: x_err_stage IN OUT NOCOPY VARCHAR2,
436: x_err_code IN OUT NOCOPY NUMBER)
437: IS
438: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
439:
440:
441: BEGIN
442: x_err_code :=0;

Line 522: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

518: x_err_stage IN OUT NOCOPY VARCHAR2,
519: x_err_code IN OUT NOCOPY NUMBER)
520:
521: IS
522: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
523: BEGIN
524: x_err_code :=0;
525: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
526: x_err_stage := 'Refreshing Revenue transaction accum';

Line 584: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

580: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
581: x_err_stage IN OUT NOCOPY VARCHAR2,
582: x_err_code IN OUT NOCOPY NUMBER)
583: IS
584: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
585: BEGIN
586: x_err_code :=0;
587: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
588: x_err_stage := 'Refreshing commitments transaction accum';

Line 643: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

639: x_end_project_id IN NUMBER,
640: x_err_stage IN OUT NOCOPY VARCHAR2,
641: x_err_code IN OUT NOCOPY NUMBER)
642: IS
643: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
644: BEGIN
645: x_err_code :=0;
646:
647: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 735: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

731: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
732: x_err_stage IN OUT NOCOPY VARCHAR2,
733: x_err_code IN OUT NOCOPY NUMBER)
734: IS
735: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
736: tot_recs_processed NUMBER;
737: /*Code Changes for Bug No.2984871 start */
738: l_rowcount number :=0;
739: /*Code Changes for Bug No.2984871 end */

Line 805: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

801: x_end_pa_date IN DATE,
802: x_err_stage IN OUT NOCOPY VARCHAR2,
803: x_err_code IN OUT NOCOPY NUMBER)
804: IS
805: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
806: tot_recs_processed NUMBER;
807: /*Code Changes for Bug No.2984871 start */
808: l_rowcount number :=0;
809: /*Code Changes for Bug No.2984871 end */

Line 874: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

870: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
871: x_err_stage IN OUT NOCOPY VARCHAR2,
872: x_err_code IN OUT NOCOPY NUMBER)
873: IS
874: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
875: /*Code Changes for Bug No.2984871 start */
876: l_rowcount number :=0;
877: /*Code Changes for Bug No.2984871 end */
878:

Line 1237: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

1233: x_err_stage IN OUT NOCOPY VARCHAR2,
1234: x_err_code IN OUT NOCOPY NUMBER)
1235:
1236: IS
1237: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
1238:
1239: tot_recs_processed NUMBER;
1240: /*Code Changes for Bug No.2984871 start */
1241: l_rowcount number :=0;

Line 1327: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

1323: x_err_code IN OUT NOCOPY NUMBER,
1324: x_use_tmp_table IN VARCHAR2 DEFAULT 'N' /*Added for bug 5635857*/)
1325: IS
1326:
1327: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
1328:
1329: l_cur_pa_period varchar2(20); /* Added for commitment change request */
1330: l_cur_gl_period varchar2(15); /* Added for commitment change request */
1331:

Line 2760: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

2756: x_cdl_line_type IN VARCHAR2,
2757: x_err_stage IN OUT NOCOPY VARCHAR2,
2758: x_err_code IN OUT NOCOPY NUMBER)
2759: IS
2760: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
2761:
2762:
2763: -- The cursor selcdl selects all CDLs which
2764: -- satisfy the pa_period given as the parameters

Line 3188: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

3184: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3185: x_err_stage IN OUT NOCOPY VARCHAR2,
3186: x_err_code IN OUT NOCOPY NUMBER)
3187: IS
3188: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3189:
3190:
3191: CURSOR selrdls IS
3192: SELECT

Line 3417: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

3413: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3414: x_err_stage IN OUT NOCOPY VARCHAR2,
3415: x_err_code IN OUT NOCOPY NUMBER)
3416: IS
3417: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3418:
3419:
3420:
3421: CURSOR selevents IS

Line 3636: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

3632: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3633: x_err_stage IN OUT NOCOPY VARCHAR2,
3634: x_err_code IN OUT NOCOPY NUMBER)
3635: IS
3636: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3637:
3638: CURSOR selrdls IS
3639: SELECT
3640: 'R' line_type,

Line 3942: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

3938: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3939: x_err_stage IN OUT NOCOPY VARCHAR2,
3940: x_err_code IN OUT NOCOPY NUMBER)
3941: IS
3942: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3943: --
3944: -- Cursors ---------------------------------------------------
3945: --
3946: -- The cursor selcmts selects all PA_COMMITMENT_TXNS which