4: BEGIN
5: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
6: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
7: IF P_SET_OF_BOOKS_ID IS NULL THEN
8: FND_MESSAGE.SET_NAME('PSB'
9: ,'PSB_ALL');
10: CP_SET_OF_BOOKS_NAME := FND_MESSAGE.GET;
11: FND_MESSAGE.SET_NAME('PSB'
12: ,'PSB_ALL');
6: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
7: IF P_SET_OF_BOOKS_ID IS NULL THEN
8: FND_MESSAGE.SET_NAME('PSB'
9: ,'PSB_ALL');
10: CP_SET_OF_BOOKS_NAME := FND_MESSAGE.GET;
11: FND_MESSAGE.SET_NAME('PSB'
12: ,'PSB_ALL');
13: CP_TOP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
14: ELSE
7: IF P_SET_OF_BOOKS_ID IS NULL THEN
8: FND_MESSAGE.SET_NAME('PSB'
9: ,'PSB_ALL');
10: CP_SET_OF_BOOKS_NAME := FND_MESSAGE.GET;
11: FND_MESSAGE.SET_NAME('PSB'
12: ,'PSB_ALL');
13: CP_TOP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
14: ELSE
15: SELECT
9: ,'PSB_ALL');
10: CP_SET_OF_BOOKS_NAME := FND_MESSAGE.GET;
11: FND_MESSAGE.SET_NAME('PSB'
12: ,'PSB_ALL');
13: CP_TOP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
14: ELSE
15: SELECT
16: NAME
17: INTO CP_SET_OF_BOOKS_NAME
18: FROM
19: GL_SETS_OF_BOOKS
20: WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
21: IF P_BUDGET_GROUP_ID IS NULL THEN
22: FND_MESSAGE.SET_NAME('PSB'
23: ,'PSB_ALL');
24: CP_TOP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
25: ELSE
26: SELECT
20: WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
21: IF P_BUDGET_GROUP_ID IS NULL THEN
22: FND_MESSAGE.SET_NAME('PSB'
23: ,'PSB_ALL');
24: CP_TOP_BUDGET_GROUP_NAME := FND_MESSAGE.GET;
25: ELSE
26: SELECT
27: NAME
28: INTO CP_TOP_BUDGET_GROUP_NAME
31: WHERE BUDGET_GROUP_ID = P_BUDGET_GROUP_ID;
32: END IF;
33: END IF;
34: IF P_DISTRIBUTION_RULE_ID IS NULL THEN
35: FND_MESSAGE.SET_NAME('PSB'
36: ,'PSB_ALL');
37: CP_DISTRIBUTION_RULE_NAME := FND_MESSAGE.GET;
38: ELSE
39: SELECT
33: END IF;
34: IF P_DISTRIBUTION_RULE_ID IS NULL THEN
35: FND_MESSAGE.SET_NAME('PSB'
36: ,'PSB_ALL');
37: CP_DISTRIBUTION_RULE_NAME := FND_MESSAGE.GET;
38: ELSE
39: SELECT
40: NAME
41: INTO CP_DISTRIBUTION_RULE_NAME
42: FROM
43: PSB_WS_DISTRIBUTION_RULES
44: WHERE DISTRIBUTION_RULE_ID = P_DISTRIBUTION_RULE_ID;
45: END IF;
46: FND_MESSAGE.SET_NAME('PSB'
47: ,'PSB_NO_DATA_FOUND');
48: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
49: FND_MESSAGE.SET_NAME('PSB'
50: ,'PSB_END_OF_REPORT');
44: WHERE DISTRIBUTION_RULE_ID = P_DISTRIBUTION_RULE_ID;
45: END IF;
46: FND_MESSAGE.SET_NAME('PSB'
47: ,'PSB_NO_DATA_FOUND');
48: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
49: FND_MESSAGE.SET_NAME('PSB'
50: ,'PSB_END_OF_REPORT');
51: CP_END_OF_REPORT := FND_MESSAGE.GET;
52: RETURN (TRUE);
45: END IF;
46: FND_MESSAGE.SET_NAME('PSB'
47: ,'PSB_NO_DATA_FOUND');
48: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
49: FND_MESSAGE.SET_NAME('PSB'
50: ,'PSB_END_OF_REPORT');
51: CP_END_OF_REPORT := FND_MESSAGE.GET;
52: RETURN (TRUE);
53: END BEFOREREPORT;
47: ,'PSB_NO_DATA_FOUND');
48: CP_NO_DATA_FOUND := FND_MESSAGE.GET;
49: FND_MESSAGE.SET_NAME('PSB'
50: ,'PSB_END_OF_REPORT');
51: CP_END_OF_REPORT := FND_MESSAGE.GET;
52: RETURN (TRUE);
53: END BEFOREREPORT;
54:
55: FUNCTION AFTERREPORT RETURN BOOLEAN IS