eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on CM_CLDR_HDR

Line 75: --| on cm_cldr_hdr |

71: --| Validates Calendar Code |
72: --| |
73: --| DESCRIPTION |
74: --| This function validates that the Calendar Code exists in |
75: --| on cm_cldr_hdr |
76: --| |
77: --| PARAMETERS |
78: --| p_calendar_code IN VARCHAR2(4) - Calendar Method Code |
79: --| |

Line 92: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE

88: -- Func end of comments
89:
90: FUNCTION Validate_Calendar_Code
91: (
92: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE
93: )
94: RETURN BOOLEAN
95: IS
96: CURSOR cur_cm_cldr_hdr

Line 96: CURSOR cur_cm_cldr_hdr

92: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE
93: )
94: RETURN BOOLEAN
95: IS
96: CURSOR cur_cm_cldr_hdr
97: IS
98: SELECT
99: calendar_code
100: FROM

Line 101: cm_cldr_hdr

97: IS
98: SELECT
99: calendar_code
100: FROM
101: cm_cldr_hdr
102: WHERE
103: calendar_code = p_calendar_code
104: AND delete_mark = 0;
105:

Line 106: l_calendar_code cm_cldr_hdr.Calendar_Code%TYPE ;

102: WHERE
103: calendar_code = p_calendar_code
104: AND delete_mark = 0;
105:
106: l_calendar_code cm_cldr_hdr.Calendar_Code%TYPE ;
107:
108: BEGIN
109:
110: OPEN cur_cm_cldr_hdr;

Line 110: OPEN cur_cm_cldr_hdr;

106: l_calendar_code cm_cldr_hdr.Calendar_Code%TYPE ;
107:
108: BEGIN
109:
110: OPEN cur_cm_cldr_hdr;
111: FETCH cur_cm_cldr_hdr INTO l_calendar_code;
112: IF (cur_cm_cldr_hdr%NOTFOUND)
113: THEN
114: CLOSE cur_cm_cldr_hdr;

Line 111: FETCH cur_cm_cldr_hdr INTO l_calendar_code;

107:
108: BEGIN
109:
110: OPEN cur_cm_cldr_hdr;
111: FETCH cur_cm_cldr_hdr INTO l_calendar_code;
112: IF (cur_cm_cldr_hdr%NOTFOUND)
113: THEN
114: CLOSE cur_cm_cldr_hdr;
115: RETURN FALSE;

Line 112: IF (cur_cm_cldr_hdr%NOTFOUND)

108: BEGIN
109:
110: OPEN cur_cm_cldr_hdr;
111: FETCH cur_cm_cldr_hdr INTO l_calendar_code;
112: IF (cur_cm_cldr_hdr%NOTFOUND)
113: THEN
114: CLOSE cur_cm_cldr_hdr;
115: RETURN FALSE;
116: ELSE

Line 114: CLOSE cur_cm_cldr_hdr;

110: OPEN cur_cm_cldr_hdr;
111: FETCH cur_cm_cldr_hdr INTO l_calendar_code;
112: IF (cur_cm_cldr_hdr%NOTFOUND)
113: THEN
114: CLOSE cur_cm_cldr_hdr;
115: RETURN FALSE;
116: ELSE
117: CLOSE cur_cm_cldr_hdr;
118: RETURN TRUE;

Line 117: CLOSE cur_cm_cldr_hdr;

113: THEN
114: CLOSE cur_cm_cldr_hdr;
115: RETURN FALSE;
116: ELSE
117: CLOSE cur_cm_cldr_hdr;
118: RETURN TRUE;
119: END IF;
120:
121: EXCEPTION

Line 137: --| on cm_cldr_hdr and returns co_code and cost method |

133: --| Validates Calendar Code |
134: --| |
135: --| DESCRIPTION |
136: --| This function validates that the Calendar Code exists in |
137: --| on cm_cldr_hdr and returns co_code and cost method |
138: --| |
139: --| PARAMETERS |
140: --| p_calendar_code IN VARCHAR2(4) - Calendar Method Code |
141: --| |

Line 152: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE

148: -- Func end of comments
149:
150: PROCEDURE Validate_Calendar_Code
151: (
152: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE
153: , x_co_code OUT NOCOPY cm_cldr_hdr.co_code%TYPE
154: , x_cost_mthd_code OUT NOCOPY cm_cldr_hdr.cost_mthd_code%TYPE
155: )
156: IS

Line 153: , x_co_code OUT NOCOPY cm_cldr_hdr.co_code%TYPE

149:
150: PROCEDURE Validate_Calendar_Code
151: (
152: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE
153: , x_co_code OUT NOCOPY cm_cldr_hdr.co_code%TYPE
154: , x_cost_mthd_code OUT NOCOPY cm_cldr_hdr.cost_mthd_code%TYPE
155: )
156: IS
157: CURSOR cur_cm_cldr_hdr

Line 154: , x_cost_mthd_code OUT NOCOPY cm_cldr_hdr.cost_mthd_code%TYPE

150: PROCEDURE Validate_Calendar_Code
151: (
152: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE
153: , x_co_code OUT NOCOPY cm_cldr_hdr.co_code%TYPE
154: , x_cost_mthd_code OUT NOCOPY cm_cldr_hdr.cost_mthd_code%TYPE
155: )
156: IS
157: CURSOR cur_cm_cldr_hdr
158: IS

Line 157: CURSOR cur_cm_cldr_hdr

153: , x_co_code OUT NOCOPY cm_cldr_hdr.co_code%TYPE
154: , x_cost_mthd_code OUT NOCOPY cm_cldr_hdr.cost_mthd_code%TYPE
155: )
156: IS
157: CURSOR cur_cm_cldr_hdr
158: IS
159: SELECT
160: co_code, cost_mthd_code
161: FROM

Line 162: cm_cldr_hdr

158: IS
159: SELECT
160: co_code, cost_mthd_code
161: FROM
162: cm_cldr_hdr
163: WHERE
164: calendar_code = p_calendar_code
165: AND delete_mark = 0;
166:

Line 169: OPEN cur_cm_cldr_hdr;

165: AND delete_mark = 0;
166:
167: BEGIN
168:
169: OPEN cur_cm_cldr_hdr;
170: FETCH cur_cm_cldr_hdr INTO x_co_code, x_cost_mthd_code;
171: CLOSE cur_cm_cldr_hdr;
172: /*
173: IF (cur_cm_cldr_hdr%NOTFOUND)

Line 170: FETCH cur_cm_cldr_hdr INTO x_co_code, x_cost_mthd_code;

166:
167: BEGIN
168:
169: OPEN cur_cm_cldr_hdr;
170: FETCH cur_cm_cldr_hdr INTO x_co_code, x_cost_mthd_code;
171: CLOSE cur_cm_cldr_hdr;
172: /*
173: IF (cur_cm_cldr_hdr%NOTFOUND)
174: THEN

Line 171: CLOSE cur_cm_cldr_hdr;

167: BEGIN
168:
169: OPEN cur_cm_cldr_hdr;
170: FETCH cur_cm_cldr_hdr INTO x_co_code, x_cost_mthd_code;
171: CLOSE cur_cm_cldr_hdr;
172: /*
173: IF (cur_cm_cldr_hdr%NOTFOUND)
174: THEN
175: CLOSE cur_cm_cldr_hdr;

Line 173: IF (cur_cm_cldr_hdr%NOTFOUND)

169: OPEN cur_cm_cldr_hdr;
170: FETCH cur_cm_cldr_hdr INTO x_co_code, x_cost_mthd_code;
171: CLOSE cur_cm_cldr_hdr;
172: /*
173: IF (cur_cm_cldr_hdr%NOTFOUND)
174: THEN
175: CLOSE cur_cm_cldr_hdr;
176: RETURN FALSE;
177: ELSE

Line 175: CLOSE cur_cm_cldr_hdr;

171: CLOSE cur_cm_cldr_hdr;
172: /*
173: IF (cur_cm_cldr_hdr%NOTFOUND)
174: THEN
175: CLOSE cur_cm_cldr_hdr;
176: RETURN FALSE;
177: ELSE
178: CLOSE cur_cm_cldr_hdr;
179: RETURN TRUE;

Line 178: CLOSE cur_cm_cldr_hdr;

174: THEN
175: CLOSE cur_cm_cldr_hdr;
176: RETURN FALSE;
177: ELSE
178: CLOSE cur_cm_cldr_hdr;
179: RETURN TRUE;
180: END IF;
181: */
182: EXCEPTION

Line 215: p_Calendar_Code IN cm_cldr_hdr.Calendar_Code%TYPE,

211: -- Func end of comments
212:
213: PROCEDURE Validate_Period_Code
214: (
215: p_Calendar_Code IN cm_cldr_hdr.Calendar_Code%TYPE,
216: p_Period_Code IN cm_cldr_dtl.Period_Code%TYPE,
217: x_Period_Status OUT NOCOPY cm_cldr_dtl.period_status%TYPE
218: )
219: IS

Line 2457: * p_calendar_code IN cm_cldr_hdr_b.calendar_code%TYPE *

2453: * This function validates that the Period Code exists *
2454: * *
2455: * PARAMETERS *
2456: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2457: * p_calendar_code IN cm_cldr_hdr_b.calendar_code%TYPE *
2458: * p_period_code IN cm_cldr_dtl.period_code%TYPE *
2459: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *
2460: * *
2461: * RETURNS *

Line 2470: p_calendar_code IN cm_cldr_hdr_b.calendar_code%TYPE,

2466: ***************************************************************************************/
2467: FUNCTION Validate_period_code
2468: (
2469: p_organization_id IN mtl_organizations.organization_id%TYPE,
2470: p_calendar_code IN cm_cldr_hdr_b.calendar_code%TYPE,
2471: p_period_code IN cm_cldr_dtl.period_code%TYPE,
2472: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE
2473: )
2474: RETURN NUMBER