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.GMI_VALID_GRP dependencies on IC_ITEM_MST

Line 85: --| Validate whther item exists on ic_item_mst |

81: --| FUNCTION NAME |
82: --| Validate_item_existance |
83: --| |
84: --| USAGE |
85: --| Validate whther item exists on ic_item_mst |
86: --| |
87: --| DESCRIPTION |
88: --| This function validates that the parameter passed exists |
89: --| on ic_item_mst |

Line 89: --| on ic_item_mst |

85: --| Validate whther item exists on ic_item_mst |
86: --| |
87: --| DESCRIPTION |
88: --| This function validates that the parameter passed exists |
89: --| on ic_item_mst |
90: --| |
91: --| PARAMETERS |
92: --| p_item_no IN Item Number |
93: --| |

Line 95: --| Item_id - if the item exists on ic_item_mst |

91: --| PARAMETERS |
92: --| p_item_no IN Item Number |
93: --| |
94: --| RETURNS |
95: --| Item_id - if the item exists on ic_item_mst |
96: --| 0 - if the item does not exist on ic_item_mst |
97: --| |
98: --| HISTORY |
99: --| 11/13/1998 Mike Godfrey - Created |

Line 96: --| 0 - if the item does not exist on ic_item_mst |

92: --| p_item_no IN Item Number |
93: --| |
94: --| RETURNS |
95: --| Item_id - if the item exists on ic_item_mst |
96: --| 0 - if the item does not exist on ic_item_mst |
97: --| |
98: --| HISTORY |
99: --| 11/13/1998 Mike Godfrey - Created |
100: --| |

Line 105: ( p_item_no IN ic_item_mst.item_no%TYPE

101: --+==========================================================================+
102: -- Func end of comments
103:
104: FUNCTION Validate_item_existance
105: ( p_item_no IN ic_item_mst.item_no%TYPE
106: )
107: RETURN NUMBER
108: IS
109: l_item_id ic_item_mst.item_id%TYPE;

Line 109: l_item_id ic_item_mst.item_id%TYPE;

105: ( p_item_no IN ic_item_mst.item_no%TYPE
106: )
107: RETURN NUMBER
108: IS
109: l_item_id ic_item_mst.item_id%TYPE;
110: CURSOR ic_item_mst_c1 IS
111: SELECT
112: item_id
113: FROM

Line 110: CURSOR ic_item_mst_c1 IS

106: )
107: RETURN NUMBER
108: IS
109: l_item_id ic_item_mst.item_id%TYPE;
110: CURSOR ic_item_mst_c1 IS
111: SELECT
112: item_id
113: FROM
114: ic_item_mst

Line 114: ic_item_mst

110: CURSOR ic_item_mst_c1 IS
111: SELECT
112: item_id
113: FROM
114: ic_item_mst
115: WHERE
116: item_no = p_item_no;
117:
118: BEGIN

Line 120: OPEN ic_item_mst_c1;

116: item_no = p_item_no;
117:
118: BEGIN
119:
120: OPEN ic_item_mst_c1;
121: FETCH ic_item_mst_c1 INTO l_item_id;
122: IF (ic_item_mst_c1%NOTFOUND)
123: THEN
124: CLOSE ic_item_mst_c1;

Line 121: FETCH ic_item_mst_c1 INTO l_item_id;

117:
118: BEGIN
119:
120: OPEN ic_item_mst_c1;
121: FETCH ic_item_mst_c1 INTO l_item_id;
122: IF (ic_item_mst_c1%NOTFOUND)
123: THEN
124: CLOSE ic_item_mst_c1;
125: RETURN 0;

Line 122: IF (ic_item_mst_c1%NOTFOUND)

118: BEGIN
119:
120: OPEN ic_item_mst_c1;
121: FETCH ic_item_mst_c1 INTO l_item_id;
122: IF (ic_item_mst_c1%NOTFOUND)
123: THEN
124: CLOSE ic_item_mst_c1;
125: RETURN 0;
126: ELSE

Line 124: CLOSE ic_item_mst_c1;

120: OPEN ic_item_mst_c1;
121: FETCH ic_item_mst_c1 INTO l_item_id;
122: IF (ic_item_mst_c1%NOTFOUND)
123: THEN
124: CLOSE ic_item_mst_c1;
125: RETURN 0;
126: ELSE
127: CLOSE ic_item_mst_c1;
128: RETURN l_item_id;

Line 127: CLOSE ic_item_mst_c1;

