29: L_FLEX_MAPPING_SET_ID NUMBER;
30: BEGIN
31: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
32: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
33: FND_MESSAGE.SET_NAME('PSB'
34: ,'PSB_NO_DATA_FOUND');
35: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
36: FND_MESSAGE.SET_NAME('PSB'
37: ,'PSB_END_OF_REPORT');
31: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
32: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
33: FND_MESSAGE.SET_NAME('PSB'
34: ,'PSB_NO_DATA_FOUND');
35: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
36: FND_MESSAGE.SET_NAME('PSB'
37: ,'PSB_END_OF_REPORT');
38: CP_END_OF_REPORT := FND_MESSAGE.GET;
39: FOR y1_rec IN Y1 LOOP
32: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
33: FND_MESSAGE.SET_NAME('PSB'
34: ,'PSB_NO_DATA_FOUND');
35: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
36: FND_MESSAGE.SET_NAME('PSB'
37: ,'PSB_END_OF_REPORT');
38: CP_END_OF_REPORT := FND_MESSAGE.GET;
39: FOR y1_rec IN Y1 LOOP
40: CP_YEAR_NAME1 := Y1_REC.NAME;
34: ,'PSB_NO_DATA_FOUND');
35: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
36: FND_MESSAGE.SET_NAME('PSB'
37: ,'PSB_END_OF_REPORT');
38: CP_END_OF_REPORT := FND_MESSAGE.GET;
39: FOR y1_rec IN Y1 LOOP
40: CP_YEAR_NAME1 := Y1_REC.NAME;
41: END LOOP;
42: FOR y2_rec IN Y2 LOOP
48: FOR y4_rec IN Y4 LOOP
49: CP_YEAR_NAME4 := Y4_REC.NAME;
50: END LOOP;
51: IF P_SERVICE_PACKAGE_ID IS NULL THEN
52: FND_MESSAGE.SET_NAME('PSB'
53: ,'PSB_ALL');
54: CP_PARAM_SP_NAME := FND_MESSAGE.GET;
55: ELSE
56: SELECT
50: END LOOP;
51: IF P_SERVICE_PACKAGE_ID IS NULL THEN
52: FND_MESSAGE.SET_NAME('PSB'
53: ,'PSB_ALL');
54: CP_PARAM_SP_NAME := FND_MESSAGE.GET;
55: ELSE
56: SELECT
57: NAME
58: INTO CP_PARAM_SP_NAME
80: AND ST.BUDGET_STAGE_SET_ID = WS.STAGE_SET_ID
81: AND ST.SEQUENCE_NUMBER = WS.CURRENT_STAGE_SEQ;
82: END IF;
83: IF P_GLOBAL_WORKSHEET_ID IS NULL THEN
84: FND_MESSAGE.SET_NAME('PSB'
85: ,'PSB_ALL');
86: CP_PARAM_WS_NAME := FND_MESSAGE.GET;
87: ELSE
88: SELECT
82: END IF;
83: IF P_GLOBAL_WORKSHEET_ID IS NULL THEN
84: FND_MESSAGE.SET_NAME('PSB'
85: ,'PSB_ALL');
86: CP_PARAM_WS_NAME := FND_MESSAGE.GET;
87: ELSE
88: SELECT
89: NAME,
90: BUDGET_CALENDAR_ID,