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_UPG_SO dependencies on OE_ORDER_PUB

Line 4036: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,

4032: -- 4. Attach the config item to the model line.
4033: -- 5. update the option quantity for the original option lines.
4034:
4035: PROCEDURE Insert_Row
4036: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,
4037: p_orig_line_id IN Number,
4038: p_upgraded_flag IN Varchar2,
4039: p_apply_price_adj IN Varchar2 default 'Y'
4040: );

Line 4043: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type;

4039: p_apply_price_adj IN Varchar2 default 'Y'
4040: );
4041:
4042: FUNCTION Query_Row
4043: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type;
4044:
4045: PROCEDURE insert_multiple_models IS
4046:
4047: cursor multiple_cfg_detail(p_ato_line_id IN NUMBER) IS

Line 4081: l_model_rec OE_ORDER_PUB.line_rec_type;

4077: l_service_count NUMBER;
4078: l_service_line_id NUMBER;
4079: l_s_upgraded_flag VARCHAR2(1);
4080:
4081: l_model_rec OE_ORDER_PUB.line_rec_type;
4082: l_line_rec OE_ORDER_PUB.line_rec_type;
4083: l_service_line_rec OE_ORDER_PUB.line_rec_type;
4084: l_new_line_rec OE_ORDER_PUB.line_rec_type;
4085: l_upgraded_flag VARCHAR2(1);

Line 4082: l_line_rec OE_ORDER_PUB.line_rec_type;

4078: l_service_line_id NUMBER;
4079: l_s_upgraded_flag VARCHAR2(1);
4080:
4081: l_model_rec OE_ORDER_PUB.line_rec_type;
4082: l_line_rec OE_ORDER_PUB.line_rec_type;
4083: l_service_line_rec OE_ORDER_PUB.line_rec_type;
4084: l_new_line_rec OE_ORDER_PUB.line_rec_type;
4085: l_upgraded_flag VARCHAR2(1);
4086:

Line 4083: l_service_line_rec OE_ORDER_PUB.line_rec_type;

4079: l_s_upgraded_flag VARCHAR2(1);
4080:
4081: l_model_rec OE_ORDER_PUB.line_rec_type;
4082: l_line_rec OE_ORDER_PUB.line_rec_type;
4083: l_service_line_rec OE_ORDER_PUB.line_rec_type;
4084: l_new_line_rec OE_ORDER_PUB.line_rec_type;
4085: l_upgraded_flag VARCHAR2(1);
4086:
4087:

Line 4084: l_new_line_rec OE_ORDER_PUB.line_rec_type;

4080:
4081: l_model_rec OE_ORDER_PUB.line_rec_type;
4082: l_line_rec OE_ORDER_PUB.line_rec_type;
4083: l_service_line_rec OE_ORDER_PUB.line_rec_type;
4084: l_new_line_rec OE_ORDER_PUB.line_rec_type;
4085: l_upgraded_flag VARCHAR2(1);
4086:
4087:
4088: --

Line 4248: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type

4244: END insert_multiple_models;
4245:
4246:
4247: FUNCTION Query_Row
4248: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type
4249: IS
4250: l_line_rec OE_Order_PUB.Line_Rec_Type;
4251: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4252:

Line 4250: l_line_rec OE_Order_PUB.Line_Rec_Type;

4246:
4247: FUNCTION Query_Row
4248: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type
4249: IS
4250: l_line_rec OE_Order_PUB.Line_Rec_Type;
4251: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4252:
4253: CURSOR l_line_csr IS
4254: SELECT ACCOUNTING_RULE_ID

Line 4251: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4247: FUNCTION Query_Row
4248: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type
4249: IS
4250: l_line_rec OE_Order_PUB.Line_Rec_Type;
4251: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4252:
4253: CURSOR l_line_csr IS
4254: SELECT ACCOUNTING_RULE_ID
4255: , ACTUAL_ARRIVAL_DATE

Line 4857: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,

4853:
4854: END Query_Row;
4855:
4856: PROCEDURE Insert_Row
4857: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,
4858: p_orig_line_id IN Number,
4859: p_upgraded_flag IN Varchar2,
4860: p_apply_price_adj IN Varchar2 default 'Y'
4861: )

Line 6094: l_line_rec OE_Order_PUB.Line_Rec_Type;

6090: l_shipment_line_id NUMBER;
6091: l_line_id NUMBER;
6092: l_line_id1 NUMBER;
6093: l_received_quantity NUMBER;
6094: l_line_rec OE_Order_PUB.Line_Rec_Type;
6095: l_line_rec1 OE_Order_PUB.Line_Rec_Type;
6096: Cursor C1 is
6097: Select rma_interface_id,rma_id,rma_line_id,
6098: inventory_item_id,component_sequence_id,

Line 6095: l_line_rec1 OE_Order_PUB.Line_Rec_Type;

6091: l_line_id NUMBER;
6092: l_line_id1 NUMBER;
6093: l_received_quantity NUMBER;
6094: l_line_rec OE_Order_PUB.Line_Rec_Type;
6095: l_line_rec1 OE_Order_PUB.Line_Rec_Type;
6096: Cursor C1 is
6097: Select rma_interface_id,rma_id,rma_line_id,
6098: inventory_item_id,component_sequence_id,
6099: quantity, unit_code,received_quantity,delivered_quantity

Line 6334: l_line_rec OE_Order_PUB.Line_Rec_Type;

6330: and l1.line_id not in(
6331: Select new_line_id
6332: from oe_upgrade_log u
6333: where u.module = 'RA');
6334: l_line_rec OE_Order_PUB.Line_Rec_Type;
6335: l_line_rec2 OE_Order_PUB.Line_Rec_Type;
6336: BEGIN
6337:
6338: FOR l_rec in C1 LOOP

Line 6335: l_line_rec2 OE_Order_PUB.Line_Rec_Type;

6331: Select new_line_id
6332: from oe_upgrade_log u
6333: where u.module = 'RA');
6334: l_line_rec OE_Order_PUB.Line_Rec_Type;
6335: l_line_rec2 OE_Order_PUB.Line_Rec_Type;
6336: BEGIN
6337:
6338: FOR l_rec in C1 LOOP
6339: l_commit_counter := l_commit_counter + 1;