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 2669: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/

2665: x_cdl_line_type IN VARCHAR2,
2666: x_err_stage IN OUT NOCOPY VARCHAR2,
2667: x_err_code IN OUT NOCOPY NUMBER)
2668: IS
2669: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
2670:
2671:
2672: -- The cursor selcdl selects all CDLs which
2673: -- satisfy the pa_period given as the parameters

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

3004: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3005: x_err_stage IN OUT NOCOPY VARCHAR2,
3006: x_err_code IN OUT NOCOPY NUMBER)
3007: IS
3008: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3009:
3010:
3011: CURSOR selrdls IS
3012: SELECT

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

3233: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3234: x_err_stage IN OUT NOCOPY VARCHAR2,
3235: x_err_code IN OUT NOCOPY NUMBER)
3236: IS
3237: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3238:
3239:
3240:
3241: CURSOR selevents IS

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

3452: x_mode IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3453: x_err_stage IN OUT NOCOPY VARCHAR2,
3454: x_err_code IN OUT NOCOPY NUMBER)
3455: IS
3456: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3457:
3458: CURSOR selrdls IS
3459: SELECT
3460: 'R' line_type,

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

3758: x_system_linkage_function IN VARCHAR2, -- Default value removed to avoid GSCC warning File.Pkg.22
3759: x_err_stage IN OUT NOCOPY VARCHAR2,
3760: x_err_code IN OUT NOCOPY NUMBER)
3761: IS
3762: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3763: --
3764: -- Cursors ---------------------------------------------------
3765: --
3766: -- The cursor selcmts selects all PA_COMMITMENT_TXNS which