APPS.GMI_TRAN_CMP_PVT dependencies on IC_TRAN_CMP

Line 13: FUNCTION INSERT_IC_TRAN_CMP

9: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_TRAN_CMP_PVT';
10: /* Api start of comments */
11:
12:
13: FUNCTION INSERT_IC_TRAN_CMP
14: (
15: p_tran_row IN IC_TRAN_CMP%ROWTYPE,
16: x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE
17: )

Line 15: p_tran_row IN IC_TRAN_CMP%ROWTYPE,

11:
12:
13: FUNCTION INSERT_IC_TRAN_CMP
14: (
15: p_tran_row IN IC_TRAN_CMP%ROWTYPE,
16: x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE
17: )
18: RETURN BOOLEAN
19: IS

Line 16: x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE

12:
13: FUNCTION INSERT_IC_TRAN_CMP
14: (
15: p_tran_row IN IC_TRAN_CMP%ROWTYPE,
16: x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE
17: )
18: RETURN BOOLEAN
19: IS
20: err_num NUMBER;

Line 28: INSERT INTO IC_TRAN_CMP

24:
25: SELECT gem5_trans_id_s.nextval
26: INTO l_trans_id FROM dual;
27:
28: INSERT INTO IC_TRAN_CMP
29: (
30: trans_id
31: , item_id
32: , line_id

Line 96: /* dbms_output.put_line(' INSERT IC_TRAN_CMP SUCCESSFUL'); */

92: , p_tran_row.line_detail_id
93: , p_tran_row.intorder_posted_ind
94: );
95:
96: /* dbms_output.put_line(' INSERT IC_TRAN_CMP SUCCESSFUL'); */
97: x_tran_row := p_tran_row;
98: x_tran_row.trans_id := l_trans_id;
99: RETURN TRUE;
100:

Line 108: , 'insert_ic_tran_cmp'

104: err_num :=SQLCODE;
105: err_msg :=SUBSTR(SQLERRM,1 ,100);
106:
107: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
108: , 'insert_ic_tran_cmp'
109: );
110: RETURN FALSE;
111:
112: END INSERT_IC_TRAN_CMP;

Line 112: END INSERT_IC_TRAN_CMP;

108: , 'insert_ic_tran_cmp'
109: );
110: RETURN FALSE;
111:
112: END INSERT_IC_TRAN_CMP;
113:
114: FUNCTION FETCH_IC_TRAN_CMP
115: (
116: p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

Line 114: FUNCTION FETCH_IC_TRAN_CMP

110: RETURN FALSE;
111:
112: END INSERT_IC_TRAN_CMP;
113:
114: FUNCTION FETCH_IC_TRAN_CMP
115: (
116: p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
117: ,x_tran_fetch_rec OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
118: )

Line 185: FROM IC_TRAN_CMP

181: , x_tran_fetch_rec.text_code
182: , x_tran_fetch_rec.user_id
183: , x_tran_fetch_rec.line_detail_id
184: , x_tran_fetch_rec.intorder_posted_ind
185: FROM IC_TRAN_CMP
186: WHERE
187: doc_type = p_tran_rec.doc_type
188: AND doc_id = p_tran_rec.doc_id
189: AND line_id = p_tran_rec.line_id

Line 250: FROM IC_TRAN_CMP

246: , x_tran_fetch_rec.text_code
247: , x_tran_fetch_rec.user_id
248: , x_tran_fetch_rec.line_detail_id
249: , x_tran_fetch_rec.intorder_posted_ind
250: FROM IC_TRAN_CMP
251: WHERE
252: trans_id = p_tran_rec.trans_id;
253:
254: END IF;

Line 256: /* dbms_output.put_line(' FETCH IC_TRAN_CMP SUCCESSFUL'); */

252: trans_id = p_tran_rec.trans_id;
253:
254: END IF;
255:
256: /* dbms_output.put_line(' FETCH IC_TRAN_CMP SUCCESSFUL'); */
257: RETURN TRUE;
258:
259: EXCEPTION
260: WHEN OTHERS THEN

Line 270: END FETCH_IC_TRAN_CMP;

266: , 'fetch_ic_tran_pnd'
267: );
268: RETURN FALSE;
269:
270: END FETCH_IC_TRAN_CMP;
271:
272:
273: END GMI_TRAN_CMP_PVT;