DBA Data[Home] [Help]

APPS.OE_DEFAULT_LINE dependencies on OE_ORDER_PUB

Line 9: g_line_rec OE_Order_PUB.Line_Rec_Type;

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Default_Line';
7:
8:
9: g_line_rec OE_Order_PUB.Line_Rec_Type;
10:
11: FUNCTION Get_Def_Invoice_Line_Int
12: (p_return_context IN VARCHAR2,
13: p_return_attribute1 IN VARCHAR2,

Line 24: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type,

20:
21: /* Added procedure default_active_agr_revision for Bug 2154960 */
22:
23: procedure Default_Active_Agr_Revision
24: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type,
25: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
26: OE_Order_PUB.G_MISS_LINE_REC
27: );
28:

Line 25: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

21: /* Added procedure default_active_agr_revision for Bug 2154960 */
22:
23: procedure Default_Active_Agr_Revision
24: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type,
25: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
26: OE_Order_PUB.G_MISS_LINE_REC
27: );
28:
29: /* Added blanket values defaulting

Line 26: OE_Order_PUB.G_MISS_LINE_REC

22:
23: procedure Default_Active_Agr_Revision
24: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type,
25: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
26: OE_Order_PUB.G_MISS_LINE_REC
27: );
28:
29: /* Added blanket values defaulting
30: --Made this procedure public

Line 106: FUNCTION GET_FREIGHT_CARRIER(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103:
104: END Get_Order_Source_Id;
105:
106: FUNCTION GET_FREIGHT_CARRIER(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
107: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
108: RETURN VARCHAR2
109: IS
110: l_freight_code VARCHAR2(80);

Line 107: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)

103:
104: END Get_Order_Source_Id;
105:
106: FUNCTION GET_FREIGHT_CARRIER(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
107: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
108: RETURN VARCHAR2
109: IS
110: l_freight_code VARCHAR2(80);
111: --

Line 414: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type,

410: calls process order again to default Dependent Attributes based
411: on new Agreement_Id - Bug 2154960 */
412:
413: procedure Default_Active_Agr_Revision
414: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type,
415: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
416: OE_Order_PUB.G_MISS_LINE_REC
417: )
418: IS

Line 415: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

411: on new Agreement_Id - Bug 2154960 */
412:
413: procedure Default_Active_Agr_Revision
414: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type,
415: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
416: OE_Order_PUB.G_MISS_LINE_REC
417: )
418: IS
419: L_RETURN_STATUS VARCHAR2(1);

Line 416: OE_Order_PUB.G_MISS_LINE_REC

412:
413: procedure Default_Active_Agr_Revision
414: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type,
415: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
416: OE_Order_PUB.G_MISS_LINE_REC
417: )
418: IS
419: L_RETURN_STATUS VARCHAR2(1);
420:

Line 421: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;

417: )
418: IS
419: L_RETURN_STATUS VARCHAR2(1);
420:
421: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;
422:
423: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
424: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
425: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 423: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

419: L_RETURN_STATUS VARCHAR2(1);
420:
421: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;
422:
423: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
424: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
425: l_control_rec OE_GLOBALS.Control_Rec_Type;
426: l_agreement_name varchar2(240);
427: l_agreement_id number;

Line 424: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

420:
421: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;
422:
423: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
424: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
425: l_control_rec OE_GLOBALS.Control_Rec_Type;
426: l_agreement_name varchar2(240);
427: l_agreement_id number;
428:

Line 1284: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;

1280: default_child_line.
1281: -----------------------------------------------------------------*/
1282: PROCEDURE Model_Option_Defaulting
1283: IS
1284: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;
1285: l_parent_line_id NUMBER;
1286: l_return_status VARCHAR2(1);
1287: --
1288: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1458: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)

1454: in case of updates
1455: ----------------------------------------------------------------*/
1456:
1457: PROCEDURE Model_Option_update
1458: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
1459: IS
1460: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;
1461: l_parent_line_id NUMBER;
1462: l_return_status VARCHAR2(1);

Line 1460: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;

1456:
1457: PROCEDURE Model_Option_update
1458: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
1459: IS
1460: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;
1461: l_parent_line_id NUMBER;
1462: l_return_status VARCHAR2(1);
1463: --
1464: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1891: PROCEDURE Check_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

1887:
1888: END Get_Fulfilled_Quantity;
1889:
1890: --Procedure to check change in item_type_code
1891: PROCEDURE Check_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
1892: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type,
1893: p_item_type_code VARCHAR2)
1894: IS
1895: --

Line 1892: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type,

1888: END Get_Fulfilled_Quantity;
1889:
1890: --Procedure to check change in item_type_code
1891: PROCEDURE Check_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
1892: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type,
1893: p_item_type_code VARCHAR2)
1894: IS
1895: --
1896: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1927: FUNCTION Get_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

1923: END IF;
1924:
1925: END Check_Item_Type;
1926:
1927: FUNCTION Get_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
1928: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
1929: RETURN VARCHAR2
1930: IS
1931: l_item_type_code VARCHAR2(30) := NULL;

Line 1928: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)

1924:
1925: END Check_Item_Type;
1926:
1927: FUNCTION Get_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
1928: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
1929: RETURN VARCHAR2
1930: IS
1931: l_item_type_code VARCHAR2(30) := NULL;
1932: l_bom_item_type VARCHAR2(30);

Line 2165: FUNCTION Get_Line_Category(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

2161: RETURN l_Org_Id;
2162:
2163: END Get_Org;
2164:
2165: FUNCTION Get_Line_Category(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
2166: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
2167: RETURN VARCHAR2
2168: IS
2169: l_order_category varchar2(30);

Line 2166: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)

2162:
2163: END Get_Org;
2164:
2165: FUNCTION Get_Line_Category(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
2166: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
2167: RETURN VARCHAR2
2168: IS
2169: l_order_category varchar2(30);
2170: l_category varchar2(30) := NULL;

Line 3382: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3378: END Get_Defaulting_Order_Line;
3379:
3380: Procedure Attributes_From_Invoice_Line
3381: ( p_invoice_line_id IN NUMBER
3382: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3383: )
3384: IS
3385: l_quantity NUMBER;
3386: l_uom_code VARCHAR2(3);

Line 3474: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3470: END Attributes_From_Invoice_Line;
3471:
3472: Procedure Attributes_From_Order_Line
3473: ( p_order_line_id IN NUMBER
3474: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3475: )
3476: IS
3477: l_ref_line_rec OE_ORDER_PUB.Line_Rec_Type;
3478: l_revision_controlled VARCHAR2(1);

Line 3477: l_ref_line_rec OE_ORDER_PUB.Line_Rec_Type;

3473: ( p_order_line_id IN NUMBER
3474: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3475: )
3476: IS
3477: l_ref_line_rec OE_ORDER_PUB.Line_Rec_Type;
3478: l_revision_controlled VARCHAR2(1);
3479: x_item_rec OE_Order_Cache.Item_Rec_Type;
3480: --
3481: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3932: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3928:
3929: END Attributes_From_Order_Line;
3930:
3931: Procedure Return_Attributes
3932: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3933: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
3934: )
3935: IS
3936: l_defaulting_invoice_line_id NUMBER := NULL;

Line 3933: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

3929: END Attributes_From_Order_Line;
3930:
3931: Procedure Return_Attributes
3932: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3933: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
3934: )
3935: IS
3936: l_defaulting_invoice_line_id NUMBER := NULL;
3937: l_defaulting_order_line_id NUMBER := NULL;

Line 3938: l_line_rec oe_order_pub.line_rec_type;

3934: )
3935: IS
3936: l_defaulting_invoice_line_id NUMBER := NULL;
3937: l_defaulting_order_line_id NUMBER := NULL;
3938: l_line_rec oe_order_pub.line_rec_type;
3939: --
3940: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3941: l_return_status VARCHAR2(1);
3942: l_sold_to_org_id NUMBER;

Line 3978: p_x_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

3974: -- Backup the passed in record.
3975: l_line_rec := p_x_line_rec;
3976:
3977: -- Set the line rec to MISSING so that all attributes are redefaulted
3978: p_x_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
3979:
3980: -- Reset the pre-defaulted values from backup
3981: p_x_line_rec.line_id := l_line_rec.line_id;
3982: p_x_line_rec.customer_line_number :=l_line_rec.customer_line_number; --added for bug 5569557

Line 4352: ( p_x_Line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

4348:
4349: -- Procedure Attributes
4350:
4351: PROCEDURE Attributes
4352: ( p_x_Line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
4353: , p_old_Line_rec IN OE_Order_PUB.Line_Rec_Type
4354: , p_iteration IN NUMBER := 1
4355: )
4356:

Line 4353: , p_old_Line_rec IN OE_Order_PUB.Line_Rec_Type

4349: -- Procedure Attributes
4350:
4351: PROCEDURE Attributes
4352: ( p_x_Line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
4353: , p_old_Line_rec IN OE_Order_PUB.Line_Rec_Type
4354: , p_iteration IN NUMBER := 1
4355: )
4356:
4357: IS

Line 5515: FUNCTION Get_Dual_Uom(p_line_rec OE_ORDER_PUB.Line_Rec_Type)

5511: FUNCTION Get_Dual_Uom
5512: ----------------------------------------------------------- INVCONV REMOVEd from OE_line_util
5513: */
5514:
5515: FUNCTION Get_Dual_Uom(p_line_rec OE_ORDER_PUB.Line_Rec_Type)
5516: RETURN VARCHAR2
5517: IS
5518: -- l_APPS_UOM2 VARCHAR2(3) := NULL; INVCONV
5519: l_status VARCHAR2(1);

Line 5596: l_header_rec OE_Order_PUB.Header_Rec_Type ;

5592: -- An attribute on line can be defaulted based on a PL/SQL API
5593: -- The API can also refer to ONT_Header_Def_Hdlr.g_record
5594: PROCEDURE Set_Header_Def_Hdlr_Rec (p_header_id IN NUMBER)
5595: IS
5596: l_header_rec OE_Order_PUB.Header_Rec_Type ;
5597: l_rowtype_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
5598: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5599: BEGIN
5600: