APPS.OE_LINE_ATTRIBUTES dependencies on SO_LINE_ATTRIBUTES

Line 5: ** set_so_line_attributes is called from OrderImport to manipulate so_line_attributes

1: PACKAGE BODY oe_line_attributes AS
2: /* $Header: OEXLATTB.pls 115.2 99/07/16 08:13:05 porting shi $ */
3:
4: /*
5: ** set_so_line_attributes is called from OrderImport to manipulate so_line_attributes
6: ** given the records in so_line_attributes_interface.
7: ** For op_code = INSERT/UPDATE, we only do UPDATE the records since
8: ** insertion is already done in oeoord()
9: ** For op_code = DELETE, we don't do any deletion since the complementing record in

Line 6: ** given the records in so_line_attributes_interface.

2: /* $Header: OEXLATTB.pls 115.2 99/07/16 08:13:05 porting shi $ */
3:
4: /*
5: ** set_so_line_attributes is called from OrderImport to manipulate so_line_attributes
6: ** given the records in so_line_attributes_interface.
7: ** For op_code = INSERT/UPDATE, we only do UPDATE the records since
8: ** insertion is already done in oeoord()
9: ** For op_code = DELETE, we don't do any deletion since the complementing record in
10: ** so_line_attributes is deleted from oeoord()

Line 10: ** so_line_attributes is deleted from oeoord()

6: ** given the records in so_line_attributes_interface.
7: ** For op_code = INSERT/UPDATE, we only do UPDATE the records since
8: ** insertion is already done in oeoord()
9: ** For op_code = DELETE, we don't do any deletion since the complementing record in
10: ** so_line_attributes is deleted from oeoord()
11: */
12:
13: PROCEDURE set_so_line_attributes
14: (in_line_id IN NUMBER,

Line 13: PROCEDURE set_so_line_attributes

9: ** For op_code = DELETE, we don't do any deletion since the complementing record in
10: ** so_line_attributes is deleted from oeoord()
11: */
12:
13: PROCEDURE set_so_line_attributes
14: (in_line_id IN NUMBER,
15: in_op_code IN VARCHAR2,
16: in_ord_source IN VARCHAR2,
17: in_orig_sys_ref IN VARCHAR2,

Line 161: FROM so_line_attributes_interface

157: l_global_attribute18,
158: l_global_attribute19,
159: l_global_attribute20
160:
161: FROM so_line_attributes_interface
162: WHERE order_source_id = in_ord_source
163: AND original_system_reference = in_orig_sys_ref
164: AND original_system_line_reference = in_orig_sys_l_ref
165: AND Nvl(error_flag,'N') <> 'Y';

Line 168: UPDATE so_line_attributes

164: AND original_system_line_reference = in_orig_sys_l_ref
165: AND Nvl(error_flag,'N') <> 'Y';
166:
167:
168: UPDATE so_line_attributes
169: SET
170: last_update_date = sysdate,
171: last_updated_by = l_updated_by,
172: last_update_login = l_login_id,

Line 227: END set_so_line_attributes;

223: EXCEPTION
224: WHEN NO_DATA_FOUND THEN
225: out_result := 1;
226:
227: END set_so_line_attributes;
228:
229:
230: /*
231: ** set_industry_attributes is called from oeoord.lpc

Line 232: ** to insert(delete) a complementing null record into so_line_attributes

228:
229:
230: /*
231: ** set_industry_attributes is called from oeoord.lpc
232: ** to insert(delete) a complementing null record into so_line_attributes
233: ** whenever a line is inserted(deleted) into so_lines.
234: ** Also called from Order User Exit to update records when in GUI mode,
235: ** or to insert/delete records when in Character mode.
236: */

Line 303: INSERT INTO so_line_attributes

299: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
300:
301: IF (in_op_code = 'INSERT') THEN
302:
303: INSERT INTO so_line_attributes
304: (line_id,
305: creation_date,
306: created_by,
307: last_update_date,

Line 405: UPDATE so_line_attributes

401: ELSIF (in_op_code = 'UPDATE') THEN
402:
403: BEGIN
404:
405: UPDATE so_line_attributes
406: SET
407: last_update_date = l_date,
408: last_updated_by = l_user_id,
409: last_update_login = l_login_id,

Line 454: would have no complementing records in so_line_attributes.

450: global_attribute20 = in_global_attribute20
451: WHERE line_id = in_line_id;
452:
453: /* existing order lines that were inserted PRE-ReleaseAccountingInstallation
454: would have no complementing records in so_line_attributes.
455: In this case, we should insert a new record with the new information */
456:
457: IF SQL%NOTFOUND THEN -- update failed
458:

Line 459: INSERT INTO so_line_attributes

455: In this case, we should insert a new record with the new information */
456:
457: IF SQL%NOTFOUND THEN -- update failed
458:
459: INSERT INTO so_line_attributes
460: (line_id,
461: creation_date,
462: created_by,
463: last_update_date,

Line 564: FROM so_line_attributes

560:
561: ELSIF (in_op_code = 'DELETE') THEN
562:
563: DELETE
564: FROM so_line_attributes
565: WHERE line_id = in_line_id;
566:
567: END if;
568:

Line 702: so_line_attributes

698: out_global_attribute18,
699: out_global_attribute19,
700: out_global_attribute20
701: FROM
702: so_line_attributes
703: WHERE
704: line_id = in_line_id;
705:
706: END IF;