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_BLANKET_LINE_SECURITY dependencies on OE_GLOBALS

Line 25: l_ctr NUMBER := OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count;

21: l_result NUMBER;
22: l_column_name VARCHAR2(30);
23: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');
24: l_code_level VARCHAR2(6) := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
25: l_ctr NUMBER := OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count;
26: l_ind NUMBER;
27: l_history_captured BOOLEAN; -- Is history captured for this line?
28:
29: BEGIN

Line 115: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN

111: l_history_captured := FALSE;
112: IF x_on_operation_action = 1 THEN
113: BEGIN
114: FOR l_ind in 1..l_ctr LOOP
115: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN
116: l_history_captured := TRUE;
117: END IF;
118: END LOOP;
119: EXCEPTION WHEN OTHERS THEN

Line 124: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

120: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
121: NULL;
122: END;
123: IF NOT l_history_captured THEN
124: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
125: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
126: oe_debug_pub.add('Line Security, attribute change requires reason',1);
127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

Line 125: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';

121: NULL;
122: END;
123: IF NOT l_history_captured THEN
124: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
125: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
126: oe_debug_pub.add('Line Security, attribute change requires reason',1);
127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
129: END IF;

Line 127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

123: IF NOT l_history_captured THEN
124: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
125: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
126: oe_debug_pub.add('Line Security, attribute change requires reason',1);
127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
129: END IF;
130: ELSIF x_on_operation_action = 2 THEN
131: BEGIN

Line 128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

124: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
125: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
126: oe_debug_pub.add('Line Security, attribute change requires reason',1);
127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
129: END IF;
130: ELSIF x_on_operation_action = 2 THEN
131: BEGIN
132: FOR l_ind in 1..l_ctr LOOP

Line 133: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN

129: END IF;
130: ELSIF x_on_operation_action = 2 THEN
131: BEGIN
132: FOR l_ind in 1..l_ctr LOOP
133: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN
134: l_history_captured := TRUE;
135: END IF;
136: END LOOP;
137: EXCEPTION WHEN OTHERS THEN

Line 142: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

138: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
139: NULL;
140: END;
141: IF NOT l_history_captured THEN
142: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
143: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
144: oe_debug_pub.add('Line Security, attribute change requires history',7);
145: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
146: oe_debug_pub.add('Line Security, attribute change requires history',7);

Line 143: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';

139: NULL;
140: END;
141: IF NOT l_history_captured THEN
142: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
143: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
144: oe_debug_pub.add('Line Security, attribute change requires history',7);
145: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
146: oe_debug_pub.add('Line Security, attribute change requires history',7);
147: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 145: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

141: IF NOT l_history_captured THEN
142: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
143: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
144: oe_debug_pub.add('Line Security, attribute change requires history',7);
145: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
146: oe_debug_pub.add('Line Security, attribute change requires history',7);
147: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
148: END IF;
149: END IF;

Line 147: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

143: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
144: oe_debug_pub.add('Line Security, attribute change requires history',7);
145: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
146: oe_debug_pub.add('Line Security, attribute change requires history',7);
147: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
148: END IF;
149: END IF;
150: END IF;
151: END IF;

Line 160: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN

156: l_history_captured := FALSE;
157: IF x_on_operation_action = 1 THEN
158: BEGIN
159: FOR l_ind in 1..l_ctr LOOP
160: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN
161: l_history_captured := TRUE;
162: END IF;
163: END LOOP;
164: EXCEPTION WHEN OTHERS THEN

Line 169: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

165: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
166: NULL;
167: END;
168: IF NOT l_history_captured THEN
169: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
170: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
171: oe_debug_pub.add('Line Security, attribute change requires reason',1);
172: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
173: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

Line 170: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';

166: NULL;
167: END;
168: IF NOT l_history_captured THEN
169: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
170: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
171: oe_debug_pub.add('Line Security, attribute change requires reason',1);
172: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
173: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
174: END IF;

Line 172: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

168: IF NOT l_history_captured THEN
169: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
170: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
171: oe_debug_pub.add('Line Security, attribute change requires reason',1);
172: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
173: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
174: END IF;
175: ELSIF x_on_operation_action = 2 THEN
176: BEGIN

Line 173: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';

169: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
170: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
171: oe_debug_pub.add('Line Security, attribute change requires reason',1);
172: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
173: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
174: END IF;
175: ELSIF x_on_operation_action = 2 THEN
176: BEGIN
177: FOR l_ind in 1..l_ctr LOOP

Line 178: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN

174: END IF;
175: ELSIF x_on_operation_action = 2 THEN
176: BEGIN
177: FOR l_ind in 1..l_ctr LOOP
178: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr).LINE_ID = p_record.line_id THEN
179: l_history_captured := TRUE;
180: END IF;
181: END LOOP;
182: EXCEPTION WHEN OTHERS THEN

Line 187: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;

183: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
184: NULL;
185: END;
186: IF NOT l_history_captured THEN
187: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
188: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
189: oe_debug_pub.add('Line Security, attribute change requires history',7);
190: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
191: oe_debug_pub.add('Line Security, attribute change requires history',7);

Line 188: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';

184: NULL;
185: END;
186: IF NOT l_history_captured THEN
187: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
188: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
189: oe_debug_pub.add('Line Security, attribute change requires history',7);
190: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
191: oe_debug_pub.add('Line Security, attribute change requires history',7);
192: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

Line 190: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then

186: IF NOT l_history_captured THEN
187: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
188: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
189: oe_debug_pub.add('Line Security, attribute change requires history',7);
190: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
191: oe_debug_pub.add('Line Security, attribute change requires history',7);
192: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
193: END IF;
194: END IF;

Line 192: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';

188: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
189: oe_debug_pub.add('Line Security, attribute change requires history',7);
190: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
191: oe_debug_pub.add('Line Security, attribute change requires history',7);
192: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
193: END IF;
194: END IF;
195: END IF;
196: END IF;

Line 2193: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

2189:
2190: -- Initializing return status to SUCCESS
2191: x_return_status := FND_API.G_RET_STS_SUCCESS;
2192:
2193: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2194: l_operation := OE_PC_GLOBALS.CREATE_OP;
2195: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2196: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

Line 2195: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2191: x_return_status := FND_API.G_RET_STS_SUCCESS;
2192:
2193: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2194: l_operation := OE_PC_GLOBALS.CREATE_OP;
2195: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2196: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2198: l_operation := OE_PC_GLOBALS.DELETE_OP;
2199: ELSE

Line 2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

2193: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2194: l_operation := OE_PC_GLOBALS.CREATE_OP;
2195: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2196: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2197: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2198: l_operation := OE_PC_GLOBALS.DELETE_OP;
2199: ELSE
2200: oe_debug_pub.add('Invalid operation',1);
2201: RAISE FND_API.G_EXC_ERROR;

Line 2258: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

2254: -- Initializing out result to NOT CONSTRAINED
2255: x_result := OE_PC_GLOBALS.NO;
2256:
2257: -- Get the operation code to be passed to the security framework API
2258: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2259:
2260: -- Bug 2639336 : if the order source is Copy then skip the Attribute
2261: -- level check
2262: -- IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY

Line 2262: -- IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY

2258: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2259:
2260: -- Bug 2639336 : if the order source is Copy then skip the Attribute
2261: -- level check
2262: -- IF p_LINE_rec.source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_COPY
2263: -- THEN
2264: -- RETURN;
2265: -- ELSE
2266: l_operation := OE_PC_GLOBALS.CREATE_OP;

Line 2282: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2278: THEN
2279: RETURN;
2280: END IF;
2281:
2282: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2283: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2284: ELSE
2285: oe_debug_pub.add('Invalid operation',1);
2286: RAISE FND_API.G_EXC_ERROR;

Line 2300: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id,p_old_line_rec.accounting_rule_id) THEN

2296: -- Compare the new and old entity records and
2297: -- check constraints for all the changed attributes.
2298:
2299: IF p_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
2300: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id,p_old_line_rec.accounting_rule_id) THEN
2301:
2302: l_result := ACCOUNTING_RULE
2303: (p_operation => l_operation
2304: ,p_record => l_rowtype_rec

Line 2316: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.cust_po_number,p_old_line_rec.cust_po_number) THEN

2312:
2313: END IF;
2314:
2315: IF p_line_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
2316: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.cust_po_number,p_old_line_rec.cust_po_number) THEN
2317:
2318: l_result := CUST_PO_NUMBER
2319: (p_operation => l_operation
2320: ,p_record => l_rowtype_rec

Line 2332: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,p_old_line_rec.deliver_to_org_id) THEN

2328:
2329: END IF;
2330:
2331: IF p_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2332: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id,p_old_line_rec.deliver_to_org_id) THEN
2333:
2334: l_result := DELIVER_TO_ORG
2335: (p_operation => l_operation
2336: ,p_record => l_rowtype_rec

Line 2348: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code,p_old_line_rec.freight_terms_code) THEN

2344:
2345: END IF;
2346:
2347: IF p_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
2348: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code,p_old_line_rec.freight_terms_code) THEN
2349:
2350: l_result := FREIGHT_TERMS
2351: (p_operation => l_operation
2352: ,p_record => l_rowtype_rec

Line 2364: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) THEN

2360:
2361: END IF;
2362:
2363: IF p_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN NULL;
2364: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.inventory_item_id,p_old_line_rec.inventory_item_id) THEN
2365:
2366: l_result := INVENTORY_ITEM
2367: (p_operation => l_operation
2368: ,p_record => l_rowtype_rec

Line 2380: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id) THEN

2376:
2377: END IF;
2378:
2379: IF p_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2380: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id,p_old_line_rec.invoice_to_org_id) THEN
2381:
2382: l_result := INVOICE_TO_ORG
2383: (p_operation => l_operation
2384: ,p_record => l_rowtype_rec

Line 2396: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id,p_old_line_rec.invoicing_rule_id) THEN

2392:
2393: END IF;
2394:
2395: IF p_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
2396: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id,p_old_line_rec.invoicing_rule_id) THEN
2397:
2398: l_result := INVOICING_RULE
2399: (p_operation => l_operation
2400: ,p_record => l_rowtype_rec

Line 2412: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_identifier_type,p_old_line_rec.item_identifier_type) THEN

2408:
2409: END IF;
2410:
2411: IF p_line_rec.item_identifier_type = FND_API.G_MISS_CHAR THEN NULL;
2412: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.item_identifier_type,p_old_line_rec.item_identifier_type) THEN
2413:
2414: l_result := ITEM_IDENTIFIER_TYPE
2415: (p_operation => l_operation
2416: ,p_record => l_rowtype_rec

Line 2428: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,p_old_line_rec.line_number) THEN

2424:
2425: END IF;
2426:
2427: IF p_line_rec.line_number = FND_API.G_MISS_NUM THEN NULL;
2428: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,p_old_line_rec.line_number) THEN
2429:
2430: l_result := LINE_NUMBER
2431: (p_operation => l_operation
2432: ,p_record => l_rowtype_rec

Line 2444: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id) THEN

2440:
2441: END IF;
2442:
2443: IF p_line_rec.line_type_id = FND_API.G_MISS_NUM THEN NULL;
2444: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id) THEN
2445:
2446: l_result := LINE_TYPE
2447: (p_operation => l_operation
2448: ,p_record => l_rowtype_rec

Line 2460: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) THEN

2456:
2457: END IF;
2458:
2459: IF p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR THEN NULL;
2460: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.order_quantity_uom,p_old_line_rec.order_quantity_uom) THEN
2461:
2462: l_result := ORDER_QUANTITY_UOM
2463: (p_operation => l_operation
2464: ,p_record => l_rowtype_rec

Line 2476: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.packing_instructions,p_old_line_rec.packing_instructions) THEN

2472:
2473: END IF;
2474:
2475: IF p_line_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
2476: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.packing_instructions,p_old_line_rec.packing_instructions) THEN
2477:
2478: l_result := PACKING_INSTRUCTIONS
2479: (p_operation => l_operation
2480: ,p_record => l_rowtype_rec

Line 2492: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id,p_old_line_rec.payment_term_id) THEN

2488:
2489: END IF;
2490:
2491: IF p_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
2492: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id,p_old_line_rec.payment_term_id) THEN
2493:
2494: l_result := PAYMENT_TERM
2495: (p_operation => l_operation
2496: ,p_record => l_rowtype_rec

Line 2508: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN

2504:
2505: END IF;
2506:
2507: IF p_line_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
2508: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN
2509:
2510: l_result := PRICE_LIST
2511: (p_operation => l_operation
2512: ,p_record => l_rowtype_rec

Line 2524: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.salesrep_id,p_old_line_rec.salesrep_id) THEN

2520:
2521: END IF;
2522:
2523: IF p_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
2524: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.salesrep_id,p_old_line_rec.salesrep_id) THEN
2525:
2526: l_result := SALESREP
2527: (p_operation => l_operation
2528: ,p_record => l_rowtype_rec

Line 2540: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_instructions,p_old_line_rec.shipping_instructions) THEN

2536:
2537: END IF;
2538:
2539: IF p_line_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
2540: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_instructions,p_old_line_rec.shipping_instructions) THEN
2541:
2542: l_result := SHIPPING_INSTRUCTIONS
2543: (p_operation => l_operation
2544: ,p_record => l_rowtype_rec

Line 2556: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code,p_old_line_rec.shipping_method_code) THEN

2552:
2553: END IF;
2554:
2555: IF p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
2556: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code,p_old_line_rec.shipping_method_code) THEN
2557:
2558: l_result := SHIPPING_METHOD
2559: (p_operation => l_operation
2560: ,p_record => l_rowtype_rec

Line 2572: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id) THEN

2568:
2569: END IF;
2570:
2571: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
2572: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id,p_old_line_rec.ship_from_org_id) THEN
2573:
2574: l_result := SHIP_FROM_ORG
2575: (p_operation => l_operation
2576: ,p_record => l_rowtype_rec

Line 2588: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id) THEN

2584:
2585: END IF;
2586:
2587: IF p_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2588: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id) THEN
2589:
2590: l_result := SHIP_TO_ORG
2591: (p_operation => l_operation
2592: ,p_record => l_rowtype_rec

Line 2604: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id) THEN

2600:
2601: END IF;
2602:
2603: IF p_line_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2604: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id,p_old_line_rec.sold_to_org_id) THEN
2605:
2606: l_result := SOLD_TO_ORG
2607: (p_operation => l_operation
2608: ,p_record => l_rowtype_rec

Line 2620: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price) THEN

2616:
2617: END IF;
2618:
2619: IF p_line_rec.unit_list_price = FND_API.G_MISS_NUM THEN NULL;
2620: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price) THEN
2621:
2622: l_result := UNIT_LIST_PRICE
2623: (p_operation => l_operation
2624: ,p_record => l_rowtype_rec

Line 2636: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.start_date_active,p_old_line_rec.start_date_active) THEN

2632:
2633: END IF;
2634:
2635: IF p_line_rec.start_date_active = FND_API.G_MISS_DATE THEN NULL;
2636: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.start_date_active,p_old_line_rec.start_date_active) THEN
2637:
2638: l_result := START_DATE_ACTIVE
2639: (p_operation => l_operation
2640: ,p_record => l_rowtype_rec

Line 2652: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.end_date_active,p_old_line_rec.end_date_active) THEN

2648:
2649: END IF;
2650:
2651: IF p_line_rec.end_date_active = FND_API.G_MISS_DATE THEN NULL;
2652: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.end_date_active,p_old_line_rec.end_date_active) THEN
2653:
2654: l_result := END_DATE_ACTIVE
2655: (p_operation => l_operation
2656: ,p_record => l_rowtype_rec

Line 2668: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.preferred_grade,p_old_line_rec.preferred_grade) THEN

2664:
2665: END IF;
2666:
2667: IF p_line_rec.preferred_grade = FND_API.G_MISS_CHAR THEN NULL;
2668: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.preferred_grade,p_old_line_rec.preferred_grade) THEN
2669:
2670: l_result := PREFERRED_GRADE
2671: (p_operation => l_operation
2672: ,p_record => l_rowtype_rec

Line 2684: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_ship_to_flag,p_old_line_rec.enforce_ship_to_flag) THEN

2680:
2681: END IF;
2682:
2683: IF p_line_rec.enforce_ship_to_flag = FND_API.G_MISS_CHAR THEN NULL;
2684: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_ship_to_flag,p_old_line_rec.enforce_ship_to_flag) THEN
2685:
2686: l_result := ENFORCE_SHIP_TO_FLAG
2687: (p_operation => l_operation
2688: ,p_record => l_rowtype_rec

Line 2700: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_freight_term_flag,p_old_line_rec.enforce_freight_term_flag) THEN

2696:
2697: END IF;
2698:
2699: IF p_line_rec.enforce_freight_term_flag = FND_API.G_MISS_CHAR THEN NULL;
2700: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_freight_term_flag,p_old_line_rec.enforce_freight_term_flag) THEN
2701:
2702: l_result := ENFORCE_FREIGHT_TERM_FLAG
2703: (p_operation => l_operation
2704: ,p_record => l_rowtype_rec

Line 2716: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_shipping_method_flag,p_old_line_rec.enforce_shipping_method_flag) THEN

2712:
2713: END IF;
2714:
2715: IF p_line_rec.enforce_shipping_method_flag = FND_API.G_MISS_CHAR THEN NULL;
2716: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_shipping_method_flag,p_old_line_rec.enforce_shipping_method_flag) THEN
2717:
2718: l_result := ENFORCE_SHIPPING_METHOD_FLAG
2719: (p_operation => l_operation
2720: ,p_record => l_rowtype_rec

Line 2732: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_invoice_to_flag,p_old_line_rec.enforce_invoice_to_flag) THEN

2728:
2729: END IF;
2730:
2731: IF p_line_rec.enforce_invoice_to_flag = FND_API.G_MISS_CHAR THEN NULL;
2732: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_invoice_to_flag,p_old_line_rec.enforce_invoice_to_flag) THEN
2733:
2734: l_result := ENFORCE_INVOICE_TO_FLAG
2735: (p_operation => l_operation
2736: ,p_record => l_rowtype_rec

Line 2748: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_price_list_flag,p_old_line_rec.enforce_price_list_flag) THEN

2744:
2745: END IF;
2746:
2747: IF p_line_rec.enforce_price_list_flag = FND_API.G_MISS_CHAR THEN NULL;
2748: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_price_list_flag,p_old_line_rec.enforce_price_list_flag) THEN
2749:
2750: l_result := ENFORCE_PRICE_LIST_FLAG
2751: (p_operation => l_operation
2752: ,p_record => l_rowtype_rec

Line 2764: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_payment_term_flag,p_old_line_rec.enforce_payment_term_flag) THEN

2760:
2761: END IF;
2762:
2763: IF p_line_rec.enforce_payment_term_flag = FND_API.G_MISS_CHAR THEN NULL;
2764: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_payment_term_flag,p_old_line_rec.enforce_payment_term_flag) THEN
2765:
2766: l_result := ENFORCE_PAYMENT_TERM_FLAG
2767: (p_operation => l_operation
2768: ,p_record => l_rowtype_rec

Line 2780: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_accounting_rule_flag,p_old_line_rec.enforce_accounting_rule_flag) THEN

2776:
2777: END IF;
2778:
2779: IF p_line_rec.enforce_accounting_rule_flag = FND_API.G_MISS_CHAR THEN NULL;
2780: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_accounting_rule_flag,p_old_line_rec.enforce_accounting_rule_flag) THEN
2781:
2782: l_result := ENFORCE_ACCOUNTING_RULE_FLAG
2783: (p_operation => l_operation
2784: ,p_record => l_rowtype_rec

Line 2796: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_invoicing_rule_flag,p_old_line_rec.enforce_invoicing_rule_flag) THEN

2792:
2793: END IF;
2794:
2795: IF p_line_rec.enforce_invoicing_rule_flag = FND_API.G_MISS_CHAR THEN NULL;
2796: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.enforce_invoicing_rule_flag,p_old_line_rec.enforce_invoicing_rule_flag) THEN
2797:
2798: l_result := ENFORCE_INVOICING_RULE_FLAG
2799: (p_operation => l_operation
2800: ,p_record => l_rowtype_rec

Line 2812: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_min_amount,p_old_line_rec.blanket_min_amount) THEN

2808:
2809: END IF;
2810:
2811: IF p_line_rec.blanket_min_amount = FND_API.G_MISS_NUM THEN NULL;
2812: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_min_amount,p_old_line_rec.blanket_min_amount) THEN
2813:
2814: l_result := BLANKET_LINE_MIN_AMOUNT
2815: (p_operation => l_operation
2816: ,p_record => l_rowtype_rec

Line 2828: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_max_amount,p_old_line_rec.blanket_max_amount) THEN

2824:
2825: END IF;
2826:
2827: IF p_line_rec.blanket_max_amount = FND_API.G_MISS_NUM THEN NULL;
2828: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_max_amount,p_old_line_rec.blanket_max_amount) THEN
2829:
2830: l_result := BLANKET_LINE_MAX_AMOUNT
2831: (p_operation => l_operation
2832: ,p_record => l_rowtype_rec

Line 2844: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_min_quantity,p_old_line_rec.blanket_min_quantity) THEN

2840:
2841: END IF;
2842:
2843: IF p_line_rec.blanket_min_quantity = FND_API.G_MISS_NUM THEN NULL;
2844: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_min_quantity,p_old_line_rec.blanket_min_quantity) THEN
2845:
2846: l_result := BLANKET_MIN_QUANTITY
2847: (p_operation => l_operation
2848: ,p_record => l_rowtype_rec

Line 2860: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_max_quantity,p_old_line_rec.blanket_max_quantity) THEN

2856:
2857: END IF;
2858:
2859: IF p_line_rec.blanket_max_quantity = FND_API.G_MISS_NUM THEN NULL;
2860: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_max_quantity,p_old_line_rec.blanket_max_quantity) THEN
2861:
2862: l_result := BLANKET_MAX_QUANTITY
2863: (p_operation => l_operation
2864: ,p_record => l_rowtype_rec

Line 2876: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.min_release_amount,p_old_line_rec.min_release_amount) THEN

