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_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: --9040537 /*8319535 start
12: FUNCTION Get_Def_Invoice_Line_Int
13: (p_return_context IN VARCHAR2,

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

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

Line 27: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 28: OE_Order_PUB.G_MISS_LINE_REC

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

Line 108: FUNCTION GET_FREIGHT_CARRIER(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

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

Line 109: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)

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

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

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

Line 417: p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 418: OE_Order_PUB.G_MISS_LINE_REC

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

Line 423: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 425: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 426: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 1346: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;

1342: default_child_line.
1343: -----------------------------------------------------------------*/
1344: PROCEDURE Model_Option_Defaulting
1345: IS
1346: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;
1347: l_parent_line_id NUMBER;
1348: l_return_status VARCHAR2(1);
1349: --
1350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

1516: in case of updates
1517: ----------------------------------------------------------------*/
1518:
1519: PROCEDURE Model_Option_update
1520: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
1521: IS
1522: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;
1523: l_parent_line_id NUMBER;
1524: l_return_status VARCHAR2(1);

Line 1522: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;

1518:
1519: PROCEDURE Model_Option_update
1520: (p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
1521: IS
1522: l_top_model_line_rec OE_ORDER_PUB.line_rec_type;
1523: l_parent_line_id NUMBER;
1524: l_return_status VARCHAR2(1);
1525: --
1526: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1957: PROCEDURE Check_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

1953:
1954: END Get_Fulfilled_Quantity;
1955:
1956: --Procedure to check change in item_type_code
1957: PROCEDURE Check_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
1958: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type,
1959: p_item_type_code VARCHAR2)
1960: IS
1961: --

Line 1958: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type,

1954: END Get_Fulfilled_Quantity;
1955:
1956: --Procedure to check change in item_type_code
1957: PROCEDURE Check_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
1958: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type,
1959: p_item_type_code VARCHAR2)
1960: IS
1961: --
1962: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1993: FUNCTION Get_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

1989: END IF;
1990:
1991: END Check_Item_Type;
1992:
1993: FUNCTION Get_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
1994: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
1995: RETURN VARCHAR2
1996: IS
1997: l_item_type_code VARCHAR2(30) := NULL;

Line 1994: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)

1990:
1991: END Check_Item_Type;
1992:
1993: FUNCTION Get_Item_Type(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
1994: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
1995: RETURN VARCHAR2
1996: IS
1997: l_item_type_code VARCHAR2(30) := NULL;
1998: l_bom_item_type VARCHAR2(30);

Line 2282: FUNCTION Get_Line_Category(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

2278: RETURN l_Org_Id;
2279:
2280: END Get_Org;
2281:
2282: FUNCTION Get_Line_Category(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
2283: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
2284: RETURN VARCHAR2
2285: IS
2286: l_order_category varchar2(30);

Line 2283: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)

2279:
2280: END Get_Org;
2281:
2282: FUNCTION Get_Line_Category(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
2283: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
2284: RETURN VARCHAR2
2285: IS
2286: l_order_category varchar2(30);
2287: l_category varchar2(30) := NULL;

Line 3501: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3497: END Get_Defaulting_Order_Line;
3498:
3499: Procedure Attributes_From_Invoice_Line
3500: ( p_invoice_line_id IN NUMBER
3501: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3502: )
3503: IS
3504: l_quantity NUMBER;
3505: l_uom_code VARCHAR2(3);

Line 3593: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

3589: END Attributes_From_Invoice_Line;
3590:
3591: Procedure Attributes_From_Order_Line
3592: ( p_order_line_id IN NUMBER
3593: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3594: )
3595: IS
3596: l_ref_line_rec OE_ORDER_PUB.Line_Rec_Type;
3597: l_revision_controlled VARCHAR2(1);

Line 3596: l_ref_line_rec OE_ORDER_PUB.Line_Rec_Type;

3592: ( p_order_line_id IN NUMBER
3593: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3594: )
3595: IS
3596: l_ref_line_rec OE_ORDER_PUB.Line_Rec_Type;
3597: l_revision_controlled VARCHAR2(1);
3598: x_item_rec OE_Order_Cache.Item_Rec_Type;
3599: --
3600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4059: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

4055:
4056: END Attributes_From_Order_Line;
4057:
4058: Procedure Return_Attributes
4059: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
4060: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
4061: )
4062: IS
4063: l_defaulting_invoice_line_id NUMBER := NULL;

Line 4060: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

4056: END Attributes_From_Order_Line;
4057:
4058: Procedure Return_Attributes
4059: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
4060: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
4061: )
4062: IS
4063: l_defaulting_invoice_line_id NUMBER := NULL;
4064: l_defaulting_order_line_id NUMBER := NULL;

Line 4065: l_line_rec oe_order_pub.line_rec_type;

4061: )
4062: IS
4063: l_defaulting_invoice_line_id NUMBER := NULL;
4064: l_defaulting_order_line_id NUMBER := NULL;
4065: l_line_rec oe_order_pub.line_rec_type;
4066: --
4067: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4068: l_return_status VARCHAR2(1);
4069: l_sold_to_org_id NUMBER;

Line 4105: p_x_line_rec := OE_Order_PUB.G_MISS_LINE_REC;

4101: -- Backup the passed in record.
4102: l_line_rec := p_x_line_rec;
4103:
4104: -- Set the line rec to MISSING so that all attributes are redefaulted
4105: p_x_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
4106:
4107: -- Reset the pre-defaulted values from backup
4108: p_x_line_rec.line_id := l_line_rec.line_id;
4109: p_x_line_rec.customer_line_number :=l_line_rec.customer_line_number; --added for bug 5569557

Line 4502: ( p_x_Line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

4498:
4499: -- Procedure Attributes
4500:
4501: PROCEDURE Attributes
4502: ( p_x_Line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
4503: , p_old_Line_rec IN OE_Order_PUB.Line_Rec_Type
4504: , p_iteration IN NUMBER := 1
4505: )
4506:

Line 4503: , p_old_Line_rec IN OE_Order_PUB.Line_Rec_Type

4499: -- Procedure Attributes
4500:
4501: PROCEDURE Attributes
4502: ( p_x_Line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
4503: , p_old_Line_rec IN OE_Order_PUB.Line_Rec_Type
4504: , p_iteration IN NUMBER := 1
4505: )
4506:
4507: IS

Line 5791: FUNCTION Get_Dual_Uom(p_line_rec OE_ORDER_PUB.Line_Rec_Type)

5787: FUNCTION Get_Dual_Uom
5788: ----------------------------------------------------------- INVCONV REMOVEd from OE_line_util
5789: */
5790:
5791: FUNCTION Get_Dual_Uom(p_line_rec OE_ORDER_PUB.Line_Rec_Type)
5792: RETURN VARCHAR2
5793: IS
5794: -- l_APPS_UOM2 VARCHAR2(3) := NULL; INVCONV
5795: l_status VARCHAR2(1);

Line 5872: l_header_rec OE_Order_PUB.Header_Rec_Type ;

5868: -- An attribute on line can be defaulted based on a PL/SQL API
5869: -- The API can also refer to ONT_Header_Def_Hdlr.g_record
5870: PROCEDURE Set_Header_Def_Hdlr_Rec (p_header_id IN NUMBER)
5871: IS
5872: l_header_rec OE_Order_PUB.Header_Rec_Type ;
5873: l_rowtype_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
5874: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5875: BEGIN
5876: