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.

APPS.GMF_VALIDATIONS_PVT dependencies on CM_CLDR_HDR

Line 77: --| on cm_cldr_hdr |

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

Line 94: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE

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

Line 98: CURSOR cur_cm_cldr_hdr

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

Line 103: cm_cldr_hdr

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

Line 108: l_calendar_code cm_cldr_hdr.Calendar_Code%TYPE ;

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

Line 112: OPEN cur_cm_cldr_hdr;

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

Line 113: FETCH cur_cm_cldr_hdr INTO l_calendar_code;

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

Line 114: IF (cur_cm_cldr_hdr%NOTFOUND)

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

Line 116: CLOSE cur_cm_cldr_hdr;

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

Line 119: CLOSE cur_cm_cldr_hdr;

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

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

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

Line 154: p_calendar_code IN cm_cldr_hdr.Calendar_Code%TYPE

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

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

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

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

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

Line 159: CURSOR cur_cm_cldr_hdr

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

Line 164: cm_cldr_hdr

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

Line 171: OPEN cur_cm_cldr_hdr;

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

Line 172: FETCH cur_cm_cldr_hdr INTO x_co_code, x_cost_mthd_code;

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

Line 173: CLOSE cur_cm_cldr_hdr;

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

Line 175: IF (cur_cm_cldr_hdr%NOTFOUND)

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

Line 177: CLOSE cur_cm_cldr_hdr;

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

Line 180: CLOSE cur_cm_cldr_hdr;

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

Line 217: p_Calendar_Code IN cm_cldr_hdr.Calendar_Code%TYPE,

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

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

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

Line 2472: p_calendar_code IN cm_cldr_hdr_b.calendar_code%TYPE,

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