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.OE_DBI_UTIL dependencies on OE_ORDER_UTIL

Line 68: IF (oe_order_util.g_header_rec.header_id is NOT NULL AND

64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67:
68: IF (oe_order_util.g_header_rec.header_id is NOT NULL AND
69: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM AND
70: oe_order_util.g_line_tbl.COUNT = 0 AND
71: oe_order_util.g_line_scredit_tbl.COUNT = 0 AND
72: oe_order_util. g_line_adj_tbl.COUNT = 0)

Line 69: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM AND

65: END IF;
66:
67:
68: IF (oe_order_util.g_header_rec.header_id is NOT NULL AND
69: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM AND
70: oe_order_util.g_line_tbl.COUNT = 0 AND
71: oe_order_util.g_line_scredit_tbl.COUNT = 0 AND
72: oe_order_util. g_line_adj_tbl.COUNT = 0)
73: THEN

Line 70: oe_order_util.g_line_tbl.COUNT = 0 AND

66:
67:
68: IF (oe_order_util.g_header_rec.header_id is NOT NULL AND
69: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM AND
70: oe_order_util.g_line_tbl.COUNT = 0 AND
71: oe_order_util.g_line_scredit_tbl.COUNT = 0 AND
72: oe_order_util. g_line_adj_tbl.COUNT = 0)
73: THEN
74:

Line 71: oe_order_util.g_line_scredit_tbl.COUNT = 0 AND

67:
68: IF (oe_order_util.g_header_rec.header_id is NOT NULL AND
69: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM AND
70: oe_order_util.g_line_tbl.COUNT = 0 AND
71: oe_order_util.g_line_scredit_tbl.COUNT = 0 AND
72: oe_order_util. g_line_adj_tbl.COUNT = 0)
73: THEN
74:
75: /* Some field in the header is changed and no line level changes */

Line 72: oe_order_util. g_line_adj_tbl.COUNT = 0)

68: IF (oe_order_util.g_header_rec.header_id is NOT NULL AND
69: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM AND
70: oe_order_util.g_line_tbl.COUNT = 0 AND
71: oe_order_util.g_line_scredit_tbl.COUNT = 0 AND
72: oe_order_util. g_line_adj_tbl.COUNT = 0)
73: THEN
74:
75: /* Some field in the header is changed and no line level changes */
76: IF l_debug_level > 0 THEN

Line 79: l_header_id := oe_order_util.g_header_rec.header_id;

75: /* Some field in the header is changed and no line level changes */
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'SOMETHING IN THE HEADER CHANGED' ) ;
78: END IF;
79: l_header_id := oe_order_util.g_header_rec.header_id;
80: IF l_debug_level > 0 THEN
81: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;
82: END IF;
83: l_header_last_update_date := oe_order_util.g_header_rec.last_update_date;

Line 83: l_header_last_update_date := oe_order_util.g_header_rec.last_update_date;

79: l_header_id := oe_order_util.g_header_rec.header_id;
80: IF l_debug_level > 0 THEN
81: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;
82: END IF;
83: l_header_last_update_date := oe_order_util.g_header_rec.last_update_date;
84:
85: ELSIF (oe_order_util.g_header_scredit_tbl.count > 0 AND
86: oe_order_util.g_line_tbl.COUNT = 0 AND
87: oe_order_util.g_line_scredit_tbl.COUNT = 0) THEN

Line 85: ELSIF (oe_order_util.g_header_scredit_tbl.count > 0 AND

81: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;
82: END IF;
83: l_header_last_update_date := oe_order_util.g_header_rec.last_update_date;
84:
85: ELSIF (oe_order_util.g_header_scredit_tbl.count > 0 AND
86: oe_order_util.g_line_tbl.COUNT = 0 AND
87: oe_order_util.g_line_scredit_tbl.COUNT = 0) THEN
88:
89: -- Some field in the header sales credit changed and no line level

Line 86: oe_order_util.g_line_tbl.COUNT = 0 AND

82: END IF;
83: l_header_last_update_date := oe_order_util.g_header_rec.last_update_date;
84:
85: ELSIF (oe_order_util.g_header_scredit_tbl.count > 0 AND
86: oe_order_util.g_line_tbl.COUNT = 0 AND
87: oe_order_util.g_line_scredit_tbl.COUNT = 0) THEN
88:
89: -- Some field in the header sales credit changed and no line level
90: -- changes

Line 87: oe_order_util.g_line_scredit_tbl.COUNT = 0) THEN

83: l_header_last_update_date := oe_order_util.g_header_rec.last_update_date;
84:
85: ELSIF (oe_order_util.g_header_scredit_tbl.count > 0 AND
86: oe_order_util.g_line_tbl.COUNT = 0 AND
87: oe_order_util.g_line_scredit_tbl.COUNT = 0) THEN
88:
89: -- Some field in the header sales credit changed and no line level
90: -- changes
91:

Line 95: I := oe_order_util.g_old_header_scredit_tbl.FIRST;

91:
92: IF l_debug_level > 0 THEN
93: oe_debug_pub.add( 'SOMETHING IN THE HEADER sales credit CHANGED' ) ;
94: END IF;
95: I := oe_order_util.g_old_header_scredit_tbl.FIRST;
96: l_header_id := oe_order_util.g_old_header_scredit_tbl(I).header_id;
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;
99: END IF;

Line 96: l_header_id := oe_order_util.g_old_header_scredit_tbl(I).header_id;

92: IF l_debug_level > 0 THEN
93: oe_debug_pub.add( 'SOMETHING IN THE HEADER sales credit CHANGED' ) ;
94: END IF;
95: I := oe_order_util.g_old_header_scredit_tbl.FIRST;
96: l_header_id := oe_order_util.g_old_header_scredit_tbl(I).header_id;
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;
99: END IF;
100:

Line 101: IF oe_order_util.g_header_scredit_tbl(I).last_update_date IS NULL THEN

97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;
99: END IF;
100:
101: IF oe_order_util.g_header_scredit_tbl(I).last_update_date IS NULL THEN
102: l_header_last_update_date :=
103: oe_order_util.g_old_header_scredit_tbl(I).last_update_date;
104: ELSE
105: l_header_last_update_date :=

Line 103: oe_order_util.g_old_header_scredit_tbl(I).last_update_date;

99: END IF;
100:
101: IF oe_order_util.g_header_scredit_tbl(I).last_update_date IS NULL THEN
102: l_header_last_update_date :=
103: oe_order_util.g_old_header_scredit_tbl(I).last_update_date;
104: ELSE
105: l_header_last_update_date :=
106: oe_order_util.g_header_scredit_tbl(I).last_update_date;
107: END IF;

Line 106: oe_order_util.g_header_scredit_tbl(I).last_update_date;

102: l_header_last_update_date :=
103: oe_order_util.g_old_header_scredit_tbl(I).last_update_date;
104: ELSE
105: l_header_last_update_date :=
106: oe_order_util.g_header_scredit_tbl(I).last_update_date;
107: END IF;
108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add( 'LAST UPDATE DATE OLD=' || l_header_last_update_date ) ;
110: END IF;

Line 112: ELSIF (oe_order_util.g_header_adj_tbl.count > 0 ) THEN

108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add( 'LAST UPDATE DATE OLD=' || l_header_last_update_date ) ;
110: END IF;
111:
112: ELSIF (oe_order_util.g_header_adj_tbl.count > 0 ) THEN
113:
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add( 'SOMETHING IN THE HEADER ADJUSTMENTS CHANGED' ) ;
116: END IF;

Line 117: I := oe_order_util.g_header_adj_tbl.FIRST;

113:
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add( 'SOMETHING IN THE HEADER ADJUSTMENTS CHANGED' ) ;
116: END IF;
117: I := oe_order_util.g_header_adj_tbl.FIRST;
118: l_header_id := oe_order_util.g_header_adj_tbl(I).header_id;
119:
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;

Line 118: l_header_id := oe_order_util.g_header_adj_tbl(I).header_id;

114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add( 'SOMETHING IN THE HEADER ADJUSTMENTS CHANGED' ) ;
116: END IF;
117: I := oe_order_util.g_header_adj_tbl.FIRST;
118: l_header_id := oe_order_util.g_header_adj_tbl(I).header_id;
119:
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;
122: END IF;

Line 124: l_header_last_update_date := oe_order_util.g_header_adj_tbl(I).last_update_date;

120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( 'JPN: HEADER ID' || L_HEADER_ID ) ;
122: END IF;
123:
124: l_header_last_update_date := oe_order_util.g_header_adj_tbl(I).last_update_date;
125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'LAST UPDATE DATE OLD=' || l_header_last_update_date ) ;
128: END IF;

Line 164: IF oe_order_util.g_line_tbl.COUNT > 0 THEN

160:
161: j := 1;
162:
163: -- Check if there are changed lines
164: IF oe_order_util.g_line_tbl.COUNT > 0 THEN
165:
166: l_dbi_rec.line_id.EXTEND(oe_order_util.g_line_tbl.COUNT);
167: l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);
168: l_dbi_rec.rec_exists_flag.EXTEND(oe_order_util.g_line_tbl.COUNT);

Line 166: l_dbi_rec.line_id.EXTEND(oe_order_util.g_line_tbl.COUNT);

162:
163: -- Check if there are changed lines
164: IF oe_order_util.g_line_tbl.COUNT > 0 THEN
165:
166: l_dbi_rec.line_id.EXTEND(oe_order_util.g_line_tbl.COUNT);
167: l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);
168: l_dbi_rec.rec_exists_flag.EXTEND(oe_order_util.g_line_tbl.COUNT);
169: l_dbi_rec.header_id.EXTEND(oe_order_util.g_line_tbl.COUNT); ---bug 7319732,7347663
170: I := oe_order_util.g_line_tbl.FIRST;

Line 167: l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);

163: -- Check if there are changed lines
164: IF oe_order_util.g_line_tbl.COUNT > 0 THEN
165:
166: l_dbi_rec.line_id.EXTEND(oe_order_util.g_line_tbl.COUNT);
167: l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);
168: l_dbi_rec.rec_exists_flag.EXTEND(oe_order_util.g_line_tbl.COUNT);
169: l_dbi_rec.header_id.EXTEND(oe_order_util.g_line_tbl.COUNT); ---bug 7319732,7347663
170: I := oe_order_util.g_line_tbl.FIRST;
171: l_header_id := oe_order_util.g_old_line_tbl(I).header_id;

Line 168: l_dbi_rec.rec_exists_flag.EXTEND(oe_order_util.g_line_tbl.COUNT);

164: IF oe_order_util.g_line_tbl.COUNT > 0 THEN
165:
166: l_dbi_rec.line_id.EXTEND(oe_order_util.g_line_tbl.COUNT);
167: l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);
168: l_dbi_rec.rec_exists_flag.EXTEND(oe_order_util.g_line_tbl.COUNT);
169: l_dbi_rec.header_id.EXTEND(oe_order_util.g_line_tbl.COUNT); ---bug 7319732,7347663
170: I := oe_order_util.g_line_tbl.FIRST;
171: l_header_id := oe_order_util.g_old_line_tbl(I).header_id;
172:

Line 169: l_dbi_rec.header_id.EXTEND(oe_order_util.g_line_tbl.COUNT); ---bug 7319732,7347663

165:
166: l_dbi_rec.line_id.EXTEND(oe_order_util.g_line_tbl.COUNT);
167: l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);
168: l_dbi_rec.rec_exists_flag.EXTEND(oe_order_util.g_line_tbl.COUNT);
169: l_dbi_rec.header_id.EXTEND(oe_order_util.g_line_tbl.COUNT); ---bug 7319732,7347663
170: I := oe_order_util.g_line_tbl.FIRST;
171: l_header_id := oe_order_util.g_old_line_tbl(I).header_id;
172:
173: IF l_debug_level > 0 THEN

Line 170: I := oe_order_util.g_line_tbl.FIRST;

