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

Line 57: * a view created from the data in ic_loct_inv and ic_tran_pnd

53: * Modified create completed transaction to accept/process
54: * journal transactions doc types also.
55: * Jalaj Srivastava Bug 2519568
56: * Removed DML code for ic_summ_inv since, now ic_summ_inv is
57: * a view created from the data in ic_loct_inv and ic_tran_pnd
58: * Joe DiIorio Bug 2643440 11.5.1J
59: * Added nocopy.
60: * Joe DiIorio Bug 3090255 11.5.10L 08/15/2003
61: * Added field intorder_posted_ind.

Line 86: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

82: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
83: , p_commit IN VARCHAR2 := FND_API.G_FALSE
84: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
85: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
86: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
87: , x_return_status OUT NOCOPY VARCHAR2
88: , x_msg_count OUT NOCOPY NUMBER
89: , x_msg_data OUT NOCOPY VARCHAR2
90: )

Line 96: l_tran_row IC_TRAN_PND%ROWTYPE;

92: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PENDING_TRANSACTION';
93: l_api_version CONSTANT NUMBER := 1.0;
94: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
95: l_tran_rec_val GMI_TRANS_ENGINE_PUB.ictran_rec;
96: l_tran_row IC_TRAN_PND%ROWTYPE;
97: l_msg_count NUMBER :=0;
98: l_return_val NUMBER :=0;
99: l_retry_flag NUMBER :=1;
100: l_msg_data VARCHAR2(2000);

Line 132: a view created from the data in ic_loct_inv and ic_tran_pnd

128:
129: /* ***********************************************************
130: Jalaj Srivastava Bug 2519568
131: Removed DML code for ic_summ_inv since, now ic_summ_inv is
132: a view created from the data in ic_loct_inv and ic_tran_pnd
133: *********************************************************** */
134:
135: PENDING_TRANSACTION_BUILD
136: ( p_tran_rec => l_tran_rec

Line 141: /* Call the IC_TRAN_PND INSERT procedure to insert this record. */

137: , x_tran_row => l_tran_row
138: , x_return_status => l_return_status
139: );
140:
141: /* Call the IC_TRAN_PND INSERT procedure to insert this record. */
142:
143: IF NOT GMI_TRAN_PND_DB_PVT.INSERT_IC_TRAN_PND
144: ( p_tran_row => l_tran_row, x_tran_row => x_tran_row)
145: THEN

Line 143: IF NOT GMI_TRAN_PND_DB_PVT.INSERT_IC_TRAN_PND

139: );
140:
141: /* Call the IC_TRAN_PND INSERT procedure to insert this record. */
142:
143: IF NOT GMI_TRAN_PND_DB_PVT.INSERT_IC_TRAN_PND
144: ( p_tran_row => l_tran_row, x_tran_row => x_tran_row)
145: THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;

Line 207: l_tran_pnd IC_TRAN_PND%ROWTYPE;

203: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_COMPLETED_TRANSACTION';
204: l_api_version CONSTANT NUMBER := 1.0;
205: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
206: l_tran_cmp IC_TRAN_CMP%ROWTYPE;
207: l_tran_pnd IC_TRAN_PND%ROWTYPE;
208: l_msg_count NUMBER :=0;
209: l_return_val NUMBER :=0;
210: l_retry_flag NUMBER :=0;
211: l_msg_data VARCHAR2(2000);

Line 298: a view created from the data in ic_loct_inv and ic_tran_pnd

294: /* Update Inventory Balances ( Actuals). */
295: /* ***********************************************************
296: Jalaj Srivastava Bug 2519568
297: Removed DML code for ic_summ_inv since, now ic_summ_inv is
298: a view created from the data in ic_loct_inv and ic_tran_pnd
299: *********************************************************** */
300:
301:
302: /* Jalaj Srivastava Bug 1427922 */

Line 389: /* Call the IC_TRAN_PND INSERT procedure to insert this record. */

385: END IF; -- l_status_ctl =2 and p_tran_rec.doc_type='STSI')
386: -- END Bug# 2341493
387:
388: ELSE
389: /* Call the IC_TRAN_PND INSERT procedure to insert this record. */
390: l_tran_pnd.trans_id := p_tran_rec.trans_id;
391: l_tran_pnd.item_id := p_tran_rec.item_id;
392: l_tran_pnd.line_id := p_tran_rec.line_id;
393: l_tran_pnd.co_code := p_tran_rec.co_code;

Line 432: IF NOT GMI_TRAN_PND_DB_PVT.INSERT_IC_TRAN_PND

428: BUG#3526733 Populated reverse_id
429: ==========================================*/
430: l_tran_pnd.reverse_id := p_tran_rec.reverse_id;
431:
432: IF NOT GMI_TRAN_PND_DB_PVT.INSERT_IC_TRAN_PND
433: ( p_tran_row => l_tran_pnd, x_tran_row => l_tran_pnd)
434: THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;

Line 527: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

523: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
524: , p_commit IN VARCHAR2 := FND_API.G_FALSE
525: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
526: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
527: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
528: , x_return_status OUT NOCOPY VARCHAR2
529: , x_msg_count OUT NOCOPY NUMBER
530: , x_msg_data OUT NOCOPY VARCHAR2
531: )

Line 541: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;

537: l_msg_count NUMBER :=0;
538: l_return_val NUMBER :=0;
539: l_msg_data VARCHAR2(2000);
540: l_return_status VARCHAR2(1);
541: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
542: l_tran_row IC_TRAN_PND%ROWTYPE;
543: BEGIN
544: /* Standard Start OF API savepoint */
545: SAVEPOINT delete_pending_transaction;

Line 542: l_tran_row IC_TRAN_PND%ROWTYPE;

538: l_return_val NUMBER :=0;
539: l_msg_data VARCHAR2(2000);
540: l_return_status VARCHAR2(1);
541: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
542: l_tran_row IC_TRAN_PND%ROWTYPE;
543: BEGIN
544: /* Standard Start OF API savepoint */
545: SAVEPOINT delete_pending_transaction;
546:

Line 580: /* Call the IC_TRAN_PND FETCH procedure to FETCH this record. */

576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578: */
579:
580: /* Call the IC_TRAN_PND FETCH procedure to FETCH this record. */
581:
582: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
583: ( p_tran_rec => l_tran_rec, x_tran_fetch_rec => l_tran_fetch_rec )
584: THEN

Line 582: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

578: */
579:
580: /* Call the IC_TRAN_PND FETCH procedure to FETCH this record. */
581:
582: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
583: ( p_tran_rec => l_tran_rec, x_tran_fetch_rec => l_tran_fetch_rec )
584: THEN
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END IF;

Line 600: a view created from the data in ic_loct_inv and ic_tran_pnd

596:
597: /* ***********************************************************
598: Jalaj Srivastava Bug 2519568
599: Removed DML code for ic_summ_inv since, now ic_summ_inv is
600: a view created from the data in ic_loct_inv and ic_tran_pnd
601: *********************************************************** */
602: END IF;
603:
604: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */

Line 604: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */

600: a view created from the data in ic_loct_inv and ic_tran_pnd
601: *********************************************************** */
602: END IF;
603:
604: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */
605:
606: PENDING_TRANSACTION_BUILD
607: ( p_tran_rec => l_tran_fetch_rec
608: , x_tran_row => l_tran_row

Line 612: /* Call the IC_TRAN_PND DELETE procedure to Logically Delete this record. */

608: , x_tran_row => l_tran_row
609: , x_return_status => l_return_status
610: );
611:
612: /* Call the IC_TRAN_PND DELETE procedure to Logically Delete this record. */
613:
614: IF NOT GMI_TRAN_PND_DB_PVT.DELETE_IC_TRAN_PND
615: ( p_tran_row => l_tran_row )
616: THEN

Line 614: IF NOT GMI_TRAN_PND_DB_PVT.DELETE_IC_TRAN_PND

610: );
611:
612: /* Call the IC_TRAN_PND DELETE procedure to Logically Delete this record. */
613:
614: IF NOT GMI_TRAN_PND_DB_PVT.DELETE_IC_TRAN_PND
615: ( p_tran_row => l_tran_row )
616: THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;

Line 667: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

663: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
664: , p_commit IN VARCHAR2 := FND_API.G_FALSE
665: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
666: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
667: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
668: , x_return_status OUT NOCOPY VARCHAR2
669: , x_msg_count OUT NOCOPY NUMBER
670: , x_msg_data OUT NOCOPY VARCHAR2
671: )

Line 682: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;

678: l_return_val NUMBER :=0;
679: l_retry_flag NUMBER :=1;
680: l_msg_data VARCHAR2(2000);
681: l_return_status VARCHAR2(1);
682: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
683: l_tran_row IC_TRAN_PND%ROWTYPE;
684: l_old_qc_grade VARCHAR2(4);
685: l_new_qc_grade VARCHAR2(4);
686: BEGIN

Line 683: l_tran_row IC_TRAN_PND%ROWTYPE;

679: l_retry_flag NUMBER :=1;
680: l_msg_data VARCHAR2(2000);
681: l_return_status VARCHAR2(1);
682: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
683: l_tran_row IC_TRAN_PND%ROWTYPE;
684: l_old_qc_grade VARCHAR2(4);
685: l_new_qc_grade VARCHAR2(4);
686: BEGIN
687: /* Standard Start OF API savepoint */

Line 721: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

717: IF l_tran_rec.non_inv = 0
718: THEN
719: /* Get Previous Transaction Using Input Tran rec. */
720:
721: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
722: ( p_tran_rec => l_tran_rec, x_tran_fetch_rec => l_tran_fetch_rec )
723: THEN
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: END IF;

Line 747: a view created from the data in ic_loct_inv and ic_tran_pnd

743:
744: /* ***********************************************************
745: Jalaj Srivastava Bug 2519568
746: Removed DML code for ic_summ_inv since, now ic_summ_inv is
747: a view created from the data in ic_loct_inv and ic_tran_pnd
748: *********************************************************** */
749:
750: ELSE
751: /* Update Previous Demand */

Line 762: /* Call the IC_TRAN_PND INSERT procedure to insert this record. */

758:
759: END IF;
760: END IF;
761:
762: /* Call the IC_TRAN_PND INSERT procedure to insert this record. */
763: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */
764:
765: PENDING_TRANSACTION_BUILD
766: ( p_tran_rec => l_tran_rec

Line 763: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */

759: END IF;
760: END IF;
761:
762: /* Call the IC_TRAN_PND INSERT procedure to insert this record. */
763: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */
764:
765: PENDING_TRANSACTION_BUILD
766: ( p_tran_rec => l_tran_rec
767: , x_tran_row => l_tran_row

Line 772: IF NOT GMI_TRAN_PND_DB_PVT.UPDATE_IC_TRAN_PND

768: , x_return_status => l_return_status
769: );
770:
771:
772: IF NOT GMI_TRAN_PND_DB_PVT.UPDATE_IC_TRAN_PND
773: ( p_tran_row => l_tran_row)
774: THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;

Line 824: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

820: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
821: , p_commit IN VARCHAR2 := FND_API.G_FALSE
822: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
823: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
824: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
825: , x_return_status OUT NOCOPY VARCHAR2
826: , x_msg_count OUT NOCOPY NUMBER
827: , x_msg_data OUT NOCOPY VARCHAR2
828: )

Line 839: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;

835: l_return_val NUMBER :=0;
836: l_retry_flag NUMBER :=0;
837: l_msg_data VARCHAR2(2000);
838: l_return_status VARCHAR2(1);
839: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
840: l_tran_row IC_TRAN_PND%ROWTYPE;
841: -- TKW B3415691 (Pls refer to 3599127)
842: l_item_mst_rec ic_item_mst%ROWTYPE;
843:

Line 840: l_tran_row IC_TRAN_PND%ROWTYPE;

836: l_retry_flag NUMBER :=0;
837: l_msg_data VARCHAR2(2000);
838: l_return_status VARCHAR2(1);
839: l_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
840: l_tran_row IC_TRAN_PND%ROWTYPE;
841: -- TKW B3415691 (Pls refer to 3599127)
842: l_item_mst_rec ic_item_mst%ROWTYPE;
843:
844: /* TKW B3415691 - Enhancement for Serono (Pls refer to B3599127) */

Line 908: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

904: IF l_tran_rec.non_inv = 0
905: THEN
906: /* Get Previous Transaction Using Input Tran rec. */
907:
908: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
909: (
910: p_tran_rec => l_tran_rec,
911: x_tran_fetch_rec => l_tran_fetch_rec
912: )

Line 927: a view created from the data in ic_loct_inv and ic_tran_pnd

923:
924: /* ***********************************************************
925: Jalaj Srivastava Bug 2519568
926: Removed DML code for ic_summ_inv since, now ic_summ_inv is
927: a view created from the data in ic_loct_inv and ic_tran_pnd
928: *********************************************************** */
929:
930: GMI_LOCT_INV_PVT.UPDATING_IC_LOCT_INV
931: (

Line 975: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */

971: FETCH Cur_qc_grade INTO l_tran_rec.qc_grade;
972: CLOSE Cur_qc_grade;
973: END IF;
974:
975: /* Call Create_pending_transaction to build ic_tran_pnd%rowtype; */
976:
977: COMPLETED_TRANSACTION_BUILD
978: ( p_tran_rec => l_tran_rec
979: , x_tran_row => l_tran_row

Line 983: IF NOT GMI_TRAN_PND_DB_PVT.UPDATE_IC_TRAN_PND ( p_tran_row => l_tran_row)

979: , x_tran_row => l_tran_row
980: , x_return_status => l_return_status
981: );
982:
983: IF NOT GMI_TRAN_PND_DB_PVT.UPDATE_IC_TRAN_PND ( p_tran_row => l_tran_row)
984: THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987:

Line 1030: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

1026:
1027:
1028: PROCEDURE PENDING_TRANSACTION_BUILD
1029: ( p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
1030: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
1031: , x_return_status OUT NOCOPY VARCHAR2
1032: )
1033: IS
1034: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

Line 1035: l_tran_row IC_TRAN_PND%ROWTYPE;

1031: , x_return_status OUT NOCOPY VARCHAR2
1032: )
1033: IS
1034: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
1035: l_tran_row IC_TRAN_PND%ROWTYPE;
1036: BEGIN
1037: x_tran_row.trans_id := p_tran_rec.trans_id;
1038: x_tran_row.item_id := p_tran_rec.item_id;
1039: x_tran_row.line_id := p_tran_rec.line_id;

Line 1095: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

1091: END PENDING_TRANSACTION_BUILD;
1092:
1093: PROCEDURE COMPLETED_TRANSACTION_BUILD
1094: ( p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
1095: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
1096: , x_return_status OUT NOCOPY VARCHAR2
1097: )
1098: IS
1099: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

Line 1100: l_tran_row IC_TRAN_PND%ROWTYPE;

1096: , x_return_status OUT NOCOPY VARCHAR2
1097: )
1098: IS
1099: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
1100: l_tran_row IC_TRAN_PND%ROWTYPE;
1101:
1102: BEGIN
1103:
1104: x_tran_row.trans_id := p_tran_rec.trans_id;

Line 1120: update statement had already been commented in GMI_TRAN_PND_DB_PVT.update_ic_tran_pnd for bug#2385934)

1116: x_tran_row.line_type := NVL(p_tran_rec.line_type,0);
1117: /* NC 8/16/02 Commenting the below line. There's no need to update the
1118: creation date when completing the pending transaction. The creation_date
1119: should always reflect the date when the transaction is created.The DML
1120: update statement had already been commented in GMI_TRAN_PND_DB_PVT.update_ic_tran_pnd for bug#2385934)
1121: x_tran_row.creation_date := NVL(p_tran_rec.trans_date,SYSDATE);
1122: */
1123: x_tran_row.trans_date := NVL(p_tran_rec.trans_date,SYSDATE);
1124: x_tran_row.trans_qty := p_tran_rec.trans_qty;