DBA Data[Home] [Help]

APPS.OE_UPG_SO_NEW dependencies on OE_ORDER_PUB

Line 6134: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,

6130: -- 4. Attach the config item to the model line.
6131: -- 5. update the option quantity for the original option lines.
6132:
6133: PROCEDURE Insert_Row
6134: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,
6135: p_orig_line_id IN Number,
6136: p_upgraded_flag IN Varchar2 default 'Y',
6137: p_apply_price_adj IN Varchar2 default 'Y'
6138: );

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

6137: p_apply_price_adj IN Varchar2 default 'Y'
6138: );
6139:
6140: FUNCTION Query_Row
6141: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type;
6142:
6143: PROCEDURE insert_multiple_models IS
6144:
6145: cursor multiple_cfg_detail(p_ato_line_id IN NUMBER) IS

Line 6185: l_model_rec OE_ORDER_PUB.line_rec_type;

6181: l_line_id NUMBER;
6182: l_service_count NUMBER;
6183: l_service_line_id NUMBER;
6184:
6185: l_model_rec OE_ORDER_PUB.line_rec_type;
6186: l_line_rec OE_ORDER_PUB.line_rec_type;
6187: l_service_line_rec OE_ORDER_PUB.line_rec_type;
6188: l_new_line_rec OE_ORDER_PUB.line_rec_type;
6189: v_error_code NUMBER;

Line 6186: l_line_rec OE_ORDER_PUB.line_rec_type;

6182: l_service_count NUMBER;
6183: l_service_line_id NUMBER;
6184:
6185: l_model_rec OE_ORDER_PUB.line_rec_type;
6186: l_line_rec OE_ORDER_PUB.line_rec_type;
6187: l_service_line_rec OE_ORDER_PUB.line_rec_type;
6188: l_new_line_rec OE_ORDER_PUB.line_rec_type;
6189: v_error_code NUMBER;
6190: l_orig_model_quantity NUMBER := 0;

Line 6187: l_service_line_rec OE_ORDER_PUB.line_rec_type;

6183: l_service_line_id NUMBER;
6184:
6185: l_model_rec OE_ORDER_PUB.line_rec_type;
6186: l_line_rec OE_ORDER_PUB.line_rec_type;
6187: l_service_line_rec OE_ORDER_PUB.line_rec_type;
6188: l_new_line_rec OE_ORDER_PUB.line_rec_type;
6189: v_error_code NUMBER;
6190: l_orig_model_quantity NUMBER := 0;
6191: --

Line 6188: l_new_line_rec OE_ORDER_PUB.line_rec_type;

6184:
6185: l_model_rec OE_ORDER_PUB.line_rec_type;
6186: l_line_rec OE_ORDER_PUB.line_rec_type;
6187: l_service_line_rec OE_ORDER_PUB.line_rec_type;
6188: l_new_line_rec OE_ORDER_PUB.line_rec_type;
6189: v_error_code NUMBER;
6190: l_orig_model_quantity NUMBER := 0;
6191: --
6192: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

6506: END insert_multiple_models;
6507:
6508:
6509: FUNCTION Query_Row
6510: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type
6511: IS
6512: l_line_rec OE_Order_PUB.Line_Rec_Type;
6513: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
6514:

Line 6512: l_line_rec OE_Order_PUB.Line_Rec_Type;

6508:
6509: FUNCTION Query_Row
6510: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type
6511: IS
6512: l_line_rec OE_Order_PUB.Line_Rec_Type;
6513: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
6514:
6515: CURSOR l_line_csr IS
6516: SELECT ACCOUNTING_RULE_ID

Line 6513: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

6509: FUNCTION Query_Row
6510: ( p_line_id IN NUMBER) RETURN OE_Order_PUB.Line_Rec_Type
6511: IS
6512: l_line_rec OE_Order_PUB.Line_Rec_Type;
6513: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
6514:
6515: CURSOR l_line_csr IS
6516: SELECT ACCOUNTING_RULE_ID
6517: , ACTUAL_ARRIVAL_DATE

Line 7128: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,

7124:
7125: END Query_Row;
7126:
7127: PROCEDURE Insert_Row
7128: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type,
7129: p_orig_line_id IN Number,
7130: p_upgraded_flag IN Varchar2 default 'Y',
7131: p_apply_price_adj IN Varchar2 default 'Y'
7132: )

Line 8386: l_line_rec OE_Order_PUB.Line_Rec_Type;

8382: l_line_id NUMBER;
8383: l_line_id1 NUMBER;
8384: l_received_quantity NUMBER;
8385: l_delivered_quantity NUMBER;
8386: l_line_rec OE_Order_PUB.Line_Rec_Type;
8387: l_line_rec1 OE_Order_PUB.Line_Rec_Type;
8388: Cursor C1 is
8389: Select rma_interface_id,rma_id,rma_line_id,
8390: inventory_item_id,component_sequence_id,

Line 8387: l_line_rec1 OE_Order_PUB.Line_Rec_Type;

8383: l_line_id1 NUMBER;
8384: l_received_quantity NUMBER;
8385: l_delivered_quantity NUMBER;
8386: l_line_rec OE_Order_PUB.Line_Rec_Type;
8387: l_line_rec1 OE_Order_PUB.Line_Rec_Type;
8388: Cursor C1 is
8389: Select rma_interface_id,rma_id,rma_line_id,
8390: inventory_item_id,component_sequence_id,
8391: quantity, unit_code,received_quantity,delivered_quantity