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_BLANKET_UTIL dependencies on OE_BLANKET_PUB

Line 4: G_Header_Rec OE_Blanket_PUB.Header_rec_type ;

1: PACKAGE OE_Blanket_util AUTHID CURRENT_USER AS
2: /* $Header: OEXUBSOS.pls 120.4.12020000.1 2012/06/26 09:22:39 appldev ship $ */
3:
4: G_Header_Rec OE_Blanket_PUB.Header_rec_type ;
5: G_Request_Tbl oe_blanket_pub.Request_Tbl_Type ;
6: g_old_header_hist_rec OE_Blanket_PUB.Header_rec_type ;
7: g_old_line_hist_tbl OE_Blanket_PUB.line_tbl_type ;
8: g_old_version_captured BOOLEAN := FALSE;

Line 5: G_Request_Tbl oe_blanket_pub.Request_Tbl_Type ;

1: PACKAGE OE_Blanket_util AUTHID CURRENT_USER AS
2: /* $Header: OEXUBSOS.pls 120.4.12020000.1 2012/06/26 09:22:39 appldev ship $ */
3:
4: G_Header_Rec OE_Blanket_PUB.Header_rec_type ;
5: G_Request_Tbl oe_blanket_pub.Request_Tbl_Type ;
6: g_old_header_hist_rec OE_Blanket_PUB.Header_rec_type ;
7: g_old_line_hist_tbl OE_Blanket_PUB.line_tbl_type ;
8: g_old_version_captured BOOLEAN := FALSE;
9:

Line 6: g_old_header_hist_rec OE_Blanket_PUB.Header_rec_type ;

2: /* $Header: OEXUBSOS.pls 120.4.12020000.1 2012/06/26 09:22:39 appldev ship $ */
3:
4: G_Header_Rec OE_Blanket_PUB.Header_rec_type ;
5: G_Request_Tbl oe_blanket_pub.Request_Tbl_Type ;
6: g_old_header_hist_rec OE_Blanket_PUB.Header_rec_type ;
7: g_old_line_hist_tbl OE_Blanket_PUB.line_tbl_type ;
8: g_old_version_captured BOOLEAN := FALSE;
9:
10: -- 11i10 Pricing Change

Line 7: g_old_line_hist_tbl OE_Blanket_PUB.line_tbl_type ;

3:
4: G_Header_Rec OE_Blanket_PUB.Header_rec_type ;
5: G_Request_Tbl oe_blanket_pub.Request_Tbl_Type ;
6: g_old_header_hist_rec OE_Blanket_PUB.Header_rec_type ;
7: g_old_line_hist_tbl OE_Blanket_PUB.line_tbl_type ;
8: g_old_version_captured BOOLEAN := FALSE;
9:
10: -- 11i10 Pricing Change
11: -- Move globals to package spec.

Line 12: g_line_id_tbl OE_BLANKET_PUB.line_tbl_type;

8: g_old_version_captured BOOLEAN := FALSE;
9:
10: -- 11i10 Pricing Change
11: -- Move globals to package spec.
12: g_line_id_tbl OE_BLANKET_PUB.line_tbl_type;
13: g_new_price_list boolean := false ;
14: g_new_modifier_list BOOLEAN := FALSE;
15:
16: -- CustomerRelationship Support for BSA

Line 20: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

16: -- CustomerRelationship Support for BSA
17: g_customer_relations VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('CUSTOMER_RELATIONSHIPS_FLAG'), 'N');
18:
19: PROCEDURE Validate_Attributes
20: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
21: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type
22: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23: , x_return_status OUT NOCOPY VARCHAR2
24: );

Line 21: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type

17: g_customer_relations VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('CUSTOMER_RELATIONSHIPS_FLAG'), 'N');
18:
19: PROCEDURE Validate_Attributes
20: ( p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
21: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type
22: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
23: , x_return_status OUT NOCOPY VARCHAR2
24: );
25:

Line 27: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

23: , x_return_status OUT NOCOPY VARCHAR2
24: );
25:
26: PROCEDURE Validate_Attributes
27: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
28: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type
29: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
30: , x_return_status OUT NOCOPY VARCHAR2
31: );

Line 28: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type

24: );
25:
26: PROCEDURE Validate_Attributes
27: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
28: , p_old_line_rec IN OE_Blanket_PUB.line_rec_type
29: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
30: , x_return_status OUT NOCOPY VARCHAR2
31: );
32:

Line 34: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

30: , x_return_status OUT NOCOPY VARCHAR2
31: );
32:
33: PROCEDURE Validate_Entity
34: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
35: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type :=
36: OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC
37: , x_return_status OUT NOCOPY VARCHAR2
38: );

Line 35: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type :=

31: );
32:
33: PROCEDURE Validate_Entity
34: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
35: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type :=
36: OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC
37: , x_return_status OUT NOCOPY VARCHAR2
38: );
39:

Line 36: OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC

32:
33: PROCEDURE Validate_Entity
34: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
35: , p_old_line_rec IN OE_Blanket_PUB.Line_rec_type :=
36: OE_Blanket_PUB.G_MISS_BLANKET_LINE_REC
37: , x_return_status OUT NOCOPY VARCHAR2
38: );
39:
40: PROCEDURE Validate_Entity

Line 41: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

37: , x_return_status OUT NOCOPY VARCHAR2
38: );
39:
40: PROCEDURE Validate_Entity
41: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
42: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type :=
43: OE_Blanket_PUB.G_MISS_HEADER_REC
44: , x_return_status OUT NOCOPY VARCHAR2
45: );

Line 42: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type :=

38: );
39:
40: PROCEDURE Validate_Entity
41: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
42: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type :=
43: OE_Blanket_PUB.G_MISS_HEADER_REC
44: , x_return_status OUT NOCOPY VARCHAR2
45: );
46:

Line 43: OE_Blanket_PUB.G_MISS_HEADER_REC

39:
40: PROCEDURE Validate_Entity
41: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
42: , p_old_header_rec IN OE_Blanket_PUB.Header_rec_type :=
43: OE_Blanket_PUB.G_MISS_HEADER_REC
44: , x_return_status OUT NOCOPY VARCHAR2
45: );
46:
47:

Line 49: ( p_header_rec IN OE_Blanket_PUB.Header_rec_type

45: );
46:
47:
48: PROCEDURE Insert_Row
49: ( p_header_rec IN OE_Blanket_PUB.Header_rec_type
50: , x_return_status OUT NOCOPY VARCHAR2
51: );
52:
53: PROCEDURE Update_Row

Line 54: ( p_header_rec IN OE_Blanket_PUB.Header_rec_type

50: , x_return_status OUT NOCOPY VARCHAR2
51: );
52:
53: PROCEDURE Update_Row
54: ( p_header_rec IN OE_Blanket_PUB.Header_rec_type
55: , x_return_status OUT NOCOPY VARCHAR2
56: );
57:
58: PROCEDURE Delete_Row

Line 64: (p_line_rec IN OE_BLANKET_PUB.Line_Rec_Type

60: , x_return_status OUT NOCOPY VARCHAR2
61: );
62:
63: PROCEDURE Insert_Row
64: (p_line_rec IN OE_BLANKET_PUB.Line_Rec_Type
65: , x_return_status OUT NOCOPY VARCHAR2
66: );
67:
68: PROCEDURE Update_Row

Line 69: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type

65: , x_return_status OUT NOCOPY VARCHAR2
66: );
67:
68: PROCEDURE Update_Row
69: ( p_line_rec IN OE_Blanket_PUB.Line_rec_type
70: , x_return_status OUT NOCOPY VARCHAR2
71: );
72:
73: PROCEDURE Delete_Row

Line 83: , x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

79: PROCEDURE Query_Header
80: ( p_header_id IN NUMBER
81: , p_version_number IN NUMBER := NULL
82: , p_phase_change_flag IN VARCHAR2 := NULL
83: , x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
84: , x_return_status OUT NOCOPY VARCHAR2
85: );
86:
87: PROCEDURE Query_Lines

Line 92: , x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type

88: ( p_line_id IN NUMBER := NULL
89: , p_header_id IN NUMBER := NULL
90: , p_version_number IN NUMBER := NULL
91: , p_phase_change_flag IN VARCHAR2 := NULL
92: , x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
93: , x_return_status OUT NOCOPY VARCHAR2
94: );
95:
96: PROCEDURE Query_blanket

Line 100: , p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

96: PROCEDURE Query_blanket
97: ( p_header_id IN NUMBER
98: , p_version_number IN NUMBER := NULL
99: , p_phase_change_flag IN VARCHAR2 := NULL
100: , p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
101: , p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
102: , x_return_status OUT NOCOPY VARCHAR2
103: );
104:

Line 101: , p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type

97: ( p_header_id IN NUMBER
98: , p_version_number IN NUMBER := NULL
99: , p_phase_change_flag IN VARCHAR2 := NULL
100: , p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
101: , p_x_line_tbl IN OUT NOCOPY OE_Blanket_PUB.line_tbl_type
102: , x_return_status OUT NOCOPY VARCHAR2
103: );
104:
105: FUNCTION Query_Row

Line 109: ) RETURN OE_Blanket_PUB.Line_Rec_Type;

105: FUNCTION Query_Row
106: ( p_line_id NUMBER
107: , p_version_number IN NUMBER := NULL
108: , p_phase_change_flag IN VARCHAR2 := NULL
109: ) RETURN OE_Blanket_PUB.Line_Rec_Type;
110:
111: PROCEDURE Lock_Row
112: ( x_return_status OUT NOCOPY VARCHAR2
113: , p_blanket_id IN NUMBER

Line 121: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type

117: , x_msg_data OUT NOCOPY VARCHAR2
118: );
119:
120: PROCEDURE Default_Attributes
121: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
122: , x_return_status OUT NOCOPY VARCHAR2
123: );
124:
125: PROCEDURE Default_Attributes

Line 126: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type

122: , x_return_status OUT NOCOPY VARCHAR2
123: );
124:
125: PROCEDURE Default_Attributes
126: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type
127: , p_default_from_header IN BOOLEAN
128: , x_return_status OUT NOCOPY VARCHAR2
129: );
130:

Line 136: p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,

132: , x_return_status OUT NOCOPY VARCHAR2
133: );
134:
135: PROCEDURE get_order_number(
136: p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
137: x_return_status OUT NOCOPY varchar2 );
138:
139: PROCEDURE Process_Object(x_return_status OUT NOCOPY varchar2) ;
140:

Line 236: ( p_HEADER_rec IN OE_Blanket_PUB.HEADER_Rec_Type

232:
233: -- Procedure API_Rec_To_Rowtype_Rec
234:
235: PROCEDURE API_Rec_To_Rowtype_Rec
236: ( p_HEADER_rec IN OE_Blanket_PUB.HEADER_Rec_Type
237: , x_rowtype_rec IN OUT NOCOPY OE_AK_BLANKET_HEADERS_V%ROWTYPE
238: );
239:
240: -- Procedure Rowtype_Rec_To_API_Rec

Line 244: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.HEADER_Rec_Type

240: -- Procedure Rowtype_Rec_To_API_Rec
241:
242: PROCEDURE Rowtype_Rec_To_API_Rec
243: ( p_record IN OE_AK_BLANKET_HEADERS_V%ROWTYPE
244: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.HEADER_Rec_Type
245: );
246:
247: -- Function to initialize view%rowtype record
248:

Line 255: ( p_LINE_rec IN OE_Blanket_PUB.LINE_Rec_Type

251:
252: -- Procedure API_Rec_To_Rowtype_Rec
253:
254: PROCEDURE Line_API_Rec_To_Rowtype_Rec
255: ( p_LINE_rec IN OE_Blanket_PUB.LINE_Rec_Type
256: , x_rowtype_rec IN OUT NOCOPY OE_AK_BLANKET_LINES_V%ROWTYPE
257: );
258:
259: -- Procedure Rowtype_Rec_To_API_Rec

Line 263: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.LINE_Rec_Type

259: -- Procedure Rowtype_Rec_To_API_Rec
260:
261: PROCEDURE Line_Rowtype_Rec_To_API_Rec
262: ( p_record IN OE_AK_BLANKET_LINES_V%ROWTYPE
263: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.LINE_Rec_Type
264: );
265:
266: Procedure Get_Inventory_Item
267: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_Pub.Line_Rec_Type

Line 267: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_Pub.Line_Rec_Type

263: , x_api_rec IN OUT NOCOPY OE_Blanket_PUB.LINE_Rec_Type
264: );
265:
266: Procedure Get_Inventory_Item
267: ( p_x_line_rec IN OUT NOCOPY OE_Blanket_Pub.Line_Rec_Type
268: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
269: );
270: --Introduced as a part of the bug #4447494
271: PROCEDURE validate_sold_to