166: l_dbi_rec.line_id.EXTEND(oe_order_util.g_line_tbl.COUNT);
167: l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);
168: l_dbi_rec.rec_exists_flag.EXTEND(oe_order_util.g_line_tbl.COUNT);
169: l_dbi_rec.header_id.EXTEND(oe_order_util.g_line_tbl.COUNT); ---bug 7319732,7347663
170: I := oe_order_util.g_line_tbl.FIRST;
171: l_header_id := oe_order_util.g_old_line_tbl(I).header_id;
172:
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add( 'IN LINE HEADER_ID= '||L_HEADER_ID, 1 ) ;

Line 171: l_header_id := oe_order_util.g_old_line_tbl(I).header_id;

167: l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);
168: l_dbi_rec.rec_exists_flag.EXTEND(oe_order_util.g_line_tbl.COUNT);
169: l_dbi_rec.header_id.EXTEND(oe_order_util.g_line_tbl.COUNT); ---bug 7319732,7347663
170: I := oe_order_util.g_line_tbl.FIRST;
171: l_header_id := oe_order_util.g_old_line_tbl(I).header_id;
172:
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add( 'IN LINE HEADER_ID= '||L_HEADER_ID, 1 ) ;
175: END IF;

Line 181: l_dbi_rec.line_id(j) :=oe_order_util.g_old_line_tbl(I).line_id;

177: IF l_debug_level > 0 THEN
178: oe_debug_pub.add( 'LOOP INDEX='|| I , 1 ) ;
179: END IF;
180:
181: l_dbi_rec.line_id(j) :=oe_order_util.g_old_line_tbl(I).line_id;
182: l_dbi_rec.rec_exists_flag(j) := 'N';
183: l_dbi_rec.header_id(j) :=oe_order_util.g_old_line_tbl(I).Header_id ;--bug 7319732,7347663
184: -- Set the value for line_index table to Y to indicate that record
185: -- already captured in l_dbi_rec.line_id for the given line_id.

Line 183: l_dbi_rec.header_id(j) :=oe_order_util.g_old_line_tbl(I).Header_id ;--bug 7319732,7347663

179: END IF;
180:
181: l_dbi_rec.line_id(j) :=oe_order_util.g_old_line_tbl(I).line_id;
182: l_dbi_rec.rec_exists_flag(j) := 'N';
183: l_dbi_rec.header_id(j) :=oe_order_util.g_old_line_tbl(I).Header_id ;--bug 7319732,7347663
184: -- Set the value for line_index table to Y to indicate that record
185: -- already captured in l_dbi_rec.line_id for the given line_id.
186: l_line_index_tbl(l_dbi_rec.line_id(j)) := 'Y';
187:

Line 188: IF oe_order_util.g_line_tbl(I).last_update_date IS NULL THEN

184: -- Set the value for line_index table to Y to indicate that record
185: -- already captured in l_dbi_rec.line_id for the given line_id.
186: l_line_index_tbl(l_dbi_rec.line_id(j)) := 'Y';
187:
188: IF oe_order_util.g_line_tbl(I).last_update_date IS NULL THEN
189: l_dbi_rec.last_update_date(j) :=
190: oe_order_util.g_old_line_tbl(I).last_update_date;
191: ELSE
192: l_dbi_rec.last_update_date(j) :=

Line 190: oe_order_util.g_old_line_tbl(I).last_update_date;

186: l_line_index_tbl(l_dbi_rec.line_id(j)) := 'Y';
187:
188: IF oe_order_util.g_line_tbl(I).last_update_date IS NULL THEN
189: l_dbi_rec.last_update_date(j) :=
190: oe_order_util.g_old_line_tbl(I).last_update_date;
191: ELSE
192: l_dbi_rec.last_update_date(j) :=
193: oe_order_util.g_line_tbl(I).last_update_date;
194: END IF;

Line 193: oe_order_util.g_line_tbl(I).last_update_date;