2872:
2873: END IF;
2874:
2875: IF p_line_rec.min_release_amount = FND_API.G_MISS_NUM THEN NULL;
2876: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.min_release_amount,p_old_line_rec.min_release_amount) THEN
2877:
2878: l_result := MIN_RELEASE_AMOUNT
2879: (p_operation => l_operation
2880: ,p_record => l_rowtype_rec

Line 2892: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.max_release_amount,p_old_line_rec.max_release_amount) THEN

2888:
2889: END IF;
2890:
2891: IF p_line_rec.max_release_amount = FND_API.G_MISS_NUM THEN NULL;
2892: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.max_release_amount,p_old_line_rec.max_release_amount) THEN
2893:
2894: l_result := MAX_RELEASE_AMOUNT
2895: (p_operation => l_operation
2896: ,p_record => l_rowtype_rec

Line 2908: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.min_release_quantity,p_old_line_rec.min_release_quantity) THEN

2904:
2905: END IF;
2906:
2907: IF p_line_rec.min_release_quantity = FND_API.G_MISS_NUM THEN NULL;
2908: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.min_release_quantity,p_old_line_rec.min_release_quantity) THEN
2909:
2910: l_result := MIN_RELEASE_QUANTITY
2911: (p_operation => l_operation
2912: ,p_record => l_rowtype_rec

Line 2924: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.max_release_quantity,p_old_line_rec.max_release_quantity) THEN

2920:
2921: END IF;
2922:
2923: IF p_line_rec.max_release_quantity = FND_API.G_MISS_NUM THEN NULL;
2924: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.max_release_quantity,p_old_line_rec.max_release_quantity) THEN
2925:
2926: l_result := MAX_RELEASE_QUANTITY
2927: (p_operation => l_operation
2928: ,p_record => l_rowtype_rec

Line 2940: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.override_blanket_controls_flag,p_old_line_rec.override_blanket_controls_flag) THEN

2936:
2937: END IF;
2938:
2939: IF p_line_rec.override_blanket_controls_flag = FND_API.G_MISS_CHAR THEN NULL;
2940: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.override_blanket_controls_flag,p_old_line_rec.override_blanket_controls_flag) THEN
2941:
2942: l_result := OVERRIDE_BLANKET_CONTROLS_FLAG
2943: (p_operation => l_operation
2944: ,p_record => l_rowtype_rec

Line 2956: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.override_release_controls_flag,p_old_line_rec.override_release_controls_flag) THEN

2952:
2953: END IF;
2954:
2955: IF p_line_rec.override_release_controls_flag = FND_API.G_MISS_CHAR THEN NULL;
2956: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.override_release_controls_flag,p_old_line_rec.override_release_controls_flag) THEN
2957:
2958: l_result := OVERRIDE_RELEASE_CONTROLS_FLAG
2959: (p_operation => l_operation
2960: ,p_record => l_rowtype_rec

Line 2972: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,p_old_line_rec.pricing_uom) THEN

2968:
2969: END IF;
2970:
2971: IF p_line_rec.pricing_uom = FND_API.G_MISS_CHAR THEN NULL;
2972: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,p_old_line_rec.pricing_uom) THEN
2973:
2974: l_result := PRICING_QUANTITY_UOM
2975: (p_operation => l_operation
2976: ,p_record => l_rowtype_rec

Line 2988: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_percent,p_old_line_rec.discount_percent) THEN

2984:
2985: END IF;
2986:
2987: IF p_line_rec.discount_percent = FND_API.G_MISS_NUM THEN NULL;
2988: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_percent,p_old_line_rec.discount_percent) THEN
2989:
2990: l_result := DISCOUNT_PERCENT
2991: (p_operation => l_operation
2992: ,p_record => l_rowtype_rec

Line 3004: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_amount,p_old_line_rec.discount_amount) THEN

3000:
3001: END IF;
3002:
3003: IF p_line_rec.discount_amount = FND_API.G_MISS_NUM THEN NULL;
3004: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.discount_amount,p_old_line_rec.discount_amount) THEN
3005:
3006: l_result := DISCOUNT_AMOUNT
3007: (p_operation => l_operation
3008: ,p_record => l_rowtype_rec

Line 3021: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.CONTEXT,p_old_line_rec.CONTEXT )

3017: END IF;
3018:
3019: --bug6531947
3020: IF p_line_rec.CONTEXT = FND_API.G_MISS_CHAR THEN NULL;
3021: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.CONTEXT,p_old_line_rec.CONTEXT )
3022: THEN
3023: l_result := CONTEXT
3024: (p_operation => l_operation
3025: ,p_record => l_rowtype_rec

Line 3037: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE1,p_old_line_rec.ATTRIBUTE1) THEN

3033: END IF;
3034:
3035:
3036: IF p_line_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN NULL;
3037: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE1,p_old_line_rec.ATTRIBUTE1) THEN
3038: l_result := ATTRIBUTE1
3039: (p_operation => l_operation
3040: ,p_record => l_rowtype_rec
3041: ,x_on_operation_action => l_on_operation_action

Line 3051: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE2,p_old_line_rec.ATTRIBUTE2) THEN

3047:
3048: END IF;
3049:
3050: IF p_line_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN NULL;
3051: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE2,p_old_line_rec.ATTRIBUTE2) THEN
3052: l_result := ATTRIBUTE2
3053: (p_operation => l_operation
3054: ,p_record => l_rowtype_rec
3055: ,x_on_operation_action => l_on_operation_action

Line 3065: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE3,p_old_line_rec.ATTRIBUTE3) THEN

3061:
3062: END IF;
3063:
3064: IF p_line_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN NULL;
3065: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE3,p_old_line_rec.ATTRIBUTE3) THEN
3066: l_result := ATTRIBUTE3
3067: (p_operation => l_operation
3068: ,p_record => l_rowtype_rec
3069: ,x_on_operation_action => l_on_operation_action

Line 3079: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE4,p_old_line_rec.ATTRIBUTE4) THEN

3075:
3076: END IF;
3077:
3078: IF p_line_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN NULL;
3079: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE4,p_old_line_rec.ATTRIBUTE4) THEN
3080: l_result := ATTRIBUTE4
3081: (p_operation => l_operation
3082: ,p_record => l_rowtype_rec
3083: ,x_on_operation_action => l_on_operation_action

Line 3093: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE5,p_old_line_rec.ATTRIBUTE5) THEN

3089:
3090: END IF;
3091:
3092: IF p_line_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN NULL;
3093: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE5,p_old_line_rec.ATTRIBUTE5) THEN
3094: l_result := ATTRIBUTE5
3095: (p_operation => l_operation
3096: ,p_record => l_rowtype_rec
3097: ,x_on_operation_action => l_on_operation_action

Line 3107: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE6,p_old_line_rec.ATTRIBUTE6) THEN

3103:
3104: END IF;
3105:
3106: IF p_line_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN NULL;
3107: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE6,p_old_line_rec.ATTRIBUTE6) THEN
3108: l_result := ATTRIBUTE6
3109: (p_operation => l_operation
3110: ,p_record => l_rowtype_rec
3111: ,x_on_operation_action => l_on_operation_action

Line 3121: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE7,p_old_line_rec.ATTRIBUTE7) THEN

3117:
3118: END IF;
3119:
3120: IF p_line_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN NULL;
3121: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE7,p_old_line_rec.ATTRIBUTE7) THEN
3122: l_result := ATTRIBUTE7
3123: (p_operation => l_operation
3124: ,p_record => l_rowtype_rec
3125: ,x_on_operation_action => l_on_operation_action

Line 3135: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE8,p_old_line_rec.ATTRIBUTE8) THEN

3131:
3132: END IF;
3133:
3134: IF p_line_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN NULL;
3135: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE8,p_old_line_rec.ATTRIBUTE8) THEN
3136: l_result := ATTRIBUTE8
3137: (p_operation => l_operation
3138: ,p_record => l_rowtype_rec
3139: ,x_on_operation_action => l_on_operation_action

Line 3149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE9,p_old_line_rec.ATTRIBUTE9) THEN

3145:
3146: END IF;
3147:
3148: IF p_line_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN NULL;
3149: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE9,p_old_line_rec.ATTRIBUTE9) THEN
3150: l_result := ATTRIBUTE9
3151: (p_operation => l_operation
3152: ,p_record => l_rowtype_rec
3153: ,x_on_operation_action => l_on_operation_action

Line 3163: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE10,p_old_line_rec.ATTRIBUTE10) THEN

3159:
3160: END IF;
3161:
3162: IF p_line_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN NULL;
3163: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE10,p_old_line_rec.ATTRIBUTE10) THEN
3164: l_result := ATTRIBUTE10
3165: (p_operation => l_operation
3166: ,p_record => l_rowtype_rec
3167: ,x_on_operation_action => l_on_operation_action

Line 3177: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE11,p_old_line_rec.ATTRIBUTE11) THEN

3173:
3174: END IF;
3175:
3176: IF p_line_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN NULL;
3177: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE11,p_old_line_rec.ATTRIBUTE11) THEN
3178: l_result := ATTRIBUTE11
3179: (p_operation => l_operation
3180: ,p_record => l_rowtype_rec
3181: ,x_on_operation_action => l_on_operation_action

Line 3191: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE12,p_old_line_rec.ATTRIBUTE12) THEN

3187:
3188: END IF;
3189:
3190: IF p_line_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN NULL;
3191: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE12,p_old_line_rec.ATTRIBUTE12) THEN
3192: l_result := ATTRIBUTE12
3193: (p_operation => l_operation
3194: ,p_record => l_rowtype_rec
3195: ,x_on_operation_action => l_on_operation_action

Line 3205: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE13,p_old_line_rec.ATTRIBUTE13) THEN

3201:
3202: END IF;
3203:
3204: IF p_line_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN NULL;
3205: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE13,p_old_line_rec.ATTRIBUTE13) THEN
3206: l_result := ATTRIBUTE13
3207: (p_operation => l_operation
3208: ,p_record => l_rowtype_rec
3209: ,x_on_operation_action => l_on_operation_action

Line 3219: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE14,p_old_line_rec.ATTRIBUTE14) THEN

3215:
3216: END IF;
3217:
3218: IF p_line_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR THEN NULL;
3219: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE14,p_old_line_rec.ATTRIBUTE14) THEN
3220: l_result := ATTRIBUTE14
3221: (p_operation => l_operation
3222: ,p_record => l_rowtype_rec
3223: ,x_on_operation_action => l_on_operation_action

Line 3233: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE15,p_old_line_rec.ATTRIBUTE15) THEN

3229:
3230: END IF;
3231:
3232: IF p_line_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN NULL;
3233: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE15,p_old_line_rec.ATTRIBUTE15) THEN
3234: l_result := ATTRIBUTE15
3235: (p_operation => l_operation
3236: ,p_record => l_rowtype_rec
3237: ,x_on_operation_action => l_on_operation_action

Line 3247: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE16,p_old_line_rec.ATTRIBUTE16) THEN

3243:
3244: END IF;
3245:
3246: IF p_line_rec.ATTRIBUTE16 = FND_API.G_MISS_CHAR THEN NULL;
3247: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE16,p_old_line_rec.ATTRIBUTE16) THEN
3248: l_result := ATTRIBUTE16
3249: (p_operation => l_operation
3250: ,p_record => l_rowtype_rec
3251: ,x_on_operation_action => l_on_operation_action

Line 3261: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE17,p_old_line_rec.ATTRIBUTE17) THEN

3257:
3258: END IF;
3259:
3260: IF p_line_rec.ATTRIBUTE17 = FND_API.G_MISS_CHAR THEN NULL;
3261: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE17,p_old_line_rec.ATTRIBUTE17) THEN
3262: l_result := ATTRIBUTE17
3263: (p_operation => l_operation
3264: ,p_record => l_rowtype_rec
3265: ,x_on_operation_action => l_on_operation_action

Line 3275: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE18,p_old_line_rec.ATTRIBUTE18) THEN

3271:
3272: END IF;
3273:
3274: IF p_line_rec.ATTRIBUTE18 = FND_API.G_MISS_CHAR THEN NULL;
3275: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE18,p_old_line_rec.ATTRIBUTE18) THEN
3276: l_result := ATTRIBUTE18
3277: (p_operation => l_operation
3278: ,p_record => l_rowtype_rec
3279: ,x_on_operation_action => l_on_operation_action

Line 3289: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE19,p_old_line_rec.ATTRIBUTE19) THEN

3285:
3286: END IF;
3287:
3288: IF p_line_rec.ATTRIBUTE19 = FND_API.G_MISS_CHAR THEN NULL;
3289: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE19,p_old_line_rec.ATTRIBUTE19) THEN
3290: l_result := ATTRIBUTE19
3291: (p_operation => l_operation
3292: ,p_record => l_rowtype_rec
3293: ,x_on_operation_action => l_on_operation_action

Line 3303: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE20,p_old_line_rec.ATTRIBUTE20) THEN

3299:
3300: END IF;
3301:
3302: IF p_line_rec.ATTRIBUTE20 = FND_API.G_MISS_CHAR THEN NULL;
3303: ELSIF NOT OE_GLOBALS.EQUAL(p_line_rec.ATTRIBUTE20,p_old_line_rec.ATTRIBUTE20) THEN
3304: l_result := ATTRIBUTE20
3305: (p_operation => l_operation
3306: ,p_record => l_rowtype_rec
3307: ,x_on_operation_action => l_on_operation_action