4:
5: G_INCLUDE_ALL_REVISIONS VARCHAR2(1) := 'N';
6:
7: PROCEDURE Header_Value_Conversion
8: ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_type
9: , p_header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
10: );
11:
12: PROCEDURE Line_Value_Conversion
9: , p_header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
10: );
11:
12: PROCEDURE Line_Value_Conversion
13: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type
14: , p_line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
15: );
16:
17: PROCEDURE Populate_Header_Values_ID
14: , p_line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
15: );
16:
17: PROCEDURE Populate_Header_Values_ID
18: ( p_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
19: , p_Header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
20: );
21:
22: PROCEDURE Populate_Line_Values_ID
19: , p_Header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
20: );
21:
22: PROCEDURE Populate_Line_Values_ID
23: ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_Rec_Type
24: , p_Line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
25: );
26:
27: PROCEDURE Validate_Entity
24: , p_Line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
25: );
26:
27: PROCEDURE Validate_Entity
28: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2
32: );
31: x_msg_data OUT NOCOPY VARCHAR2
32: );
33:
34: PROCEDURE Validate_Entity
35: (p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
36: x_return_status IN OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,
38: x_msg_data OUT NOCOPY VARCHAR2
39: );
38: x_msg_data OUT NOCOPY VARCHAR2
39: );
40:
41: PROCEDURE Insert_Row
42: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2);
46:
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2);
46:
47: PROCEDURE Update_Row
48: (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2);
52:
58: x_msg_data OUT NOCOPY VARCHAR2);
59: -- hashraf end pack J
60:
61: PROCEDURE Insert_Row
62: (p_line_rec IN OUT NOCOPY OE_BLANKET_PUB.Line_Rec_Type,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2);
66:
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2);
66:
67: PROCEDURE Update_Row
68: (p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2);
72:
78: x_msg_data OUT NOCOPY VARCHAR2);
79: -- hashraf end pack J
80:
81: PROCEDURE Default_Attributes
82: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: x_return_status OUT NOCOPY VARCHAR2);
86:
84: x_msg_data OUT NOCOPY VARCHAR2,
85: x_return_status OUT NOCOPY VARCHAR2);
86:
87: PROCEDURE Default_Attributes
88: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: x_return_status OUT NOCOPY VARCHAR2);
92:
96: x_msg_data IN OUT NOCOPY VARCHAR2);
97:
98: PROCEDURE Check_Sec_Header_Attr
99: (x_return_status IN OUT NOCOPY varchar2,
100: p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
101: p_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
102: -- 11i10 security changes
103: p_column_name IN VARCHAR2 DEFAULT NULL,
104: x_msg_count IN OUT NOCOPY NUMBER,
97:
98: PROCEDURE Check_Sec_Header_Attr
99: (x_return_status IN OUT NOCOPY varchar2,
100: p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
101: p_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
102: -- 11i10 security changes
103: p_column_name IN VARCHAR2 DEFAULT NULL,
104: x_msg_count IN OUT NOCOPY NUMBER,
105: x_msg_data IN OUT NOCOPY VARCHAR2);
105: x_msg_data IN OUT NOCOPY VARCHAR2);
106:
107: PROCEDURE Check_Sec_Line_Attr
108: (x_return_status IN OUT NOCOPY varchar2,
109: p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
110: p_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
111: x_msg_count IN OUT NOCOPY NUMBER,
112: x_msg_data IN OUT NOCOPY VARCHAR2);
113:
106:
107: PROCEDURE Check_Sec_Line_Attr
108: (x_return_status IN OUT NOCOPY varchar2,
109: p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
110: p_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
111: x_msg_count IN OUT NOCOPY NUMBER,
112: x_msg_data IN OUT NOCOPY VARCHAR2);
113:
114: PROCEDURE Check_Sec_Header_Entity
112: x_msg_data IN OUT NOCOPY VARCHAR2);
113:
114: PROCEDURE Check_Sec_Header_Entity
115: (x_return_status IN OUT NOCOPY varchar2,
116: p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
117: x_msg_count IN OUT NOCOPY NUMBER,
118: x_msg_data IN OUT NOCOPY VARCHAR2);
119:
120: PROCEDURE Check_Sec_Line_Entity
118: x_msg_data IN OUT NOCOPY VARCHAR2);
119:
120: PROCEDURE Check_Sec_Line_Entity
121: (x_return_status IN OUT NOCOPY varchar2,
122: p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
123: x_msg_count IN OUT NOCOPY NUMBER,
124: x_msg_data IN OUT NOCOPY VARCHAR2);
125:
126: PROCEDURE Update_Header_Cache
123: x_msg_count IN OUT NOCOPY NUMBER,
124: x_msg_data IN OUT NOCOPY VARCHAR2);
125:
126: PROCEDURE Update_Header_Cache
127: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_rec_type,
128: delete_flag IN Varchar2 DEFAULT NULL);
129:
130: PROCEDURE Update_Line_Cache
131: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
127: (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_rec_type,
128: delete_flag IN Varchar2 DEFAULT NULL);
129:
130: PROCEDURE Update_Line_Cache
131: (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
132: delete_flag IN Varchar2 DEFAULT NULL);
133:
134: PROCEDURE Lock_Header_Row
135: (p_row_id IN VARCHAR2);
140: PROCEDURE Load_Blanket_Line_Number
141: (l_x_header_id IN Varchar2);
142:
143: PROCEDURE Load_Blanket_Header_Rec
144: (p_x_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
145: ,p_x_old_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type);
146:
147: PROCEDURE Load_Blanket_Line_Rec
148: (p_x_line_rec IN OE_Blanket_PUB.line_rec_type
141: (l_x_header_id IN Varchar2);
142:
143: PROCEDURE Load_Blanket_Header_Rec
144: (p_x_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
145: ,p_x_old_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type);
146:
147: PROCEDURE Load_Blanket_Line_Rec
148: (p_x_line_rec IN OE_Blanket_PUB.line_rec_type
149: ,p_x_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type);
144: (p_x_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
145: ,p_x_old_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type);
146:
147: PROCEDURE Load_Blanket_Line_Rec
148: (p_x_line_rec IN OE_Blanket_PUB.line_rec_type
149: ,p_x_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type);
150:
151: -- hashraf start pack J
152: Procedure Clear_Record
145: ,p_x_old_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type);
146:
147: PROCEDURE Load_Blanket_Line_Rec
148: (p_x_line_rec IN OE_Blanket_PUB.line_rec_type
149: ,p_x_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type);
150:
151: -- hashraf start pack J
152: Procedure Clear_Record
153: ( x_return_status OUT NOCOPY VARCHAR2