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_MTHD_MST

Line 265: --| on cm_mthd_mst |

261: --| Validates cost_mthd_code |
262: --| |
263: --| DESCRIPTION |
264: --| This function validates that the cost Method Code exists |
265: --| on cm_mthd_mst |
266: --| |
267: --| PARAMETERS |
268: --| p_cost_mthd_code IN VARCHAR2(4) - Cost Method Code |
269: --| |

Line 286: CURSOR cur_cm_mthd_mst

282: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
283: )
284: RETURN BOOLEAN
285: IS
286: CURSOR cur_cm_mthd_mst
287: IS
288: SELECT
289: cost_mthd_code, lot_actual_cost
290: FROM

Line 291: cm_mthd_mst

287: IS
288: SELECT
289: cost_mthd_code, lot_actual_cost
290: FROM
291: cm_mthd_mst
292: WHERE
293: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
294: AND cm_mthd_mst.delete_mark = 0;
295:

Line 293: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

289: cost_mthd_code, lot_actual_cost
290: FROM
291: cm_mthd_mst
292: WHERE
293: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
294: AND cm_mthd_mst.delete_mark = 0;
295:
296: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
297: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;

Line 294: AND cm_mthd_mst.delete_mark = 0;

290: FROM
291: cm_mthd_mst
292: WHERE
293: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
294: AND cm_mthd_mst.delete_mark = 0;
295:
296: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
297: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;
298:

Line 297: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;

293: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
294: AND cm_mthd_mst.delete_mark = 0;
295:
296: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
297: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;
298:
299: BEGIN
300:
301: OPEN cur_cm_mthd_mst;

Line 301: OPEN cur_cm_mthd_mst;

297: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;
298:
299: BEGIN
300:
301: OPEN cur_cm_mthd_mst;
302: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code, l_lot_actual_cost;
303: IF (cur_cm_mthd_mst%NOTFOUND)
304: THEN
305: CLOSE cur_cm_mthd_mst;

Line 302: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code, l_lot_actual_cost;

298:
299: BEGIN
300:
301: OPEN cur_cm_mthd_mst;
302: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code, l_lot_actual_cost;
303: IF (cur_cm_mthd_mst%NOTFOUND)
304: THEN
305: CLOSE cur_cm_mthd_mst;
306: RETURN FALSE;

Line 303: IF (cur_cm_mthd_mst%NOTFOUND)

299: BEGIN
300:
301: OPEN cur_cm_mthd_mst;
302: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code, l_lot_actual_cost;
303: IF (cur_cm_mthd_mst%NOTFOUND)
304: THEN
305: CLOSE cur_cm_mthd_mst;
306: RETURN FALSE;
307: ELSE

Line 305: CLOSE cur_cm_mthd_mst;

301: OPEN cur_cm_mthd_mst;
302: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code, l_lot_actual_cost;
303: IF (cur_cm_mthd_mst%NOTFOUND)
304: THEN
305: CLOSE cur_cm_mthd_mst;
306: RETURN FALSE;
307: ELSE
308: CLOSE cur_cm_mthd_mst;
309: IF l_lot_actual_cost = 1 THEN

Line 308: CLOSE cur_cm_mthd_mst;

304: THEN
305: CLOSE cur_cm_mthd_mst;
306: RETURN FALSE;
307: ELSE
308: CLOSE cur_cm_mthd_mst;
309: IF l_lot_actual_cost = 1 THEN
310: FND_MESSAGE.SET_NAME('GMF','GMF_API_LOTCOST_MTHD_UNSUPP');
311: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE',p_cost_mthd_code);
312: FND_MSG_PUB.Add;

Line 335: --| on cm_mthd_mst and returns cost_type, rmcalc_type and prodcalc_type|

331: --| Validates cost_mthd_code |
332: --| |
333: --| DESCRIPTION |
334: --| This function validates that the cost Method Code exists |
335: --| on cm_mthd_mst and returns cost_type, rmcalc_type and prodcalc_type|
336: --| |
337: --| PARAMETERS |
338: --| p_cost_mthd_code IN VARCHAR2(4) - Cost Method Code |
339: --| x_cost_type OUT NUMBER - Cost Type |

Line 357: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,

353: -- Func end of comments
354:
355: PROCEDURE Validate_cost_mthd_code
356: (
357: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,
358: x_cost_type OUT NOCOPY cm_mthd_mst.cost_type%TYPE,
359: x_rmcalc_type OUT NOCOPY cm_mthd_mst.rmcalc_type%TYPE,
360: x_prodcalc_type OUT NOCOPY cm_mthd_mst.prodcalc_type%TYPE
361: )

Line 358: x_cost_type OUT NOCOPY cm_mthd_mst.cost_type%TYPE,

354:
355: PROCEDURE Validate_cost_mthd_code
356: (
357: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,
358: x_cost_type OUT NOCOPY cm_mthd_mst.cost_type%TYPE,
359: x_rmcalc_type OUT NOCOPY cm_mthd_mst.rmcalc_type%TYPE,
360: x_prodcalc_type OUT NOCOPY cm_mthd_mst.prodcalc_type%TYPE
361: )
362: IS

Line 359: x_rmcalc_type OUT NOCOPY cm_mthd_mst.rmcalc_type%TYPE,

355: PROCEDURE Validate_cost_mthd_code
356: (
357: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,
358: x_cost_type OUT NOCOPY cm_mthd_mst.cost_type%TYPE,
359: x_rmcalc_type OUT NOCOPY cm_mthd_mst.rmcalc_type%TYPE,
360: x_prodcalc_type OUT NOCOPY cm_mthd_mst.prodcalc_type%TYPE
361: )
362: IS
363: CURSOR cur_cm_mthd_mst

Line 360: x_prodcalc_type OUT NOCOPY cm_mthd_mst.prodcalc_type%TYPE

356: (
357: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,
358: x_cost_type OUT NOCOPY cm_mthd_mst.cost_type%TYPE,
359: x_rmcalc_type OUT NOCOPY cm_mthd_mst.rmcalc_type%TYPE,
360: x_prodcalc_type OUT NOCOPY cm_mthd_mst.prodcalc_type%TYPE
361: )
362: IS
363: CURSOR cur_cm_mthd_mst
364: IS

Line 363: CURSOR cur_cm_mthd_mst

359: x_rmcalc_type OUT NOCOPY cm_mthd_mst.rmcalc_type%TYPE,
360: x_prodcalc_type OUT NOCOPY cm_mthd_mst.prodcalc_type%TYPE
361: )
362: IS
363: CURSOR cur_cm_mthd_mst
364: IS
365: SELECT
366: cost_type, rmcalc_type, prodcalc_type, lot_actual_cost
367: FROM

Line 368: cm_mthd_mst

364: IS
365: SELECT
366: cost_type, rmcalc_type, prodcalc_type, lot_actual_cost
367: FROM
368: cm_mthd_mst
369: WHERE
370: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
371: AND cm_mthd_mst.delete_mark = 0;
372:

Line 370: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

366: cost_type, rmcalc_type, prodcalc_type, lot_actual_cost
367: FROM
368: cm_mthd_mst
369: WHERE
370: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
371: AND cm_mthd_mst.delete_mark = 0;
372:
373: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
374: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;

Line 371: AND cm_mthd_mst.delete_mark = 0;

367: FROM
368: cm_mthd_mst
369: WHERE
370: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
371: AND cm_mthd_mst.delete_mark = 0;
372:
373: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
374: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;
375:

Line 374: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;

370: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
371: AND cm_mthd_mst.delete_mark = 0;
372:
373: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
374: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;
375:
376: BEGIN
377:
378: OPEN cur_cm_mthd_mst;

Line 378: OPEN cur_cm_mthd_mst;

374: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;
375:
376: BEGIN
377:
378: OPEN cur_cm_mthd_mst;
379: FETCH cur_cm_mthd_mst INTO x_cost_type, x_rmcalc_type, x_prodcalc_type, l_lot_actual_cost ;
380: CLOSE cur_cm_mthd_mst;
381:
382: IF l_lot_actual_cost = 1 THEN

Line 379: FETCH cur_cm_mthd_mst INTO x_cost_type, x_rmcalc_type, x_prodcalc_type, l_lot_actual_cost ;

375:
376: BEGIN
377:
378: OPEN cur_cm_mthd_mst;
379: FETCH cur_cm_mthd_mst INTO x_cost_type, x_rmcalc_type, x_prodcalc_type, l_lot_actual_cost ;
380: CLOSE cur_cm_mthd_mst;
381:
382: IF l_lot_actual_cost = 1 THEN
383: FND_MESSAGE.SET_NAME('GMF','GMF_API_LOTCOST_MTHD_UNSUPP');

Line 380: CLOSE cur_cm_mthd_mst;

376: BEGIN
377:
378: OPEN cur_cm_mthd_mst;
379: FETCH cur_cm_mthd_mst INTO x_cost_type, x_rmcalc_type, x_prodcalc_type, l_lot_actual_cost ;
380: CLOSE cur_cm_mthd_mst;
381:
382: IF l_lot_actual_cost = 1 THEN
383: FND_MESSAGE.SET_NAME('GMF','GMF_API_LOTCOST_MTHD_UNSUPP');
384: FND_MESSAGE.SET_TOKEN('COST_MTHD_CODE',p_cost_mthd_code);

Line 391: IF (cur_cm_mthd_mst%NOTFOUND)

387: x_rmcalc_type := NULL;
388: x_prodcalc_type := NULL;
389: END IF;
390: /*
391: IF (cur_cm_mthd_mst%NOTFOUND)
392: THEN
393: CLOSE cur_cm_mthd_mst;
394: RETURN FALSE;
395: ELSE

Line 393: CLOSE cur_cm_mthd_mst;

389: END IF;
390: /*
391: IF (cur_cm_mthd_mst%NOTFOUND)
392: THEN
393: CLOSE cur_cm_mthd_mst;
394: RETURN FALSE;
395: ELSE
396: CLOSE cur_cm_mthd_mst;
397: RETURN TRUE;

Line 396: CLOSE cur_cm_mthd_mst;

392: THEN
393: CLOSE cur_cm_mthd_mst;
394: RETURN FALSE;
395: ELSE
396: CLOSE cur_cm_mthd_mst;
397: RETURN TRUE;
398: END IF;
399: */
400: EXCEPTION

Line 1814: --| on cm_mthd_mst |

1810: --| Validates lot cost_mthd_code |
1811: --| |
1812: --| DESCRIPTION |
1813: --| This function validates that the lot cost Method Code exists |
1814: --| on cm_mthd_mst |
1815: --| |
1816: --| PARAMETERS |
1817: --| p_cost_mthd_code IN VARCHAR2(4) - Lot Cost Method Code |
1818: --| |

Line 1836: CURSOR cur_cm_mthd_mst

1832: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
1833: )
1834: RETURN BOOLEAN
1835: IS
1836: CURSOR cur_cm_mthd_mst
1837: IS
1838: SELECT cost_mthd_code
1839: FROM cm_mthd_mst
1840: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

Line 1839: FROM cm_mthd_mst

1835: IS
1836: CURSOR cur_cm_mthd_mst
1837: IS
1838: SELECT cost_mthd_code
1839: FROM cm_mthd_mst
1840: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
1841: AND cm_mthd_mst.delete_mark = 0
1842: AND lot_actual_cost = 1;
1843:

Line 1840: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

1836: CURSOR cur_cm_mthd_mst
1837: IS
1838: SELECT cost_mthd_code
1839: FROM cm_mthd_mst
1840: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
1841: AND cm_mthd_mst.delete_mark = 0
1842: AND lot_actual_cost = 1;
1843:
1844: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

Line 1841: AND cm_mthd_mst.delete_mark = 0

1837: IS
1838: SELECT cost_mthd_code
1839: FROM cm_mthd_mst
1840: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
1841: AND cm_mthd_mst.delete_mark = 0
1842: AND lot_actual_cost = 1;
1843:
1844: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
1845:

Line 1848: OPEN cur_cm_mthd_mst;

1844: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
1845:
1846: BEGIN
1847:
1848: OPEN cur_cm_mthd_mst;
1849: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code;
1850: IF (cur_cm_mthd_mst%NOTFOUND)
1851: THEN
1852: CLOSE cur_cm_mthd_mst;

Line 1849: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code;

1845:
1846: BEGIN
1847:
1848: OPEN cur_cm_mthd_mst;
1849: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code;
1850: IF (cur_cm_mthd_mst%NOTFOUND)
1851: THEN
1852: CLOSE cur_cm_mthd_mst;
1853: RETURN FALSE;

Line 1850: IF (cur_cm_mthd_mst%NOTFOUND)

1846: BEGIN
1847:
1848: OPEN cur_cm_mthd_mst;
1849: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code;
1850: IF (cur_cm_mthd_mst%NOTFOUND)
1851: THEN
1852: CLOSE cur_cm_mthd_mst;
1853: RETURN FALSE;
1854: ELSE

Line 1852: CLOSE cur_cm_mthd_mst;

1848: OPEN cur_cm_mthd_mst;
1849: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code;
1850: IF (cur_cm_mthd_mst%NOTFOUND)
1851: THEN
1852: CLOSE cur_cm_mthd_mst;
1853: RETURN FALSE;
1854: ELSE
1855: CLOSE cur_cm_mthd_mst;
1856: RETURN TRUE;

Line 1855: CLOSE cur_cm_mthd_mst;

1851: THEN
1852: CLOSE cur_cm_mthd_mst;
1853: RETURN FALSE;
1854: ELSE
1855: CLOSE cur_cm_mthd_mst;
1856: RETURN TRUE;
1857: END IF;
1858: EXCEPTION
1859: WHEN OTHERS THEN

Line 2100: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *

2096: * DESCRIPTION *
2097: * This function validates that the Cost Type Id exists *
2098: * *
2099: * PARAMETERS *
2100: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *
2101: * *
2102: * RETURNS *
2103: * TRUE - If cost Type Exists *
2104: * FALSE - If Cost Type Doesnt Exist *

Line 2111: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE

2107: * 20-Oct-2005 Anand Thiyagarajan - Created *
2108: ***************************************************************************************/
2109: FUNCTION Validate_Cost_type_id
2110: (
2111: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE
2112: )
2113: RETURN BOOLEAN
2114: IS
2115:

Line 2123: FROM cm_mthd_mst

2119:
2120: CURSOR Cur_cost_type
2121: IS
2122: SELECT cost_type_id
2123: FROM cm_mthd_mst
2124: WHERE cost_type_id = p_cost_type_id;
2125:
2126: /******************
2127: * Local Variables *

Line 2130: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;

2126: /******************
2127: * Local Variables *
2128: ******************/
2129:
2130: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;
2131:
2132: BEGIN
2133: OPEN Cur_cost_type;
2134: FETCH Cur_cost_type INTO l_cost_type_id;

Line 2159: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *

2155: * DESCRIPTION *
2156: * This function validates that the Cost Type Id exists *
2157: * *
2158: * PARAMETERS *
2159: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *
2160: * p_Type IN VARCHAR2 *
2161: * *
2162: * RETURNS *
2163: * TRUE - If cost Type Exists *

Line 2171: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,

2167: * 20-Oct-2005 Anand Thiyagarajan - Created *
2168: ***************************************************************************************/
2169: FUNCTION Validate_Cost_type_id
2170: (
2171: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,
2172: p_Type IN VARCHAR2
2173: )
2174: RETURN BOOLEAN
2175: IS

Line 2184: FROM cm_mthd_mst

2180:
2181: CURSOR Cur_cost_type
2182: IS
2183: SELECT cost_type_id
2184: FROM cm_mthd_mst
2185: WHERE cost_type_id = p_cost_type_id
2186: AND (cost_type = decode(p_type, 'A', 1, 'S', 0, 'L', 6,'AS', 0) or cost_type = decode(p_type, 'A', 1, 'S', 0, 'L', 6, 'AS', 1));
2187:
2188: /******************

Line 2192: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;

2188: /******************
2189: * Local Variables *
2190: ******************/
2191:
2192: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;
2193:
2194: BEGIN
2195: OPEN Cur_cost_type;
2196: FETCH Cur_cost_type INTO l_cost_type_id;

Line 2221: * p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE *

2217: * DESCRIPTION *
2218: * This function validates that the Cost Method Code exists *
2219: * *
2220: * PARAMETERS *
2221: * p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE *
2222: * *
2223: * RETURNS *
2224: * Cost Type Id *
2225: * *

Line 2232: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE

2228: ***************************************************************************************/
2229:
2230: FUNCTION Validate_cost_type_code
2231: (
2232: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE
2233: )
2234: RETURN NUMBER
2235: IS
2236: /**********

Line 2243: FROM cm_mthd_mst

2239:
2240: CURSOR Cur_cost_type
2241: IS
2242: SELECT cost_type_id
2243: FROM cm_mthd_mst
2244: WHERE cost_mthd_code = p_cost_mthd_code;
2245:
2246: /******************
2247: * Local Variables *

Line 2250: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;

2246: /******************
2247: * Local Variables *
2248: ******************/
2249:
2250: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;
2251:
2252: BEGIN
2253: OPEN Cur_cost_type;
2254: FETCH Cur_cost_type INTO l_cost_type_id;

Line 2279: * p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE *

2275: * DESCRIPTION *
2276: * This function validates that the Cost Method Code exists *
2277: * *
2278: * PARAMETERS *
2279: * p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE *
2280: * p_Type IN VARCHAR2 *
2281: * *
2282: * RETURNS *
2283: * Cost Type Id *

Line 2290: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,

2286: * 20-Oct-2005 Anand Thiyagarajan - Created *
2287: ***************************************************************************************/
2288: FUNCTION Validate_cost_type_code
2289: (
2290: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,
2291: p_Type IN VARCHAR2
2292: )
2293: RETURN NUMBER
2294: IS

Line 2302: FROM cm_mthd_mst

2298:
2299: CURSOR Cur_cost_type
2300: IS
2301: SELECT cost_type_id
2302: FROM cm_mthd_mst
2303: WHERE cost_mthd_code = p_cost_mthd_code
2304: AND (cost_type = decode(p_type, 'A', 1, 'S', 0, 'L', 6,'AS', 0) or cost_type = decode(p_type, 'A', 1, 'S', 0, 'L', 6, 'AS', 1));
2305:
2306: /******************

Line 2310: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;

2306: /******************
2307: * Local Variables *
2308: ******************/
2309:
2310: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;
2311:
2312: BEGIN
2313: OPEN Cur_cost_type;
2314: FETCH Cur_cost_type INTO l_cost_type_id;

Line 2461: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *

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 *
2464: * Period Id *
2465: * *

Line 2474: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE

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
2477: IS
2478:

Line 2833: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *

2829: * DESCRIPTION *
2830: * This function validates that the Lot Cost Type Id exists *
2831: * *
2832: * PARAMETERS *
2833: * p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE *
2834: * *
2835: * RETURNS *
2836: * TRUE - If Lot Cost Type Exists *
2837: * FALSE - If Lot Cost Type Doesnt Exist *

Line 2844: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE

2840: * 20-Oct-2005 Anand Thiyagarajan - Created *
2841: ***************************************************************************************/
2842: FUNCTION Validate_Lot_Cost_type_id
2843: (
2844: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE
2845: )
2846: RETURN BOOLEAN
2847: IS
2848:

Line 2852: CURSOR cur_cm_mthd_mst

2848:
2849: /**********
2850: * Cursors *
2851: **********/
2852: CURSOR cur_cm_mthd_mst
2853: IS
2854: SELECT cost_type_id
2855: FROM cm_mthd_mst
2856: WHERE cm_mthd_mst.cost_type_id = p_cost_type_id

Line 2855: FROM cm_mthd_mst

2851: **********/
2852: CURSOR cur_cm_mthd_mst
2853: IS
2854: SELECT cost_type_id
2855: FROM cm_mthd_mst
2856: WHERE cm_mthd_mst.cost_type_id = p_cost_type_id
2857: AND cm_mthd_mst.delete_mark = 0
2858: AND cost_type = 6;
2859:

Line 2856: WHERE cm_mthd_mst.cost_type_id = p_cost_type_id

2852: CURSOR cur_cm_mthd_mst
2853: IS
2854: SELECT cost_type_id
2855: FROM cm_mthd_mst
2856: WHERE cm_mthd_mst.cost_type_id = p_cost_type_id
2857: AND cm_mthd_mst.delete_mark = 0
2858: AND cost_type = 6;
2859:
2860: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;

Line 2857: AND cm_mthd_mst.delete_mark = 0

2853: IS
2854: SELECT cost_type_id
2855: FROM cm_mthd_mst
2856: WHERE cm_mthd_mst.cost_type_id = p_cost_type_id
2857: AND cm_mthd_mst.delete_mark = 0
2858: AND cost_type = 6;
2859:
2860: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
2861:

Line 2860: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;

2856: WHERE cm_mthd_mst.cost_type_id = p_cost_type_id
2857: AND cm_mthd_mst.delete_mark = 0
2858: AND cost_type = 6;
2859:
2860: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
2861:
2862: BEGIN
2863: OPEN cur_cm_mthd_mst;
2864: FETCH cur_cm_mthd_mst INTO l_cost_type_id;

Line 2863: OPEN cur_cm_mthd_mst;

2859:
2860: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
2861:
2862: BEGIN
2863: OPEN cur_cm_mthd_mst;
2864: FETCH cur_cm_mthd_mst INTO l_cost_type_id;
2865: IF cur_cm_mthd_mst%NOTFOUND
2866: THEN
2867: CLOSE cur_cm_mthd_mst;

Line 2864: FETCH cur_cm_mthd_mst INTO l_cost_type_id;

2860: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
2861:
2862: BEGIN
2863: OPEN cur_cm_mthd_mst;
2864: FETCH cur_cm_mthd_mst INTO l_cost_type_id;
2865: IF cur_cm_mthd_mst%NOTFOUND
2866: THEN
2867: CLOSE cur_cm_mthd_mst;
2868: RETURN FALSE;

Line 2865: IF cur_cm_mthd_mst%NOTFOUND

2861:
2862: BEGIN
2863: OPEN cur_cm_mthd_mst;
2864: FETCH cur_cm_mthd_mst INTO l_cost_type_id;
2865: IF cur_cm_mthd_mst%NOTFOUND
2866: THEN
2867: CLOSE cur_cm_mthd_mst;
2868: RETURN FALSE;
2869: ELSE

Line 2867: CLOSE cur_cm_mthd_mst;

2863: OPEN cur_cm_mthd_mst;
2864: FETCH cur_cm_mthd_mst INTO l_cost_type_id;
2865: IF cur_cm_mthd_mst%NOTFOUND
2866: THEN
2867: CLOSE cur_cm_mthd_mst;
2868: RETURN FALSE;
2869: ELSE
2870: CLOSE cur_cm_mthd_mst;
2871: RETURN TRUE;

Line 2870: CLOSE cur_cm_mthd_mst;

2866: THEN
2867: CLOSE cur_cm_mthd_mst;
2868: RETURN FALSE;
2869: ELSE
2870: CLOSE cur_cm_mthd_mst;
2871: RETURN TRUE;
2872: END IF;
2873: EXCEPTION
2874: WHEN OTHERS THEN

Line 2889: * p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE *

2885: * DESCRIPTION *
2886: * This function validates that the Lot Cost Method Code exists *
2887: * *
2888: * PARAMETERS *
2889: * p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE *
2890: * *
2891: * RETURNS *
2892: * Lot Cost Type Id *
2893: * *

Line 2899: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE

2895: * 20-Oct-2005 Anand Thiyagarajan - Created *
2896: ***************************************************************************************/
2897: FUNCTION Validate_Lot_Cost_Type
2898: (
2899: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE
2900: )
2901: RETURN NUMBER
2902: IS
2903:

Line 2907: CURSOR cur_cm_mthd_mst

2903:
2904: /**********
2905: * Cursors *
2906: **********/
2907: CURSOR cur_cm_mthd_mst
2908: IS
2909: SELECT cost_type_id
2910: FROM cm_mthd_mst
2911: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

Line 2910: FROM cm_mthd_mst

2906: **********/
2907: CURSOR cur_cm_mthd_mst
2908: IS
2909: SELECT cost_type_id
2910: FROM cm_mthd_mst
2911: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
2912: AND cm_mthd_mst.delete_mark = 0
2913: AND cost_type = 6;
2914:

Line 2911: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

2907: CURSOR cur_cm_mthd_mst
2908: IS
2909: SELECT cost_type_id
2910: FROM cm_mthd_mst
2911: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
2912: AND cm_mthd_mst.delete_mark = 0
2913: AND cost_type = 6;
2914:
2915: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;

Line 2912: AND cm_mthd_mst.delete_mark = 0

2908: IS
2909: SELECT cost_type_id
2910: FROM cm_mthd_mst
2911: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
2912: AND cm_mthd_mst.delete_mark = 0
2913: AND cost_type = 6;
2914:
2915: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
2916:

Line 2915: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;

2911: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code
2912: AND cm_mthd_mst.delete_mark = 0
2913: AND cost_type = 6;
2914:
2915: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
2916:
2917: BEGIN
2918: OPEN cur_cm_mthd_mst;
2919: FETCH cur_cm_mthd_mst INTO l_cost_type_id;

Line 2918: OPEN cur_cm_mthd_mst;

2914:
2915: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
2916:
2917: BEGIN
2918: OPEN cur_cm_mthd_mst;
2919: FETCH cur_cm_mthd_mst INTO l_cost_type_id;
2920: IF cur_cm_mthd_mst%NOTFOUND
2921: THEN
2922: CLOSE cur_cm_mthd_mst;

Line 2919: FETCH cur_cm_mthd_mst INTO l_cost_type_id;

2915: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;
2916:
2917: BEGIN
2918: OPEN cur_cm_mthd_mst;
2919: FETCH cur_cm_mthd_mst INTO l_cost_type_id;
2920: IF cur_cm_mthd_mst%NOTFOUND
2921: THEN
2922: CLOSE cur_cm_mthd_mst;
2923: RETURN NULL;

Line 2920: IF cur_cm_mthd_mst%NOTFOUND

2916:
2917: BEGIN
2918: OPEN cur_cm_mthd_mst;
2919: FETCH cur_cm_mthd_mst INTO l_cost_type_id;
2920: IF cur_cm_mthd_mst%NOTFOUND
2921: THEN
2922: CLOSE cur_cm_mthd_mst;
2923: RETURN NULL;
2924: ELSE

Line 2922: CLOSE cur_cm_mthd_mst;

2918: OPEN cur_cm_mthd_mst;
2919: FETCH cur_cm_mthd_mst INTO l_cost_type_id;
2920: IF cur_cm_mthd_mst%NOTFOUND
2921: THEN
2922: CLOSE cur_cm_mthd_mst;
2923: RETURN NULL;
2924: ELSE
2925: CLOSE cur_cm_mthd_mst;
2926: RETURN l_cost_type_id;

Line 2925: CLOSE cur_cm_mthd_mst;

2921: THEN
2922: CLOSE cur_cm_mthd_mst;
2923: RETURN NULL;
2924: ELSE
2925: CLOSE cur_cm_mthd_mst;
2926: RETURN l_cost_type_id;
2927: END IF;
2928: EXCEPTION
2929: WHEN OTHERS THEN