APPS.GML_PO_CREATE_FLEXFIELDS dependencies on IC_ITEM_MST

Line 20: ( v_item_no IN IC_ITEM_MST.ITEM_NO%TYPE,

16: | |
17: +========================================================================+ */
18:
19: FUNCTION compute_duom_qty
20: ( v_item_no IN IC_ITEM_MST.ITEM_NO%TYPE,
21: v_um1 IN CHAR,
22: v_order1 IN NUMBER,
23: v_um2 IN CHAR)
24: return NUMBER

Line 29: FROM ic_item_mst

25: IS
26:
27: CURSOR gm_item_id_cur IS
28: SELECT item_id
29: FROM ic_item_mst
30: WHERE item_no = v_item_no;
31:
32: v_order2 number;
33: v_std_factor1 NUMBER;

Line 48: gm_item_id IC_ITEM_MST.ITEM_ID%TYPE;

44: err_num NUMBER;
45: err_msg VARCHAR2(100);
46: fhandle utl_file.file_type;
47:
48: gm_item_id IC_ITEM_MST.ITEM_ID%TYPE;
49:
50: BEGIN
51:
52: /* 11/6/1998 T. Ricci added*/

Line 511: ( v_item_no IN IC_ITEM_MST.ITEM_NO%TYPE)

507: | |
508: +========================================================================+ */
509:
510: FUNCTION get_item_um2
511: ( v_item_no IN IC_ITEM_MST.ITEM_NO%TYPE)
512: return VARCHAR2
513: IS
514:
515: CURSOR gm_item_um2_cur IS

Line 517: FROM ic_item_mst

513: IS
514:
515: CURSOR gm_item_um2_cur IS
516: SELECT item_um2
517: FROM ic_item_mst
518: WHERE item_no = v_item_no;
519:
520: err_num NUMBER;
521: err_msg VARCHAR2(100);

Line 523: gm_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;

519:
520: err_num NUMBER;
521: err_msg VARCHAR2(100);
522:
523: gm_item_um2 IC_ITEM_MST.ITEM_UM2%TYPE;
524:
525: BEGIN
526:
527: OPEN gm_item_um2_cur;