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_TRAN_PND_DB_PVT dependencies on IC_TRAN_PND

Line 13: | For IC_TRAN_PND |

9: | GMIVPNDB.pls |
10: | |
11: | DESCRIPTION |
12: | This package contains private definitions For DML Actions |
13: | For IC_TRAN_PND |
14: | |
15: | HISTORY |
16: | 12-JAN-2000 H.Verdding |
17: | 24-AUG-2001 NC Added line_detail_id.BUG#1675561 |

Line 20: | update_ic_tran_pnd as the creation date should not change during |

16: | 12-JAN-2000 H.Verdding |
17: | 24-AUG-2001 NC Added line_detail_id.BUG#1675561 |
18: | Piyush K. Mishra 6-Jun-2002 Bug#2385934 |
19: | Commented the line that updates the creation_date in the procedure |
20: | update_ic_tran_pnd as the creation date should not change during |
21: | updation. |
22: | 30-OCT-2002 J.DiIorio Bug#2643440 11.5.1J - added nocopy and |
23: | changed out to in out. |
24: | 15_AUG-2003 J.DiIorio Bug#3090255 11.5.10L |

Line 27: | Added code to insert reverse_id into IC_TRAN_PND table |

23: | changed out to in out. |
24: | 15_AUG-2003 J.DiIorio Bug#3090255 11.5.10L |
25: | Added field intorder_posted_ind. |
26: | 2-APR-2004 V.Anitha BUG#3526733 |
27: | Added code to insert reverse_id into IC_TRAN_PND table |
28: | 14-APR-2004 V.Anita BUG#3526733 |
29: | Modified the value passed to the reverse_id from |
30: | p_tran_row.tran_id to p_tran_row.reverse_id when |
31: | inserting into IC_TRAN_PND table. |

Line 31: | inserting into IC_TRAN_PND table. |

27: | Added code to insert reverse_id into IC_TRAN_PND table |
28: | 14-APR-2004 V.Anita BUG#3526733 |
29: | Modified the value passed to the reverse_id from |
30: | p_tran_row.tran_id to p_tran_row.reverse_id when |
31: | inserting into IC_TRAN_PND table. |
32: +=========================================================================+
33: API Name : GMI_TRAN_PND_DB_PVT
34: Type : Public
35: Function : This package contains private procedures used to create

Line 36: IC_TRAN_PND transactions

32: +=========================================================================+
33: API Name : GMI_TRAN_PND_DB_PVT
34: Type : Public
35: Function : This package contains private procedures used to create
36: IC_TRAN_PND transactions
37: Pre-reqs : N/A
38: Parameters: Per function
39:
40: Current Vers : 1.0

Line 54: FUNCTION INSERT_IC_TRAN_PND

50: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_TRAN_PND_DB_PVT';
51: /* Api start of comments */
52:
53:
54: FUNCTION INSERT_IC_TRAN_PND
55: (
56: p_tran_row IN IC_TRAN_PND%ROWTYPE,
57: x_tran_row IN OUT NOCOPY IC_TRAN_PND%ROWTYPE
58: )

Line 56: p_tran_row IN IC_TRAN_PND%ROWTYPE,

52:
53:
54: FUNCTION INSERT_IC_TRAN_PND
55: (
56: p_tran_row IN IC_TRAN_PND%ROWTYPE,
57: x_tran_row IN OUT NOCOPY IC_TRAN_PND%ROWTYPE
58: )
59: RETURN BOOLEAN
60: IS

Line 57: x_tran_row IN OUT NOCOPY IC_TRAN_PND%ROWTYPE

53:
54: FUNCTION INSERT_IC_TRAN_PND
55: (
56: p_tran_row IN IC_TRAN_PND%ROWTYPE,
57: x_tran_row IN OUT NOCOPY IC_TRAN_PND%ROWTYPE
58: )
59: RETURN BOOLEAN
60: IS
61: err_num NUMBER;

Line 66: SELECT trans_id FROM IC_TRAN_PND

62: err_msg VARCHAR2(100);
63: l_trans_id NUMBER;
64:
65: CURSOR C ( v_trans_id IN NUMBER) IS
66: SELECT trans_id FROM IC_TRAN_PND
67: WHERE trans_id = v_trans_id;
68:
69:
70: BEGIN

Line 75: INSERT INTO IC_TRAN_PND

71:
72: SELECT gem5_trans_id_s.nextval
73: INTO l_trans_id FROM dual;
74:
75: INSERT INTO IC_TRAN_PND
76: (
77: trans_id
78: , item_id
79: , line_id

Line 179: , 'insert_ic_tran_pnd'

175: FND_MSG_PUB.Add;
176:
177:
178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
179: , 'insert_ic_tran_pnd'
180: );
181: RETURN FALSE;
182:
183: END INSERT_IC_TRAN_PND;

Line 183: END INSERT_IC_TRAN_PND;

