APPS.PSB_PSBRPSBI_XMLP_PKG dependencies on STANDARD

Line 13: IF (P_STANDARD_BUDGET_ITEM_ID IS NULL) THEN

9: IF (P_SET_OF_BOOKS_ID IS NULL) THEN
10: FND_MESSAGE.SET_NAME('PSB'
11: ,'PSB_ALL');
12: CP_SET_OF_BOOKS := FND_MESSAGE.GET;
13: IF (P_STANDARD_BUDGET_ITEM_ID IS NULL) THEN
14: FND_MESSAGE.SET_NAME('PSB'
15: ,'PSB_ALL');
16: CP_STANDARD_BUDGET_ITEMS := FND_MESSAGE.GET;
17: ELSE

Line 16: CP_STANDARD_BUDGET_ITEMS := FND_MESSAGE.GET;

12: CP_SET_OF_BOOKS := FND_MESSAGE.GET;
13: IF (P_STANDARD_BUDGET_ITEM_ID IS NULL) THEN
14: FND_MESSAGE.SET_NAME('PSB'
15: ,'PSB_ALL');
16: CP_STANDARD_BUDGET_ITEMS := FND_MESSAGE.GET;
17: ELSE
18: SELECT
19: NAME
20: INTO CP_STANDARD_BUDGET_ITEMS

Line 20: INTO CP_STANDARD_BUDGET_ITEMS

16: CP_STANDARD_BUDGET_ITEMS := FND_MESSAGE.GET;
17: ELSE
18: SELECT
19: NAME
20: INTO CP_STANDARD_BUDGET_ITEMS
21: FROM
22: PSB_STANDARD_BUDGET_ITEMS
23: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;
24: SELECT

Line 22: PSB_STANDARD_BUDGET_ITEMS

18: SELECT
19: NAME
20: INTO CP_STANDARD_BUDGET_ITEMS
21: FROM
22: PSB_STANDARD_BUDGET_ITEMS
23: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;
24: SELECT
25: SET_OF_BOOKS_ID
26: INTO SOB_ID

Line 23: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;

19: NAME
20: INTO CP_STANDARD_BUDGET_ITEMS
21: FROM
22: PSB_STANDARD_BUDGET_ITEMS
23: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;
24: SELECT
25: SET_OF_BOOKS_ID
26: INTO SOB_ID
27: FROM

Line 28: PSB_STANDARD_BUDGET_ITEM_LINES

24: SELECT
25: SET_OF_BOOKS_ID
26: INTO SOB_ID
27: FROM
28: PSB_STANDARD_BUDGET_ITEM_LINES
29: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;
30: SELECT
31: NAME
32: INTO CP_SET_OF_BOOKS

Line 29: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;

25: SET_OF_BOOKS_ID
26: INTO SOB_ID
27: FROM
28: PSB_STANDARD_BUDGET_ITEM_LINES
29: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;
30: SELECT
31: NAME
32: INTO CP_SET_OF_BOOKS
33: FROM

Line 45: IF (P_STANDARD_BUDGET_ITEM_ID IS NULL) THEN

41: INTO CP_SET_OF_BOOKS
42: FROM
43: GL_SETS_OF_BOOKS
44: WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID1;
45: IF (P_STANDARD_BUDGET_ITEM_ID IS NULL) THEN
46: FND_MESSAGE.SET_NAME('PSB'
47: ,'PSB_ALL');
48: CP_STANDARD_BUDGET_ITEMS := FND_MESSAGE.GET;
49: ELSE

Line 48: CP_STANDARD_BUDGET_ITEMS := FND_MESSAGE.GET;

44: WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID1;
45: IF (P_STANDARD_BUDGET_ITEM_ID IS NULL) THEN
46: FND_MESSAGE.SET_NAME('PSB'
47: ,'PSB_ALL');
48: CP_STANDARD_BUDGET_ITEMS := FND_MESSAGE.GET;
49: ELSE
50: SELECT
51: NAME
52: INTO CP_STANDARD_BUDGET_ITEMS

Line 52: INTO CP_STANDARD_BUDGET_ITEMS

48: CP_STANDARD_BUDGET_ITEMS := FND_MESSAGE.GET;
49: ELSE
50: SELECT
51: NAME
52: INTO CP_STANDARD_BUDGET_ITEMS
53: FROM
54: PSB_STANDARD_BUDGET_ITEMS
55: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;
56: END IF;

Line 54: PSB_STANDARD_BUDGET_ITEMS

50: SELECT
51: NAME
52: INTO CP_STANDARD_BUDGET_ITEMS
53: FROM
54: PSB_STANDARD_BUDGET_ITEMS
55: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;
56: END IF;
57: END IF;
58: FND_MESSAGE.SET_NAME('PSB'

Line 55: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;

51: NAME
52: INTO CP_STANDARD_BUDGET_ITEMS
53: FROM
54: PSB_STANDARD_BUDGET_ITEMS
55: WHERE STANDARD_BUDGET_ITEM_ID = P_STANDARD_BUDGET_ITEM_ID;
56: END IF;
57: END IF;
58: FND_MESSAGE.SET_NAME('PSB'
59: ,'PSB_NO_DATA_FOUND');

Line 108: FUNCTION CP_STANDARD_BUDGET_ITEMS_P RETURN VARCHAR2 IS

104: BEGIN
105: RETURN CP_SET_OF_BOOKS;
106: END CP_SET_OF_BOOKS_P;
107:
108: FUNCTION CP_STANDARD_BUDGET_ITEMS_P RETURN VARCHAR2 IS
109: BEGIN
110: RETURN CP_STANDARD_BUDGET_ITEMS;
111: END CP_STANDARD_BUDGET_ITEMS_P;
112:

Line 110: RETURN CP_STANDARD_BUDGET_ITEMS;

106: END CP_SET_OF_BOOKS_P;
107:
108: FUNCTION CP_STANDARD_BUDGET_ITEMS_P RETURN VARCHAR2 IS
109: BEGIN
110: RETURN CP_STANDARD_BUDGET_ITEMS;
111: END CP_STANDARD_BUDGET_ITEMS_P;
112:
113: END PSB_PSBRPSBI_XMLP_PKG;
114:

Line 111: END CP_STANDARD_BUDGET_ITEMS_P;

107:
108: FUNCTION CP_STANDARD_BUDGET_ITEMS_P RETURN VARCHAR2 IS
109: BEGIN
110: RETURN CP_STANDARD_BUDGET_ITEMS;
111: END CP_STANDARD_BUDGET_ITEMS_P;
112:
113: END PSB_PSBRPSBI_XMLP_PKG;
114:
115: