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 263: --| on cm_mthd_mst |

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

Line 284: CURSOR cur_cm_mthd_mst

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

Line 289: cm_mthd_mst

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

Line 291: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

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

Line 292: AND cm_mthd_mst.delete_mark = 0;

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

Line 295: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;

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

Line 299: OPEN cur_cm_mthd_mst;

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

Line 300: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code, l_lot_actual_cost;

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

Line 301: IF (cur_cm_mthd_mst%NOTFOUND)

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

Line 303: CLOSE cur_cm_mthd_mst;

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

Line 306: CLOSE cur_cm_mthd_mst;

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

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

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

Line 355: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,

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

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

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

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

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

Line 358: x_prodcalc_type OUT NOCOPY cm_mthd_mst.prodcalc_type%TYPE

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

Line 361: CURSOR cur_cm_mthd_mst

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

Line 366: cm_mthd_mst

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

Line 368: cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

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

Line 369: AND cm_mthd_mst.delete_mark = 0;

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

Line 372: l_lot_actual_cost cm_mthd_mst.lot_actual_cost%TYPE;

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

Line 376: OPEN cur_cm_mthd_mst;

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

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

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

Line 378: CLOSE cur_cm_mthd_mst;

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

Line 389: IF (cur_cm_mthd_mst%NOTFOUND)

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

Line 391: CLOSE cur_cm_mthd_mst;

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

Line 394: CLOSE cur_cm_mthd_mst;

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

Line 1812: --| on cm_mthd_mst |

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

Line 1834: CURSOR cur_cm_mthd_mst

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

Line 1837: FROM cm_mthd_mst

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

Line 1838: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

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

Line 1839: AND cm_mthd_mst.delete_mark = 0

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

Line 1846: OPEN cur_cm_mthd_mst;

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

Line 1847: FETCH cur_cm_mthd_mst INTO l_cost_mthd_code;

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

Line 1848: IF (cur_cm_mthd_mst%NOTFOUND)

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

Line 1850: CLOSE cur_cm_mthd_mst;

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

Line 1853: CLOSE cur_cm_mthd_mst;

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

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

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

Line 2109: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE

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

Line 2121: FROM cm_mthd_mst

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

Line 2128: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;

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

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

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

Line 2169: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE,

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

Line 2182: FROM cm_mthd_mst

2178:
2179: CURSOR Cur_cost_type
2180: IS
2181: SELECT cost_type_id
2182: FROM cm_mthd_mst
2183: WHERE cost_type_id = p_cost_type_id
2184: 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));
2185:
2186: /******************

Line 2190: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;

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

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

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

Line 2230: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE

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

Line 2241: FROM cm_mthd_mst

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

Line 2248: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;

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

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

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

Line 2288: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE,

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

Line 2300: FROM cm_mthd_mst

2296:
2297: CURSOR Cur_cost_type
2298: IS
2299: SELECT cost_type_id
2300: FROM cm_mthd_mst
2301: WHERE cost_mthd_code = p_cost_mthd_code
2302: 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));
2303:
2304: /******************

Line 2308: l_cost_type_id cm_mthd_mst.cost_Type_id%TYPE;

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

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

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 *
2462: * Period Id *
2463: * *

Line 2472: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE

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
2475: IS
2476:

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

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

Line 2842: p_cost_type_id IN cm_mthd_mst.cost_type_id%TYPE

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

Line 2850: CURSOR cur_cm_mthd_mst

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

Line 2853: FROM cm_mthd_mst

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

Line 2854: WHERE cm_mthd_mst.cost_type_id = p_cost_type_id

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

Line 2855: AND cm_mthd_mst.delete_mark = 0

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

Line 2858: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;

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

Line 2861: OPEN cur_cm_mthd_mst;

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

Line 2862: FETCH cur_cm_mthd_mst INTO l_cost_type_id;

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

Line 2863: IF cur_cm_mthd_mst%NOTFOUND

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

Line 2865: CLOSE cur_cm_mthd_mst;

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

Line 2868: CLOSE cur_cm_mthd_mst;

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

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

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

Line 2897: p_cost_mthd_code IN cm_mthd_mst.cost_mthd_code%TYPE

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

Line 2905: CURSOR cur_cm_mthd_mst

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

Line 2908: FROM cm_mthd_mst

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

Line 2909: WHERE cm_mthd_mst.cost_mthd_code = p_cost_mthd_code

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

Line 2910: AND cm_mthd_mst.delete_mark = 0

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

Line 2913: l_cost_type_id cm_mthd_mst.cost_type_id%TYPE;

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

Line 2916: OPEN cur_cm_mthd_mst;

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

Line 2917: FETCH cur_cm_mthd_mst INTO l_cost_type_id;

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

Line 2918: IF cur_cm_mthd_mst%NOTFOUND

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

Line 2920: CLOSE cur_cm_mthd_mst;

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

Line 2923: CLOSE cur_cm_mthd_mst;

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