123: THEN
124: CLOSE ic_item_mst_c1;
125: RETURN 0;
126: ELSE
127: CLOSE ic_item_mst_c1;
128: RETURN l_item_id;
129: END IF;
130:
131: EXCEPTION

Line 163: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE

159: -- Func end of comments
160:
161:
162: FUNCTION Validate_dualum_ind
163: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
164: )
165: RETURN BOOLEAN
166: IS
167: BEGIN

Line 201: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE

197: --| |
198: --+==========================================================================+
199: -- Func end of comments
200: FUNCTION Validate_item_um2
201: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
202: , p_item_um2 IN ic_item_mst.item_um2%TYPE
203: )
204: RETURN BOOLEAN
205: IS

Line 202: , p_item_um2 IN ic_item_mst.item_um2%TYPE

198: --+==========================================================================+
199: -- Func end of comments
200: FUNCTION Validate_item_um2
201: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
202: , p_item_um2 IN ic_item_mst.item_um2%TYPE
203: )
204: RETURN BOOLEAN
205: IS
206: BEGIN

Line 252: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE

248: --| |
249: --+==========================================================================+
250: -- Func end of comments
251: FUNCTION Validate_deviation
252: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
253: , p_deviation IN ic_item_mst.deviation_hi%TYPE
254: )
255: RETURN BOOLEAN
256: IS

Line 253: , p_deviation IN ic_item_mst.deviation_hi%TYPE

249: --+==========================================================================+
250: -- Func end of comments
251: FUNCTION Validate_deviation
252: ( p_dualum_ind IN ic_item_mst.dualum_ind%TYPE
253: , p_deviation IN ic_item_mst.deviation_hi%TYPE
254: )
255: RETURN BOOLEAN
256: IS
257: BEGIN

Line 296: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

292: --| |
293: --+==========================================================================+
294: -- Func end of comments
295: FUNCTION Validate_lot_ctl
296: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
297: )
298: RETURN BOOLEAN
299: IS
300: BEGIN

Line 335: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

331: --| |
332: --+==========================================================================+
333: -- Func end of comments
334: FUNCTION Validate_lot_indivisible
335: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
336: , p_lot_indivisible IN ic_item_mst.lot_indivisible%TYPE
337: )
338: RETURN BOOLEAN
339: IS

Line 336: , p_lot_indivisible IN ic_item_mst.lot_indivisible%TYPE

332: --+==========================================================================+
333: -- Func end of comments
334: FUNCTION Validate_lot_indivisible
335: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
336: , p_lot_indivisible IN ic_item_mst.lot_indivisible%TYPE
337: )
338: RETURN BOOLEAN
339: IS
340: BEGIN

Line 380: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

376: --| |
377: --+==========================================================================+
378: -- Func end of comments
379: FUNCTION Validate_sublot_ctl
380: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
381: , p_sublot_ctl IN ic_item_mst.sublot_ctl%TYPE
382: )
383: RETURN BOOLEAN
384: IS

Line 381: , p_sublot_ctl IN ic_item_mst.sublot_ctl%TYPE

377: --+==========================================================================+
378: -- Func end of comments
379: FUNCTION Validate_sublot_ctl
380: ( p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
381: , p_sublot_ctl IN ic_item_mst.sublot_ctl%TYPE
382: )
383: RETURN BOOLEAN
384: IS
385: BEGIN

Line 423: (p_loct_ctl IN ic_item_mst.loct_ctl%TYPE

419: --| |
420: --+==========================================================================+
421: -- Func end of comments
422: FUNCTION Validate_loct_ctl
423: (p_loct_ctl IN ic_item_mst.loct_ctl%TYPE
424: )
425: RETURN BOOLEAN
426: IS
427: BEGIN

Line 462: ( p_noninv_ind IN ic_item_mst.noninv_ind%TYPE

458: --| |
459: --+==========================================================================+
460: -- Func end of comments
461: FUNCTION Validate_noninv_ind
462: ( p_noninv_ind IN ic_item_mst.noninv_ind%TYPE
463: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
464: )
465: RETURN BOOLEAN
466: IS

Line 463: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

459: --+==========================================================================+
460: -- Func end of comments
461: FUNCTION Validate_noninv_ind
462: ( p_noninv_ind IN ic_item_mst.noninv_ind%TYPE
463: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
464: )
465: RETURN BOOLEAN
466: IS
467: BEGIN

Line 505: ( p_match_type IN ic_item_mst.match_type%TYPE

501: --| |
502: --+==========================================================================+
503: -- Func end of comments
504: FUNCTION Validate_match_type
505: ( p_match_type IN ic_item_mst.match_type%TYPE
506: )
507: RETURN BOOLEAN
508: IS
509: BEGIN

Line 542: ( p_inactive_ind IN ic_item_mst.inactive_ind%TYPE

538: --| |
539: --+==========================================================================+
540: -- Func end of comments
541: FUNCTION Validate_inactive_ind
542: ( p_inactive_ind IN ic_item_mst.inactive_ind%TYPE
543: )
544: RETURN BOOLEAN
545: IS
546: BEGIN

Line 580: ( p_inv_type IN ic_item_mst.inv_type%TYPE

576: --| |
577: --+==========================================================================+
578: -- Func end of comments
579: FUNCTION Validate_inv_type
580: ( p_inv_type IN ic_item_mst.inv_type%TYPE
581: )
582: RETURN BOOLEAN
583: IS
584: l_inv_type ic_item_mst.inv_type%TYPE;

Line 584: l_inv_type ic_item_mst.inv_type%TYPE;

580: ( p_inv_type IN ic_item_mst.inv_type%TYPE
581: )
582: RETURN BOOLEAN
583: IS
584: l_inv_type ic_item_mst.inv_type%TYPE;
585: CURSOR ic_invn_typ_c1 IS
586: SELECT
587: inv_type
588: FROM

Line 639: ( p_shelf_life IN ic_item_mst.shelf_life%TYPE

635: --| |
636: --+==========================================================================+
637: -- Func end of comments
638: FUNCTION Validate_shelf_life
639: ( p_shelf_life IN ic_item_mst.shelf_life%TYPE
640: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
641: )
642: RETURN BOOLEAN
643: IS

Line 640: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

636: --+==========================================================================+
637: -- Func end of comments
638: FUNCTION Validate_shelf_life
639: ( p_shelf_life IN ic_item_mst.shelf_life%TYPE
640: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
641: )
642: RETURN BOOLEAN
643: IS
644: BEGIN

Line 684: ( p_retest_interval IN ic_item_mst.retest_interval%TYPE

680: --| |
681: --+==========================================================================+
682: -- Func end of comments
683: FUNCTION Validate_retest_interval
684: ( p_retest_interval IN ic_item_mst.retest_interval%TYPE
685: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
686: )
687: RETURN BOOLEAN
688: IS

Line 685: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

681: --+==========================================================================+
682: -- Func end of comments
683: FUNCTION Validate_retest_interval
684: ( p_retest_interval IN ic_item_mst.retest_interval%TYPE
685: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
686: )
687: RETURN BOOLEAN
688: IS
689: BEGIN

Line 728: ( p_item_abccode IN ic_item_mst.item_abccode%TYPE

724: --| |
725: --+==========================================================================+
726: -- Func end of comments
727: FUNCTION Validate_item_abccode
728: ( p_item_abccode IN ic_item_mst.item_abccode%TYPE
729: )
730: RETURN BOOLEAN
731: IS
732: l_item_abccode ic_item_mst.item_abccode%TYPE;

Line 732: l_item_abccode ic_item_mst.item_abccode%TYPE;

728: ( p_item_abccode IN ic_item_mst.item_abccode%TYPE
729: )
730: RETURN BOOLEAN
731: IS
732: l_item_abccode ic_item_mst.item_abccode%TYPE;
733: CURSOR ic_rank_mst_c1 IS
734: SELECT
735: abc_code
736: FROM

Line 791: ( p_gl_class IN ic_item_mst.gl_class%TYPE

787: --| |
788: --+==========================================================================+
789: -- Func end of comments
790: FUNCTION Validate_gl_class
791: ( p_gl_class IN ic_item_mst.gl_class%TYPE
792: )
793: RETURN BOOLEAN
794: IS
795: l_gl_class ic_item_mst.gl_class%TYPE;

Line 795: l_gl_class ic_item_mst.gl_class%TYPE;

791: ( p_gl_class IN ic_item_mst.gl_class%TYPE
792: )
793: RETURN BOOLEAN
794: IS
795: l_gl_class ic_item_mst.gl_class%TYPE;
796: CURSOR ic_gled_cls_c1 IS
797: SELECT
798: icgl_class
799: FROM

Line 849: ( p_inv_class IN ic_item_mst.inv_class%TYPE

845: --| |
846: --+==========================================================================+
847: -- Func end of comments
848: FUNCTION Validate_inv_class
849: ( p_inv_class IN ic_item_mst.inv_class%TYPE
850: )
851: RETURN BOOLEAN
852: IS
853: l_inv_class ic_item_mst.inv_class%TYPE;

Line 853: l_inv_class ic_item_mst.inv_class%TYPE;

849: ( p_inv_class IN ic_item_mst.inv_class%TYPE
850: )
851: RETURN BOOLEAN
852: IS
853: l_inv_class ic_item_mst.inv_class%TYPE;
854: CURSOR ic_invn_cls_c1 IS
855: SELECT
856: icinv_class
857: FROM

Line 907: ( p_sales_class IN ic_item_mst.sales_class%TYPE

903: --| |
904: --+==========================================================================+
905: -- Func end of comments
906: FUNCTION Validate_sales_class
907: ( p_sales_class IN ic_item_mst.sales_class%TYPE
908: )
909: RETURN BOOLEAN
910: IS
911: l_sales_class ic_item_mst.sales_class%TYPE;

Line 911: l_sales_class ic_item_mst.sales_class%TYPE;

907: ( p_sales_class IN ic_item_mst.sales_class%TYPE
908: )
909: RETURN BOOLEAN
910: IS
911: l_sales_class ic_item_mst.sales_class%TYPE;
912: CURSOR ic_sale_cls_c1 IS
913: SELECT
914: icsales_class
915: FROM

Line 965: ( p_ship_class IN ic_item_mst.ship_class%TYPE

961: --| |
962: --+==========================================================================+
963: -- Func end of comments
964: FUNCTION Validate_ship_class
965: ( p_ship_class IN ic_item_mst.ship_class%TYPE
966: )
967: RETURN BOOLEAN
968: IS
969: l_ship_class ic_item_mst.ship_class%TYPE;

Line 969: l_ship_class ic_item_mst.ship_class%TYPE;

965: ( p_ship_class IN ic_item_mst.ship_class%TYPE
966: )
967: RETURN BOOLEAN
968: IS
969: l_ship_class ic_item_mst.ship_class%TYPE;
970: CURSOR ic_ship_cls_c1 IS
971: SELECT
972: icship_class
973: FROM

Line 1023: ( p_frt_class IN ic_item_mst.frt_class%TYPE

1019: --| |
1020: --+==========================================================================+
1021: -- Func end of comments
1022: FUNCTION Validate_frt_class
1023: ( p_frt_class IN ic_item_mst.frt_class%TYPE
1024: )
1025: RETURN BOOLEAN
1026: IS
1027: l_frt_class ic_item_mst.frt_class%TYPE;

Line 1027: l_frt_class ic_item_mst.frt_class%TYPE;

1023: ( p_frt_class IN ic_item_mst.frt_class%TYPE
1024: )
1025: RETURN BOOLEAN
1026: IS
1027: l_frt_class ic_item_mst.frt_class%TYPE;
1028: CURSOR ic_frgt_cls_c1 IS
1029: SELECT
1030: icfrt_class
1031: FROM

Line 1081: ( p_price_class IN ic_item_mst.price_class%TYPE

1077: --| |
1078: --+==========================================================================+
1079: -- Func end of comments
1080: FUNCTION Validate_price_class
1081: ( p_price_class IN ic_item_mst.price_class%TYPE
1082: )
1083: RETURN BOOLEAN
1084: IS
1085: l_price_class ic_item_mst.price_class%TYPE;

Line 1085: l_price_class ic_item_mst.price_class%TYPE;

1081: ( p_price_class IN ic_item_mst.price_class%TYPE
1082: )
1083: RETURN BOOLEAN
1084: IS
1085: l_price_class ic_item_mst.price_class%TYPE;
1086: CURSOR ic_prce_cls_c1 IS
1087: SELECT
1088: icprice_class
1089: FROM

Line 1139: ( p_storage_class IN ic_item_mst.storage_class%TYPE

1135: --| |
1136: --+==========================================================================+
1137: -- Func end of comments
1138: FUNCTION Validate_storage_class
1139: ( p_storage_class IN ic_item_mst.storage_class%TYPE
1140: )
1141: RETURN BOOLEAN
1142: IS
1143: l_storage_class ic_item_mst.storage_class%TYPE;

Line 1143: l_storage_class ic_item_mst.storage_class%TYPE;

1139: ( p_storage_class IN ic_item_mst.storage_class%TYPE
1140: )
1141: RETURN BOOLEAN
1142: IS
1143: l_storage_class ic_item_mst.storage_class%TYPE;
1144: CURSOR ic_stor_cls_c1 IS
1145: SELECT
1146: icstorage_class
1147: FROM

Line 1197: ( p_purch_class IN ic_item_mst.purch_class%TYPE

1193: --| |
1194: --+==========================================================================+
1195: -- Func end of comments
1196: FUNCTION Validate_purch_class
1197: ( p_purch_class IN ic_item_mst.purch_class%TYPE
1198: )
1199: RETURN BOOLEAN
1200: IS
1201: l_purch_class ic_item_mst.purch_class%TYPE;

Line 1201: l_purch_class ic_item_mst.purch_class%TYPE;

1197: ( p_purch_class IN ic_item_mst.purch_class%TYPE
1198: )
1199: RETURN BOOLEAN
1200: IS
1201: l_purch_class ic_item_mst.purch_class%TYPE;
1202: CURSOR ic_prch_cls_c1 IS
1203: SELECT
1204: icpurch_class
1205: FROM

Line 1255: ( p_tax_class IN ic_item_mst.tax_class%TYPE

1251: --| |
1252: --+==========================================================================+
1253: -- Func end of comments
1254: FUNCTION Validate_tax_class
1255: ( p_tax_class IN ic_item_mst.tax_class%TYPE
1256: )
1257: RETURN BOOLEAN
1258: IS
1259: l_tax_class ic_item_mst.tax_class%TYPE;

Line 1259: l_tax_class ic_item_mst.tax_class%TYPE;

1255: ( p_tax_class IN ic_item_mst.tax_class%TYPE
1256: )
1257: RETURN BOOLEAN
1258: IS
1259: l_tax_class ic_item_mst.tax_class%TYPE;
1260: CURSOR ic_taxn_cls_c1 IS
1261: SELECT
1262: ictax_class
1263: FROM

Line 1313: ( p_customs_class IN ic_item_mst.customs_class%TYPE

1309: --| |
1310: --+==========================================================================+
1311: -- Func end of comments
1312: FUNCTION Validate_customs_class
1313: ( p_customs_class IN ic_item_mst.customs_class%TYPE
1314: )
1315: RETURN BOOLEAN
1316: IS
1317: l_customs_class ic_item_mst.customs_class%TYPE;

Line 1317: l_customs_class ic_item_mst.customs_class%TYPE;

1313: ( p_customs_class IN ic_item_mst.customs_class%TYPE
1314: )
1315: RETURN BOOLEAN
1316: IS
1317: l_customs_class ic_item_mst.customs_class%TYPE;
1318: CURSOR ic_ctms_cls_c1 IS
1319: SELECT
1320: iccustoms_class
1321: FROM

Line 1371: ( p_alloc_class IN ic_item_mst.alloc_class%TYPE

1367: --| |
1368: --+==========================================================================+
1369: -- Func end of comments
1370: FUNCTION Validate_alloc_class
1371: ( p_alloc_class IN ic_item_mst.alloc_class%TYPE
1372: )
1373: RETURN BOOLEAN
1374: IS
1375: l_alloc_class ic_item_mst.alloc_class%TYPE;

Line 1375: l_alloc_class ic_item_mst.alloc_class%TYPE;

1371: ( p_alloc_class IN ic_item_mst.alloc_class%TYPE
1372: )
1373: RETURN BOOLEAN
1374: IS
1375: l_alloc_class ic_item_mst.alloc_class%TYPE;
1376: CURSOR ic_allc_cls_c1 IS
1377: SELECT
1378: alloc_class
1379: FROM

Line 1429: ( p_planning_class IN ic_item_mst.planning_class%TYPE

1425: --| |
1426: --+==========================================================================+
1427: -- Func end of comments
1428: FUNCTION Validate_planning_class
1429: ( p_planning_class IN ic_item_mst.planning_class%TYPE
1430: )
1431: RETURN BOOLEAN
1432: IS
1433: l_planning_class ic_item_mst.planning_class%TYPE;

Line 1433: l_planning_class ic_item_mst.planning_class%TYPE;

1429: ( p_planning_class IN ic_item_mst.planning_class%TYPE
1430: )
1431: RETURN BOOLEAN
1432: IS
1433: l_planning_class ic_item_mst.planning_class%TYPE;
1434: CURSOR ps_plng_cls_c1 IS
1435: SELECT
1436: planning_class
1437: FROM

Line 1487: ( p_itemcost_class IN ic_item_mst.itemcost_class%TYPE

1483: --| |
1484: --+==========================================================================+
1485: -- Func end of comments
1486: FUNCTION Validate_itemcost_class
1487: ( p_itemcost_class IN ic_item_mst.itemcost_class%TYPE
1488: )
1489: RETURN BOOLEAN
1490: IS
1491: l_itemcost_class ic_item_mst.itemcost_class%TYPE;

Line 1491: l_itemcost_class ic_item_mst.itemcost_class%TYPE;

1487: ( p_itemcost_class IN ic_item_mst.itemcost_class%TYPE
1488: )
1489: RETURN BOOLEAN
1490: IS
1491: l_itemcost_class ic_item_mst.itemcost_class%TYPE;
1492: CURSOR ic_cost_cls_c1 IS
1493: SELECT
1494: itemcost_class
1495: FROM

Line 1544: ( p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE

1540: --| |
1541: --+==========================================================================+
1542: -- Func end of comments
1543: FUNCTION Validate_cost_mthd_code
1544: ( p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
1545: )
1546: RETURN BOOLEAN
1547: IS
1548: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

Line 1548: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;

1544: ( p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
1545: )
1546: RETURN BOOLEAN
1547: IS
1548: l_cost_mthd_code ic_item_mst.cost_mthd_code%TYPE;
1549: CURSOR cm_mthd_mst_c1 IS
1550: SELECT
1551: cost_mthd_code
1552: FROM

Line 1603: ( p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

1599: --| |
1600: --+==========================================================================+
1601: -- Func end of comments
1602: FUNCTION Validate_grade_ctl
1603: ( p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1604: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
1605: )
1606: RETURN BOOLEAN
1607: IS

Line 1604: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

1600: --+==========================================================================+
1601: -- Func end of comments
1602: FUNCTION Validate_grade_ctl
1603: ( p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1604: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
1605: )
1606: RETURN BOOLEAN
1607: IS
1608: BEGIN

Line 1647: ( p_status_ctl IN ic_item_mst.status_ctl%TYPE

1643: --| 11/13/1998 Mike Godfrey - Created |
1644: --| |
1645: --+==========================================================================+
1646: FUNCTION Validate_status_ctl
1647: ( p_status_ctl IN ic_item_mst.status_ctl%TYPE
1648: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
1649: )
1650: RETURN BOOLEAN
1651: IS

Line 1648: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE

1644: --| |
1645: --+==========================================================================+
1646: FUNCTION Validate_status_ctl
1647: ( p_status_ctl IN ic_item_mst.status_ctl%TYPE
1648: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
1649: )
1650: RETURN BOOLEAN
1651: IS
1652: BEGIN

Line 1691: ( p_qc_grade IN ic_item_mst.qc_grade%TYPE

1687: --| 11/13/1998 Mike Godfrey - Created |
1688: --| |
1689: --+==========================================================================+
1690: FUNCTION Validate_qc_grade
1691: ( p_qc_grade IN ic_item_mst.qc_grade%TYPE
1692: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1693: )
1694: RETURN BOOLEAN
1695: IS

Line 1692: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

1688: --| |
1689: --+==========================================================================+
1690: FUNCTION Validate_qc_grade
1691: ( p_qc_grade IN ic_item_mst.qc_grade%TYPE
1692: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1693: )
1694: RETURN BOOLEAN
1695: IS
1696: l_qc_grade ic_item_mst.qc_grade%TYPE;

Line 1696: l_qc_grade ic_item_mst.qc_grade%TYPE;

1692: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1693: )
1694: RETURN BOOLEAN
1695: IS
1696: l_qc_grade ic_item_mst.qc_grade%TYPE;
1697: CURSOR qc_grad_mst_c1 IS
1698: SELECT
1699: qc_grade
1700: FROM

Line 1761: ( p_lot_status IN ic_item_mst.lot_status%TYPE

1757: --| 11/13/1998 Mike Godfrey - Created |
1758: --| |
1759: --+==========================================================================+
1760: FUNCTION Validate_lot_status
1761: ( p_lot_status IN ic_item_mst.lot_status%TYPE
1762: , p_status_ctl IN ic_item_mst.status_ctl%TYPE
1763: )
1764: RETURN BOOLEAN
1765: IS

Line 1762: , p_status_ctl IN ic_item_mst.status_ctl%TYPE

1758: --| |
1759: --+==========================================================================+
1760: FUNCTION Validate_lot_status
1761: ( p_lot_status IN ic_item_mst.lot_status%TYPE
1762: , p_status_ctl IN ic_item_mst.status_ctl%TYPE
1763: )
1764: RETURN BOOLEAN
1765: IS
1766: l_lot_status ic_item_mst.lot_status%TYPE;

Line 1766: l_lot_status ic_item_mst.lot_status%TYPE;

1762: , p_status_ctl IN ic_item_mst.status_ctl%TYPE
1763: )
1764: RETURN BOOLEAN
1765: IS
1766: l_lot_status ic_item_mst.lot_status%TYPE;
1767: CURSOR ic_lots_sts_c1 IS
1768: SELECT
1769: lot_status
1770: FROM

Line 1830: ( p_qchold_res_code IN ic_item_mst.qchold_res_code%TYPE

1826: --| 11/13/1998 Mike Godfrey - Created |
1827: --| |
1828: --+==========================================================================+
1829: FUNCTION Validate_qchold_res_code
1830: ( p_qchold_res_code IN ic_item_mst.qchold_res_code%TYPE
1831: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1832: )
1833: RETURN BOOLEAN
1834: IS

Line 1831: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

1827: --| |
1828: --+==========================================================================+
1829: FUNCTION Validate_qchold_res_code
1830: ( p_qchold_res_code IN ic_item_mst.qchold_res_code%TYPE
1831: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1832: )
1833: RETURN BOOLEAN
1834: IS
1835: l_qchold_res_code ic_item_mst.qchold_res_code%TYPE;

Line 1835: l_qchold_res_code ic_item_mst.qchold_res_code%TYPE;

1831: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1832: )
1833: RETURN BOOLEAN
1834: IS
1835: l_qchold_res_code ic_item_mst.qchold_res_code%TYPE;
1836: CURSOR qc_hres_mst_c1 IS
1837: SELECT
1838: qchold_res_code
1839: FROM

Line 1899: ( p_expaction_code IN ic_item_mst.expaction_code%TYPE

1895: --| 11/13/1998 Mike Godfrey - Created |
1896: --| |
1897: --+==========================================================================+
1898: FUNCTION Validate_expaction_code
1899: ( p_expaction_code IN ic_item_mst.expaction_code%TYPE
1900: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1901: )
1902: RETURN BOOLEAN
1903: IS

Line 1900: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

1896: --| |
1897: --+==========================================================================+
1898: FUNCTION Validate_expaction_code
1899: ( p_expaction_code IN ic_item_mst.expaction_code%TYPE
1900: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1901: )
1902: RETURN BOOLEAN
1903: IS
1904: l_expaction_code ic_item_mst.expaction_code%TYPE;

Line 1904: l_expaction_code ic_item_mst.expaction_code%TYPE;

1900: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1901: )
1902: RETURN BOOLEAN
1903: IS
1904: l_expaction_code ic_item_mst.expaction_code%TYPE;
1905: CURSOR qc_actn_mst_c1 IS
1906: SELECT
1907: action_code
1908: FROM

Line 1968: ( p_expaction_interval IN ic_item_mst.expaction_interval%TYPE

1964: --| 11/13/1998 Mike Godfrey - Created |
1965: --| |
1966: --+==========================================================================+
1967: FUNCTION Validate_expaction_interval
1968: ( p_expaction_interval IN ic_item_mst.expaction_interval%TYPE
1969: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1970: )
1971: RETURN BOOLEAN
1972: IS

Line 1969: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE

1965: --| |
1966: --+==========================================================================+
1967: FUNCTION Validate_expaction_interval
1968: ( p_expaction_interval IN ic_item_mst.expaction_interval%TYPE
1969: , p_grade_ctl IN ic_item_mst.grade_ctl%TYPE
1970: )
1971: RETURN BOOLEAN
1972: IS
1973: BEGIN

Line 2014: ( p_experimental_ind IN ic_item_mst.experimental_ind%TYPE

2010: --| 11/13/1998 Mike Godfrey - Created |
2011: --| |
2012: --+==========================================================================+
2013: FUNCTION Validate_experimental_ind
2014: ( p_experimental_ind IN ic_item_mst.experimental_ind%TYPE
2015: )
2016: RETURN BOOLEAN
2017: IS
2018: BEGIN

Line 2051: ( p_seq_dpnd_class IN ic_item_mst.seq_dpnd_class%TYPE

2047: --| 11/13/1998 Mike Godfrey - Created |
2048: --| |
2049: --+==========================================================================+
2050: FUNCTION Validate_seq_dpnd_class
2051: ( p_seq_dpnd_class IN ic_item_mst.seq_dpnd_class%TYPE
2052: )
2053: RETURN BOOLEAN
2054: IS
2055: l_seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE;

Line 2055: l_seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE;

2051: ( p_seq_dpnd_class IN ic_item_mst.seq_dpnd_class%TYPE
2052: )
2053: RETURN BOOLEAN
2054: IS
2055: l_seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE;
2056: CURSOR cr_sqdt_cls_c1 IS
2057: SELECT
2058: seq_dpnd_class
2059: FROM

Line 2109: ( p_commodity_code IN ic_item_mst.commodity_code%TYPE

2105: --| 11/13/1998 Mike Godfrey - Created |
2106: --| |
2107: --+==========================================================================+
2108: FUNCTION Validate_commodity_code
2109: ( p_commodity_code IN ic_item_mst.commodity_code%TYPE
2110: , p_sy$intrastat IN VARCHAR2
2111: )
2112: RETURN BOOLEAN
2113: IS

Line 2114: l_commodity_code ic_item_mst.commodity_code%TYPE;

2110: , p_sy$intrastat IN VARCHAR2
2111: )
2112: RETURN BOOLEAN
2113: IS
2114: l_commodity_code ic_item_mst.commodity_code%TYPE;
2115: CURSOR ic_comd_cds_c1 IS
2116: SELECT
2117: commodity_code
2118: FROM

Line 2408: ( p_item_no IN ic_item_mst.item_no%TYPE

2404: --| 11/13/1998 Mike Godfrey - Created |
2405: --| |
2406: --+==========================================================================+
2407: FUNCTION Validate_lot_No
2408: ( p_item_no IN ic_item_mst.item_no%TYPE
2409: , p_lot_no IN ic_lots_mst.lot_no%TYPE
2410: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2411: )
2412: RETURN BOOLEAN

Line 2414: l_item_id ic_item_mst.item_id%TYPE;

2410: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2411: )
2412: RETURN BOOLEAN
2413: IS
2414: l_item_id ic_item_mst.item_id%TYPE;
2415: l_item_no ic_item_mst.item_no%TYPE;
2416: l_lot_no ic_lots_mst.lot_no%TYPE;
2417: l_sublot_no ic_lots_mst.sublot_no%TYPE;
2418:

Line 2415: l_item_no ic_item_mst.item_no%TYPE;

2411: )
2412: RETURN BOOLEAN
2413: IS
2414: l_item_id ic_item_mst.item_id%TYPE;
2415: l_item_no ic_item_mst.item_no%TYPE;
2416: l_lot_no ic_lots_mst.lot_no%TYPE;
2417: l_sublot_no ic_lots_mst.sublot_no%TYPE;
2418:
2419: CURSOR ic_lots_mst_c1 IS

Line 2426: ic_item_mst a

2422: , a.item_id
2423: , b.lot_no
2424: , b.sublot_no
2425: FROM
2426: ic_item_mst a
2427: , ic_lots_mst b
2428: WHERE
2429: p_item_no = a.item_no
2430: AND a.item_id = b.item_id

Line 2482: ( p_item_loct_ctl IN ic_item_mst.loct_ctl%TYPE

2478: --| 11/13/1998 Mike Godfrey - Created |
2479: --| |
2480: --+==========================================================================+
2481: FUNCTION Validate_Location
2482: ( p_item_loct_ctl IN ic_item_mst.loct_ctl%TYPE
2483: , p_whse_loct_ctl IN ic_whse_mst.loct_ctl%TYPE
2484: , p_whse_code IN ic_whse_mst.whse_code%TYPE
2485: , p_location IN ic_loct_mst.location%TYPE
2486: )

Line 2573: ( p_item_no IN ic_item_mst.item_no%TYPE

2569: --| 11/13/1998 Mike Godfrey - Created |
2570: --| |
2571: --+==========================================================================+
2572: FUNCTION Validate_item_cnv
2573: ( p_item_no IN ic_item_mst.item_no%TYPE
2574: , p_lot_no IN ic_lots_mst.lot_no%TYPE
2575: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
2576: , p_um_type IN ic_item_cnv.um_type%TYPE
2577: )

Line 2580: l_item_no ic_item_mst.item_no%TYPE;

2576: , p_um_type IN ic_item_cnv.um_type%TYPE
2577: )
2578: RETURN BOOLEAN
2579: IS
2580: l_item_no ic_item_mst.item_no%TYPE;
2581:
2582: CURSOR ic_item_cnv_c1 IS
2583: SELECT
2584: a.item_no

Line 2586: ic_item_mst a

2582: CURSOR ic_item_cnv_c1 IS
2583: SELECT
2584: a.item_no
2585: FROM
2586: ic_item_mst a
2587: , ic_lots_mst b
2588: , ic_item_cnv c
2589: WHERE
2590: p_item_no = a.item_no