APPS.INVTROAP dependencies on INV_TROLIN_UTIL

Line 53: l_trolin_tbl := INV_trolin_util.Get_Lines( To_Header_Id );

49: if( l_timeout_action = 1 ) then
50: Inv_trohdr_Util.Update_Row_Status(To_Header_Id,
51: Inv_Globals.G_TO_STATUS_APPROVED);
52:
53: l_trolin_tbl := INV_trolin_util.Get_Lines( To_Header_Id );
54: For l_line_count in 1..l_trolin_tbl.count Loop
55:
56: /* bug 2345192 */
57: --Bug #5462193, commented the code below

Line 62: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,

58: -- Changing the if condition to compare with INCOMPLETE.
59:
60: /*
61: if(l_trolin_tbl(l_line_count).Line_Status=6) then
62: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
63: INV_Globals.G_TO_STATUS_CANCELLED);
64: */
65:
66: if (l_trolin_tbl(l_line_count).Line_Status = INV_GLOBALS.G_TO_STATUS_INCOMPLETE) then

Line 67: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,

63: INV_Globals.G_TO_STATUS_CANCELLED);
64: */
65:
66: if (l_trolin_tbl(l_line_count).Line_Status = INV_GLOBALS.G_TO_STATUS_INCOMPLETE) then
67: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
68: INV_Globals.G_TO_STATUS_APPROVED);
69: end if;
70: end Loop;
71: else

Line 75: l_trolin_tbl := INV_trolin_util.Get_Lines( To_Header_Id );

71: else
72: Inv_trohdr_Util.Update_Row_Status(To_Header_Id,
73: Inv_Globals.G_TO_STATUS_REJECTED);
74:
75: l_trolin_tbl := INV_trolin_util.Get_Lines( To_Header_Id );
76: For l_line_count in 1..l_trolin_tbl.count Loop
77:
78: --Bug #5462193, added the if condition
79: if (l_trolin_tbl(l_line_count).Line_Status = INV_GLOBALS.G_TO_STATUS_INCOMPLETE) then

Line 80: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,

76: For l_line_count in 1..l_trolin_tbl.count Loop
77:
78: --Bug #5462193, added the if condition
79: if (l_trolin_tbl(l_line_count).Line_Status = INV_GLOBALS.G_TO_STATUS_INCOMPLETE) then
80: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
81: INV_Globals.G_TO_STATUS_REJECTED);
82: end if;
83: end Loop;
84: end if;

Line 307: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );

303:
304:
305: -- call TO API for loading line pl/sql table.
306:
307: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );
308:
309: For l_line_count in 1..l_trolin_tbl.count Loop
310:
311: -- Bug #5462193, Cancelled lines should not go for approval.

Line 463: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id ,

459:
460: l_child_itemkey := to_char(l_header_id)||'-'||
461: to_char(l_trolin_tbl(l_line_count).line_id);
462:
463: Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id ,
464: INV_Globals.G_TO_STATUS_PENDING_APPROVAL);
465:
466: wf_engine.startprocess( itemtype => l_child_itemtype,
467: itemkey => l_child_itemkey );

Line 513: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );

509: l_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
510: itemkey => itemkey,
511: aname => 'TO_HEADER_ID');
512:
513: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );
514: l_total_lines := l_trolin_tbl.count;
515:
516: For l_row_count in 1..l_trolin_tbl.count Loop
517:

Line 925: Inv_trolin_Util.Update_Row_Status(l_Line_id ,

921: where line_id = l_line_id;
922:
923:
924: IF l_line_status = INV_GLOBALS.G_TO_STATUS_PENDING_APPROVAL THEN
925: Inv_trolin_Util.Update_Row_Status(l_Line_id ,
926: INV_Globals.G_TO_STATUS_APPROVED);
927: END IF;
928: result := 'COMPLETE';
929: return;

Line 972: Inv_trolin_Util.Update_Row_Status(l_Line_id ,

968: from mtl_txn_request_lines
969: where line_id = l_line_id;
970:
971: IF l_line_status = INV_GLOBALS.G_TO_STATUS_PENDING_APPROVAL THEN
972: Inv_trolin_Util.Update_Row_Status(l_Line_id ,
973: INV_Globals.G_TO_STATUS_REJECTED);
974: END IF;
975: result := 'COMPLETE';
976:

Line 1089: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );

1085: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1086: itemkey => itemkey,
1087: aname => 'ORG_ID');
1088:
1089: l_trolin_tbl := INV_trolin_util.Get_Lines( l_header_id );
1090: l_total_lines := l_trolin_tbl.count;
1091:
1092:
1093: wf_engine.setItemAttrNumber( itemtype => itemtype,