179: , 'insert_ic_tran_pnd'
180: );
181: RETURN FALSE;
182:
183: END INSERT_IC_TRAN_PND;
184:
185: FUNCTION FETCH_IC_TRAN_PND
186: (
187: p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

Line 185: FUNCTION FETCH_IC_TRAN_PND

181: RETURN FALSE;
182:
183: END INSERT_IC_TRAN_PND;
184:
185: FUNCTION FETCH_IC_TRAN_PND
186: (
187: p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
188: ,x_tran_fetch_rec IN OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
189: )

Line 258: FROM IC_TRAN_PND

254: , x_tran_fetch_rec.text_code
255: , x_tran_fetch_rec.user_id
256: , x_tran_fetch_rec.line_detail_id
257: , x_tran_fetch_rec.intorder_posted_ind
258: FROM IC_TRAN_PND
259: WHERE
260: doc_type = p_tran_rec.doc_type
261: AND doc_id = p_tran_rec.doc_id
262: AND line_id = p_tran_rec.line_id

Line 328: FROM IC_TRAN_PND

324: , x_tran_fetch_rec.text_code
325: , x_tran_fetch_rec.user_id
326: , x_tran_fetch_rec.line_detail_id
327: , x_tran_fetch_rec.intorder_posted_ind
328: FROM IC_TRAN_PND
329: WHERE
330: trans_id = p_tran_rec.trans_id
331: AND delete_mark =0
332: FOR UPDATE NOWAIT;

Line 353: , 'fetch_ic_tran_pnd'

349: WHEN OTHERS THEN
350:
351:
352: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
353: , 'fetch_ic_tran_pnd'
354: );
355: RETURN FALSE;
356:
357: END FETCH_IC_TRAN_PND;

Line 357: END FETCH_IC_TRAN_PND;

353: , 'fetch_ic_tran_pnd'
354: );
355: RETURN FALSE;
356:
357: END FETCH_IC_TRAN_PND;
358:
359: FUNCTION DELETE_IC_TRAN_PND
360: (
361: p_tran_row IN IC_TRAN_PND%ROWTYPE

Line 359: FUNCTION DELETE_IC_TRAN_PND

355: RETURN FALSE;
356:
357: END FETCH_IC_TRAN_PND;
358:
359: FUNCTION DELETE_IC_TRAN_PND
360: (
361: p_tran_row IN IC_TRAN_PND%ROWTYPE
362: )
363: RETURN BOOLEAN

Line 361: p_tran_row IN IC_TRAN_PND%ROWTYPE

357: END FETCH_IC_TRAN_PND;
358:
359: FUNCTION DELETE_IC_TRAN_PND
360: (
361: p_tran_row IN IC_TRAN_PND%ROWTYPE
362: )
363: RETURN BOOLEAN
364: IS
365: err_num NUMBER;

Line 370: UPDATE IC_TRAN_PND

366: err_msg VARCHAR2(100);
367:
368: BEGIN
369:
370: UPDATE IC_TRAN_PND
371: SET delete_mark = 1,
372: event_id = p_tran_row.event_id,
373: last_update_date = p_tran_row.last_update_date,
374: last_updated_by = p_tran_row.last_updated_by

Line 392: , 'delete_ic_tran_pnd'

388: WHEN OTHERS THEN
389:
390:
391: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
392: , 'delete_ic_tran_pnd'
393: );
394: RETURN FALSE;
395:
396: END DELETE_IC_TRAN_PND;

Line 396: END DELETE_IC_TRAN_PND;

392: , 'delete_ic_tran_pnd'
393: );
394: RETURN FALSE;
395:
396: END DELETE_IC_TRAN_PND;
397:
398: FUNCTION UPDATE_IC_TRAN_PND
399: (
400: p_tran_row IN IC_TRAN_PND%ROWTYPE

Line 398: FUNCTION UPDATE_IC_TRAN_PND

394: RETURN FALSE;
395:
396: END DELETE_IC_TRAN_PND;
397:
398: FUNCTION UPDATE_IC_TRAN_PND
399: (
400: p_tran_row IN IC_TRAN_PND%ROWTYPE
401: )
402: RETURN BOOLEAN

Line 400: p_tran_row IN IC_TRAN_PND%ROWTYPE

396: END DELETE_IC_TRAN_PND;
397:
398: FUNCTION UPDATE_IC_TRAN_PND
399: (
400: p_tran_row IN IC_TRAN_PND%ROWTYPE
401: )
402: RETURN BOOLEAN
403: IS
404: err_num NUMBER;

Line 409: UPDATE IC_TRAN_PND

405: err_msg VARCHAR2(100);
406:
407: BEGIN
408:
409: UPDATE IC_TRAN_PND
410: SET
411: item_id = p_tran_row.item_id,
412: line_id = p_tran_row.line_id,
413: co_code = p_tran_row.co_code,

Line 462: , 'UPDATE_ic_tran_pnd'

458:
459: WHEN OTHERS THEN
460:
461: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
462: , 'UPDATE_ic_tran_pnd'
463: );
464: RETURN FALSE;
465:
466: END UPDATE_IC_TRAN_PND;

Line 466: END UPDATE_IC_TRAN_PND;

462: , 'UPDATE_ic_tran_pnd'
463: );
464: RETURN FALSE;
465:
466: END UPDATE_IC_TRAN_PND;
467:
468: END GMI_TRAN_PND_DB_PVT;