APPS.GMI_GLOBAL_GRP dependencies on IC_ITEM_MST

Line 44: --| This procedure is used to retrieve all details from ic_item_mst |

40: --| USAGE |
41: --| Used to retrieve item master details |
42: --| |
43: --| DESCRIPTION |
44: --| This procedure is used to retrieve all details from ic_item_mst |
45: --| |
46: --| PARAMETERS |
47: --| p_item_no IN VARCHAR2(32) - Item number to be retrieved |
48: --| x_ic_item_mst OUT RECORD - Record containing ic_item_mst |

Line 48: --| x_ic_item_mst OUT RECORD - Record containing ic_item_mst |

44: --| This procedure is used to retrieve all details from ic_item_mst |
45: --| |
46: --| PARAMETERS |
47: --| p_item_no IN VARCHAR2(32) - Item number to be retrieved |
48: --| x_ic_item_mst OUT RECORD - Record containing ic_item_mst |
49: --| x_ic_item_cpg OUT RECORD - Record containing ic_item_cpg |
50: --| |
51: --| HISTORY |
52: --| 01-OCT-1998 M.Godfrey Created |

Line 56: ( p_item_no IN ic_item_mst.item_no%TYPE

52: --| 01-OCT-1998 M.Godfrey Created |
53: --+=========================================================================+
54: -- Proc end of comments
55: PROCEDURE Get_Item
56: ( p_item_no IN ic_item_mst.item_no%TYPE
57: , x_ic_item_mst OUT NOCOPY ic_item_mst%ROWTYPE
58: , x_ic_item_cpg OUT NOCOPY ic_item_cpg%ROWTYPE
59: )
60: IS

Line 57: , x_ic_item_mst OUT NOCOPY ic_item_mst%ROWTYPE

53: --+=========================================================================+
54: -- Proc end of comments
55: PROCEDURE Get_Item
56: ( p_item_no IN ic_item_mst.item_no%TYPE
57: , x_ic_item_mst OUT NOCOPY ic_item_mst%ROWTYPE
58: , x_ic_item_cpg OUT NOCOPY ic_item_cpg%ROWTYPE
59: )
60: IS
61: CURSOR ic_item_mst_c1 IS

Line 61: CURSOR ic_item_mst_c1 IS

57: , x_ic_item_mst OUT NOCOPY ic_item_mst%ROWTYPE
58: , x_ic_item_cpg OUT NOCOPY ic_item_cpg%ROWTYPE
59: )
60: IS
61: CURSOR ic_item_mst_c1 IS
62: SELECT
63: *
64: FROM
65: ic_item_mst

Line 65: ic_item_mst

61: CURSOR ic_item_mst_c1 IS
62: SELECT
63: *
64: FROM
65: ic_item_mst
66: WHERE
67: item_no = p_item_no;
68:
69: CURSOR ic_item_cpg_c1(v_item_id ic_item_mst.item_id%TYPE) IS

Line 69: CURSOR ic_item_cpg_c1(v_item_id ic_item_mst.item_id%TYPE) IS

65: ic_item_mst
66: WHERE
67: item_no = p_item_no;
68:
69: CURSOR ic_item_cpg_c1(v_item_id ic_item_mst.item_id%TYPE) IS
70: SELECT
71: *
72: FROM
73: ic_item_cpg

Line 77: l_ic_item_mst ic_item_mst%ROWTYPE;

73: ic_item_cpg
74: WHERE
75: item_id = v_item_id;
76:
77: l_ic_item_mst ic_item_mst%ROWTYPE;
78:
79: BEGIN
80:
81: OPEN ic_item_mst_c1;

Line 81: OPEN ic_item_mst_c1;

77: l_ic_item_mst ic_item_mst%ROWTYPE;
78:
79: BEGIN
80:
81: OPEN ic_item_mst_c1;
82:
83: FETCH ic_item_mst_c1 INTO l_ic_item_mst;
84:
85: IF (ic_item_mst_c1%NOTFOUND)

Line 83: FETCH ic_item_mst_c1 INTO l_ic_item_mst;

79: BEGIN
80:
81: OPEN ic_item_mst_c1;
82:
83: FETCH ic_item_mst_c1 INTO l_ic_item_mst;
84:
85: IF (ic_item_mst_c1%NOTFOUND)
86: THEN
87: x_ic_item_mst.item_id := 0;

Line 85: IF (ic_item_mst_c1%NOTFOUND)

81: OPEN ic_item_mst_c1;
82:
83: FETCH ic_item_mst_c1 INTO l_ic_item_mst;
84:
85: IF (ic_item_mst_c1%NOTFOUND)
86: THEN
87: x_ic_item_mst.item_id := 0;
88: ELSE
89: x_ic_item_mst := l_ic_item_mst;

Line 87: x_ic_item_mst.item_id := 0;

83: FETCH ic_item_mst_c1 INTO l_ic_item_mst;
84:
85: IF (ic_item_mst_c1%NOTFOUND)
86: THEN
87: x_ic_item_mst.item_id := 0;
88: ELSE
89: x_ic_item_mst := l_ic_item_mst;
90: OPEN ic_item_cpg_c1(l_ic_item_mst.item_id);
91: FETCH ic_item_cpg_c1 INTO x_ic_item_cpg;

Line 89: x_ic_item_mst := l_ic_item_mst;

85: IF (ic_item_mst_c1%NOTFOUND)
86: THEN
87: x_ic_item_mst.item_id := 0;
88: ELSE
89: x_ic_item_mst := l_ic_item_mst;
90: OPEN ic_item_cpg_c1(l_ic_item_mst.item_id);
91: FETCH ic_item_cpg_c1 INTO x_ic_item_cpg;
92:
93: IF (ic_item_cpg_c1%NOTFOUND)

Line 90: OPEN ic_item_cpg_c1(l_ic_item_mst.item_id);

86: THEN
87: x_ic_item_mst.item_id := 0;
88: ELSE
89: x_ic_item_mst := l_ic_item_mst;
90: OPEN ic_item_cpg_c1(l_ic_item_mst.item_id);
91: FETCH ic_item_cpg_c1 INTO x_ic_item_cpg;
92:
93: IF (ic_item_cpg_c1%NOTFOUND)
94: THEN

Line 101: CLOSE ic_item_mst_c1;

97: END IF;
98: CLOSE ic_item_cpg_c1;
99: END IF;
100:
101: CLOSE ic_item_mst_c1;
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: RAISE;