189: l_dbi_rec.last_update_date(j) :=
190: oe_order_util.g_old_line_tbl(I).last_update_date;
191: ELSE
192: l_dbi_rec.last_update_date(j) :=
193: oe_order_util.g_line_tbl(I).last_update_date;
194: END IF;
195:
196: IF l_debug_level > 0 THEN
197: oe_debug_pub.add( 'LINE_ID= '||l_dbi_rec.line_id(j) ) ;

Line 202: I := oe_order_util.g_line_tbl.NEXT(I);

198: oe_debug_pub.add( 'LAST UPDATE DATE=' || l_dbi_rec.last_update_date(j) ) ;
199: oe_debug_pub.add( 'LINE TBL HEADER ID=' || L_HEADER_ID ) ;
200: oe_debug_pub.add( 'LINE TBL HEADER ID=' ||l_dbi_rec.header_id(j)); --bug 7319732,7347663
201: END IF;
202: I := oe_order_util.g_line_tbl.NEXT(I);
203: j := j + 1;
204: END LOOP;
205: END IF;
206:

Line 213: IF oe_order_util.g_line_scredit_tbl.COUNT > 0 THEN

209: ELSE
210: j := 1;
211: END IF;
212:
213: IF oe_order_util.g_line_scredit_tbl.COUNT > 0 THEN
214:
215: I := oe_order_util.g_line_scredit_tbl.FIRST;
216: l_header_id := oe_order_util.g_old_line_scredit_tbl(I).header_id;
217: IF l_debug_level > 0 THEN

Line 215: I := oe_order_util.g_line_scredit_tbl.FIRST;

211: END IF;
212:
213: IF oe_order_util.g_line_scredit_tbl.COUNT > 0 THEN
214:
215: I := oe_order_util.g_line_scredit_tbl.FIRST;
216: l_header_id := oe_order_util.g_old_line_scredit_tbl(I).header_id;
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add( 'IN LINE SC HEADER_ID= '|| l_header_id, 1 ) ;
219: END IF;

Line 216: l_header_id := oe_order_util.g_old_line_scredit_tbl(I).header_id;

212:
213: IF oe_order_util.g_line_scredit_tbl.COUNT > 0 THEN
214:
215: I := oe_order_util.g_line_scredit_tbl.FIRST;
216: l_header_id := oe_order_util.g_old_line_scredit_tbl(I).header_id;
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add( 'IN LINE SC HEADER_ID= '|| l_header_id, 1 ) ;
219: END IF;
220:

Line 226: l_line_id :=oe_order_util.g_old_line_scredit_tbl(I).line_id;

222: IF l_debug_level > 0 THEN
223: oe_debug_pub.add( 'LOOP INDEX='|| I , 1 ) ;
224: END IF;
225:
226: l_line_id :=oe_order_util.g_old_line_scredit_tbl(I).line_id;
227: IF NOT l_line_index_tbl.EXISTS(to_char(l_line_id)) THEN
228:
229: l_dbi_rec.line_id.EXTEND;
230: l_dbi_rec.last_update_date.EXTEND;

Line 233: l_dbi_rec.Header_id(j) :=oe_order_util.g_old_line_scredit_tbl(I).header_id; --bug 7319732,7347663

229: l_dbi_rec.line_id.EXTEND;
230: l_dbi_rec.last_update_date.EXTEND;
231: l_dbi_rec.rec_exists_flag.EXTEND;
232: l_dbi_rec.Header_id.EXTEND ; ---bug 7319732 ,7347663
233: l_dbi_rec.Header_id(j) :=oe_order_util.g_old_line_scredit_tbl(I).header_id; --bug 7319732,7347663
234: l_dbi_rec.line_id(j) := oe_order_util.g_old_line_scredit_tbl(I).line_id;
235: l_dbi_rec.rec_exists_flag(j) := 'N';
236: -- Set the value for line_index table to Y to indicate that record
237: -- already captured in l_dbi_rec.line_id for the given line_id.

Line 234: l_dbi_rec.line_id(j) := oe_order_util.g_old_line_scredit_tbl(I).line_id;

230: l_dbi_rec.last_update_date.EXTEND;
231: l_dbi_rec.rec_exists_flag.EXTEND;
232: l_dbi_rec.Header_id.EXTEND ; ---bug 7319732 ,7347663
233: l_dbi_rec.Header_id(j) :=oe_order_util.g_old_line_scredit_tbl(I).header_id; --bug 7319732,7347663
234: l_dbi_rec.line_id(j) := oe_order_util.g_old_line_scredit_tbl(I).line_id;
235: l_dbi_rec.rec_exists_flag(j) := 'N';
236: -- Set the value for line_index table to Y to indicate that record
237: -- already captured in l_dbi_rec.line_id for the given line_id.
238: l_line_index_tbl(l_dbi_rec.line_id(j)) := 'Y';

Line 240: IF oe_order_util.g_line_scredit_tbl(I).last_update_date IS NULL

236: -- Set the value for line_index table to Y to indicate that record
237: -- already captured in l_dbi_rec.line_id for the given line_id.
238: l_line_index_tbl(l_dbi_rec.line_id(j)) := 'Y';
239:
240: IF oe_order_util.g_line_scredit_tbl(I).last_update_date IS NULL
241: THEN
242: l_dbi_rec.last_update_date(j) :=
243: oe_order_util.g_old_line_scredit_tbl(I).last_update_date;
244: ELSE

Line 243: oe_order_util.g_old_line_scredit_tbl(I).last_update_date;

239:
240: IF oe_order_util.g_line_scredit_tbl(I).last_update_date IS NULL
241: THEN
242: l_dbi_rec.last_update_date(j) :=
243: oe_order_util.g_old_line_scredit_tbl(I).last_update_date;
244: ELSE
245: l_dbi_rec.last_update_date(j) :=
246: oe_order_util.g_line_scredit_tbl(I).last_update_date;
247:

Line 246: oe_order_util.g_line_scredit_tbl(I).last_update_date;

242: l_dbi_rec.last_update_date(j) :=
243: oe_order_util.g_old_line_scredit_tbl(I).last_update_date;
244: ELSE
245: l_dbi_rec.last_update_date(j) :=
246: oe_order_util.g_line_scredit_tbl(I).last_update_date;
247:
248: END IF;
249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add( 'LINE_ID= '||l_dbi_rec.line_id(j) ) ;

Line 256: I := oe_order_util.g_line_scredit_tbl.NEXT(I);

252: END IF;
253: j := j + 1;
254:
255: END IF;
256: I := oe_order_util.g_line_scredit_tbl.NEXT(I);
257: END LOOP;
258:
259: END IF;
260:

Line 267: IF oe_order_util.g_line_adj_tbl.COUNT >0 THEN

263: ELSE
264: j := 1;
265: END IF;
266:
267: IF oe_order_util.g_line_adj_tbl.COUNT >0 THEN
268:
269: I := oe_order_util.g_line_adj_tbl.FIRST;
270: l_header_id := oe_order_util.g_old_line_adj_tbl(I).header_id;
271:

Line 269: I := oe_order_util.g_line_adj_tbl.FIRST;

265: END IF;
266:
267: IF oe_order_util.g_line_adj_tbl.COUNT >0 THEN
268:
269: I := oe_order_util.g_line_adj_tbl.FIRST;
270: l_header_id := oe_order_util.g_old_line_adj_tbl(I).header_id;
271:
272: IF l_debug_level > 0 THEN
273: oe_debug_pub.add( 'IN LINE PRICE ADJUSTMENTS HEADER_ID= '|| l_header_id, 1 ) ;

Line 270: l_header_id := oe_order_util.g_old_line_adj_tbl(I).header_id;

266:
267: IF oe_order_util.g_line_adj_tbl.COUNT >0 THEN
268:
269: I := oe_order_util.g_line_adj_tbl.FIRST;
270: l_header_id := oe_order_util.g_old_line_adj_tbl(I).header_id;
271:
272: IF l_debug_level > 0 THEN
273: oe_debug_pub.add( 'IN LINE PRICE ADJUSTMENTS HEADER_ID= '|| l_header_id, 1 ) ;
274: END IF;

Line 280: l_line_id :=oe_order_util.g_old_line_adj_tbl(I).line_id;

276: WHILE I IS NOT NULL LOOP
277: IF l_debug_level > 0 THEN
278: oe_debug_pub.add( 'PA LOOP INDEX='|| I , 1 ) ;
279: END IF;
280: l_line_id :=oe_order_util.g_old_line_adj_tbl(I).line_id;
281:
282: IF NOT l_line_index_tbl.EXISTS(to_char(l_line_id)) THEN
283:
284: l_dbi_rec.line_id.EXTEND;

Line 288: l_dbi_rec.Header_id(j) :=oe_order_util.g_old_line_adj_tbl(I).header_id; --bug 7319732 ,7347663

284: l_dbi_rec.line_id.EXTEND;
285: l_dbi_rec.last_update_date.EXTEND;
286: l_dbi_rec.rec_exists_flag.EXTEND;
287: l_dbi_rec.Header_id.EXTEND ; ---bug 7319732 ,7347663
288: l_dbi_rec.Header_id(j) :=oe_order_util.g_old_line_adj_tbl(I).header_id; --bug 7319732 ,7347663
289: l_dbi_rec.line_id(j) := oe_order_util.g_old_line_adj_tbl(I).line_id;
290: l_dbi_rec.rec_exists_flag(j) := 'N';
291: -- Set the value for line_index table to Y to indicate that record
292: -- already captured in l_dbi_rec.line_id for the given line_id.

Line 289: l_dbi_rec.line_id(j) := oe_order_util.g_old_line_adj_tbl(I).line_id;

285: l_dbi_rec.last_update_date.EXTEND;
286: l_dbi_rec.rec_exists_flag.EXTEND;
287: l_dbi_rec.Header_id.EXTEND ; ---bug 7319732 ,7347663
288: l_dbi_rec.Header_id(j) :=oe_order_util.g_old_line_adj_tbl(I).header_id; --bug 7319732 ,7347663
289: l_dbi_rec.line_id(j) := oe_order_util.g_old_line_adj_tbl(I).line_id;
290: l_dbi_rec.rec_exists_flag(j) := 'N';
291: -- Set the value for line_index table to Y to indicate that record
292: -- already captured in l_dbi_rec.line_id for the given line_id.
293: l_line_index_tbl(l_dbi_rec.line_id(j)) := 'Y';

Line 295: IF oe_order_util.g_line_adj_tbl(I).last_update_date IS NULL

291: -- Set the value for line_index table to Y to indicate that record
292: -- already captured in l_dbi_rec.line_id for the given line_id.
293: l_line_index_tbl(l_dbi_rec.line_id(j)) := 'Y';
294:
295: IF oe_order_util.g_line_adj_tbl(I).last_update_date IS NULL
296: THEN
297: l_dbi_rec.last_update_date(J) :=
298: oe_order_util.g_old_line_adj_tbl(I).last_update_date;
299: ELSE

Line 298: oe_order_util.g_old_line_adj_tbl(I).last_update_date;

294:
295: IF oe_order_util.g_line_adj_tbl(I).last_update_date IS NULL
296: THEN
297: l_dbi_rec.last_update_date(J) :=
298: oe_order_util.g_old_line_adj_tbl(I).last_update_date;
299: ELSE
300: l_dbi_rec.last_update_date(J) :=
301: oe_order_util.g_line_adj_tbl(I).last_update_date;
302:

Line 301: oe_order_util.g_line_adj_tbl(I).last_update_date;

297: l_dbi_rec.last_update_date(J) :=
298: oe_order_util.g_old_line_adj_tbl(I).last_update_date;
299: ELSE
300: l_dbi_rec.last_update_date(J) :=
301: oe_order_util.g_line_adj_tbl(I).last_update_date;
302:
303: END IF;
304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add( 'LINE_ID= '||l_dbi_rec.line_id(j) ) ;

Line 311: I := oe_order_util.g_line_adj_tbl.NEXT(I);

307: END IF;
308: j := j + 1;
309:
310: END IF;
311: I := oe_order_util.g_line_adj_tbl.NEXT(I);
312:
313: END LOOP;
314:
315: END IF;