DBA Data[Home] [Help]

APPS.INV_DEFAULT_TROLIN dependencies on INV_GLOBALS

Line 95: l_max_line_num number := NVL(INV_Globals.g_max_line_num, 0);

91: IS
92: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
93: --Bug #4347016
94: --Initialized Max Line Number to the global variable
95: l_max_line_num number := NVL(INV_Globals.g_max_line_num, 0);
96: BEGIN
97: /* inv_debug.message('In Get Line Num for header id:'||to_char(g_trolin_rec.header_id)); */
98: /* inv_debug.message('Prev header id:'||to_char(g_max_line_num_header_id)); */
99: IF g_trolin_rec.header_id IS NOT NULL AND

Line 108: If INV_Globals.g_max_line_num is null

104: INV_default_Trohdr.Load_Request_header(g_trolin_rec.header_id );
105: */
106:
107:
108: If INV_Globals.g_max_line_num is null
109: or g_max_line_num_header_id <> g_trolin_rec.header_id
110: Then
111:
112: SELECT nvl(max(line_number), 0)

Line 119: INV_Globals.g_max_line_num := l_max_line_num + 1;

115: WHERE header_id = g_trolin_rec.header_id;
116:
117:
118: g_max_line_num_header_id := g_trolin_rec.header_id;
119: INV_Globals.g_max_line_num := l_max_line_num + 1;
120:
121: End If;
122:
123: IF (l_max_line_num >= nvl(INV_Globals.g_max_line_num,0)) THEN

Line 123: IF (l_max_line_num >= nvl(INV_Globals.g_max_line_num,0)) THEN

119: INV_Globals.g_max_line_num := l_max_line_num + 1;
120:
121: End If;
122:
123: IF (l_max_line_num >= nvl(INV_Globals.g_max_line_num,0)) THEN
124:
125: INV_Globals.g_max_line_num := 1 + l_max_line_num;
126:
127: END IF;

Line 125: INV_Globals.g_max_line_num := 1 + l_max_line_num;

121: End If;
122:
123: IF (l_max_line_num >= nvl(INV_Globals.g_max_line_num,0)) THEN
124:
125: INV_Globals.g_max_line_num := 1 + l_max_line_num;
126:
127: END IF;
128:
129: /* inv_debug.message('D:'||to_char(INV_GLOBALS.g_max_line_num)); */

Line 129: /* inv_debug.message('D:'||to_char(INV_GLOBALS.g_max_line_num)); */

125: INV_Globals.g_max_line_num := 1 + l_max_line_num;
126:
127: END IF;
128:
129: /* inv_debug.message('D:'||to_char(INV_GLOBALS.g_max_line_num)); */
130: return INV_Globals.g_max_line_num;
131: end if;
132: /* inv_debug.message('Returning null'); */
133: return null;

Line 130: return INV_Globals.g_max_line_num;

126:
127: END IF;
128:
129: /* inv_debug.message('D:'||to_char(INV_GLOBALS.g_max_line_num)); */
130: return INV_Globals.g_max_line_num;
131: end if;
132: /* inv_debug.message('Returning null'); */
133: return null;
134: END Get_Line_Number;

Line 140: IF INV_globals.G_CALL_MODE = 'FORM'

136: FUNCTION Get_Line_Status
137: RETURN NUMBER
138: IS
139: BEGIN
140: IF INV_globals.G_CALL_MODE = 'FORM'
141: THEN
142: RETURN 1; /* Incomplete Status */
143: ELSE
144: RETURN 7; /* PRE-APPROVED */

Line 162: RETURN Inv_globals.g_org_id;

158: RETURN NUMBER
159: IS
160: BEGIN
161:
162: RETURN Inv_globals.g_org_id;
163:
164: END Get_Organization;
165:
166: FUNCTION Get_Project

Line 373: Return Inv_globals.g_org_id;

369: FUNCTION Get_To_Organization_Id
370: RETURN NUMBER
371: IS
372: BEGIN
373: Return Inv_globals.g_org_id;
374: END Get_To_Organization_Id;
375:
376:
377: FUNCTION Get_Primary_Quantity

Line 659: IF p_iteration > INV_GLOBALS.G_MAX_DEF_ITERATIONS THEN

655:
656: BEGIN
657: -- Check number of iterations.
658:
659: IF p_iteration > INV_GLOBALS.G_MAX_DEF_ITERATIONS THEN
660:
661: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
662: THEN
663:

Line 680: IF (g_trolin_rec.operation = inv_globals.g_opr_create)

676:
677: -- Default missing attributes.
678:
679: -- Changes for bug 6441724
680: IF (g_trolin_rec.operation = inv_globals.g_opr_create)
681: AND (g_trolin_rec.project_id = FND_API.G_MISS_NUM )
682: AND (g_trolin_rec.to_locator_id IS NOT NULL)
683: AND (g_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM)
684: THEN

Line 940: IF l_mov_order_type=INV_GLOBALS.g_move_order_put_away

936: SELECT move_order_type INTO l_mov_order_type
937: FROM mtl_txn_request_headers
938: WHERE header_id=g_trolin_rec.header_id;
939:
940: IF l_mov_order_type=INV_GLOBALS.g_move_order_put_away
941: THEN
942:
943: IF INV_Validate.Lot_Number(l_lot, l_org, l_item) = inv_validate.T THEN
944: INV_Trolin_Util.Clear_Dependent_Attr