APPS.ASO_ORDER_INT dependencies on FND_API

Line 34: ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,

30: -- End of Comments
31:
32: TYPE Order_Header_Rec_Type IS RECORD
33: (
34: ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
35: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
36: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
37: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
38: );

Line 35: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

31:
32: TYPE Order_Header_Rec_Type IS RECORD
33: (
34: ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
35: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
36: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
37: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
38: );
39:

Line 36: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

32: TYPE Order_Header_Rec_Type IS RECORD
33: (
34: ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
35: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
36: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
37: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
38: );
39:
40: G_MISS_Order_Header_Rec Order_Header_Rec_Type;

Line 37: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR

33: (
34: ORDER_NUMBER NUMBER := FND_API.G_MISS_NUM,
35: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
36: QUOTE_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
37: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
38: );
39:
40: G_MISS_Order_Header_Rec Order_Header_Rec_Type;
41:

Line 63: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,

59: -- End of Comments
60:
61: TYPE Order_Line_Rec_Type IS RECORD
62: (
63: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
65: QUOTE_SHIPMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
66: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
67: );

Line 64: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

60:
61: TYPE Order_Line_Rec_Type IS RECORD
62: (
63: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
65: QUOTE_SHIPMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
66: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
67: );
68:

Line 65: QUOTE_SHIPMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,

61: TYPE Order_Line_Rec_Type IS RECORD
62: (
63: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
65: QUOTE_SHIPMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
66: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
67: );
68:
69:

Line 66: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR

62: (
63: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
64: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
65: QUOTE_SHIPMENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
66: STATUS VARCHAR2(150) := FND_API.G_MISS_CHAR
67: );
68:
69:
70: G_MISS_Order_Line_Rec Order_Line_Rec_Type;

Line 87: BOOK_FLAG VARCHAR2(1) := FND_API.G_TRUE,

83:
84:
85: TYPE Control_Rec_Type IS RECORD
86: (
87: BOOK_FLAG VARCHAR2(1) := FND_API.G_TRUE,
88: -- RESERVE_FLAG VARCHAR2(1) := FND_API.G_FALSE,
89: CALCULATE_PRICE VARCHAR2(1) := FND_API.G_FALSE,
90: SERVER_ID NUMBER := -1 ,
91: INTERFACE_FFM_FLAG VARCHAR2(1) := FND_API.G_TRUE,

Line 88: -- RESERVE_FLAG VARCHAR2(1) := FND_API.G_FALSE,

84:
85: TYPE Control_Rec_Type IS RECORD
86: (
87: BOOK_FLAG VARCHAR2(1) := FND_API.G_TRUE,
88: -- RESERVE_FLAG VARCHAR2(1) := FND_API.G_FALSE,
89: CALCULATE_PRICE VARCHAR2(1) := FND_API.G_FALSE,
90: SERVER_ID NUMBER := -1 ,
91: INTERFACE_FFM_FLAG VARCHAR2(1) := FND_API.G_TRUE,
92: CC_BY_FAX VARCHAR2(1) := FND_API.G_FALSE

Line 89: CALCULATE_PRICE VARCHAR2(1) := FND_API.G_FALSE,

85: TYPE Control_Rec_Type IS RECORD
86: (
87: BOOK_FLAG VARCHAR2(1) := FND_API.G_TRUE,
88: -- RESERVE_FLAG VARCHAR2(1) := FND_API.G_FALSE,
89: CALCULATE_PRICE VARCHAR2(1) := FND_API.G_FALSE,
90: SERVER_ID NUMBER := -1 ,
91: INTERFACE_FFM_FLAG VARCHAR2(1) := FND_API.G_TRUE,
92: CC_BY_FAX VARCHAR2(1) := FND_API.G_FALSE
93: );

Line 91: INTERFACE_FFM_FLAG VARCHAR2(1) := FND_API.G_TRUE,

87: BOOK_FLAG VARCHAR2(1) := FND_API.G_TRUE,
88: -- RESERVE_FLAG VARCHAR2(1) := FND_API.G_FALSE,
89: CALCULATE_PRICE VARCHAR2(1) := FND_API.G_FALSE,
90: SERVER_ID NUMBER := -1 ,
91: INTERFACE_FFM_FLAG VARCHAR2(1) := FND_API.G_TRUE,
92: CC_BY_FAX VARCHAR2(1) := FND_API.G_FALSE
93: );
94:
95:

Line 92: CC_BY_FAX VARCHAR2(1) := FND_API.G_FALSE

88: -- RESERVE_FLAG VARCHAR2(1) := FND_API.G_FALSE,
89: CALCULATE_PRICE VARCHAR2(1) := FND_API.G_FALSE,
90: SERVER_ID NUMBER := -1 ,
91: INTERFACE_FFM_FLAG VARCHAR2(1) := FND_API.G_TRUE,
92: CC_BY_FAX VARCHAR2(1) := FND_API.G_FALSE
93: );
94:
95:
96: G_MISS_Control_Rec Control_Rec_Type;

Line 110: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

106:
107: -- Line_Scredit record type
108:
109: TYPE Sales_credit_Rec_Type IS RECORD
110: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 111: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

107: -- Line_Scredit record type
108:
109: TYPE Sales_credit_Rec_Type IS RECORD
110: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 112: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

108:
109: TYPE Sales_credit_Rec_Type IS RECORD
110: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

109: TYPE Sales_credit_Rec_Type IS RECORD
110: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

110: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

111: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

112: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

113: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

114: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

115: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

116: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

117: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

118: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

119: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , quote_header_id NUMBER := FND_API.G_MISS_NUM

Line 124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

120: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , quote_header_id NUMBER := FND_API.G_MISS_NUM
128: , quote_line_id NUMBER := FND_API.G_MISS_NUM

Line 125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

121: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , quote_header_id NUMBER := FND_API.G_MISS_NUM
128: , quote_line_id NUMBER := FND_API.G_MISS_NUM
129: , percent NUMBER := FND_API.G_MISS_NUM

Line 126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

122: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , quote_header_id NUMBER := FND_API.G_MISS_NUM
128: , quote_line_id NUMBER := FND_API.G_MISS_NUM
129: , percent NUMBER := FND_API.G_MISS_NUM
130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 127: , quote_header_id NUMBER := FND_API.G_MISS_NUM

123: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , quote_header_id NUMBER := FND_API.G_MISS_NUM
128: , quote_line_id NUMBER := FND_API.G_MISS_NUM
129: , percent NUMBER := FND_API.G_MISS_NUM
130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131: , salesrep_id NUMBER := FND_API.G_MISS_NUM

Line 128: , quote_line_id NUMBER := FND_API.G_MISS_NUM

124: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , quote_header_id NUMBER := FND_API.G_MISS_NUM
128: , quote_line_id NUMBER := FND_API.G_MISS_NUM
129: , percent NUMBER := FND_API.G_MISS_NUM
130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131: , salesrep_id NUMBER := FND_API.G_MISS_NUM
132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM

Line 129: , percent NUMBER := FND_API.G_MISS_NUM

125: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , quote_header_id NUMBER := FND_API.G_MISS_NUM
128: , quote_line_id NUMBER := FND_API.G_MISS_NUM
129: , percent NUMBER := FND_API.G_MISS_NUM
130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131: , salesrep_id NUMBER := FND_API.G_MISS_NUM
132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133: , wh_update_date DATE := FND_API.G_MISS_DATE

Line 130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

126: , dw_update_advice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
127: , quote_header_id NUMBER := FND_API.G_MISS_NUM
128: , quote_line_id NUMBER := FND_API.G_MISS_NUM
129: , percent NUMBER := FND_API.G_MISS_NUM
130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131: , salesrep_id NUMBER := FND_API.G_MISS_NUM
132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133: , wh_update_date DATE := FND_API.G_MISS_DATE
134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 131: , salesrep_id NUMBER := FND_API.G_MISS_NUM

127: , quote_header_id NUMBER := FND_API.G_MISS_NUM
128: , quote_line_id NUMBER := FND_API.G_MISS_NUM
129: , percent NUMBER := FND_API.G_MISS_NUM
130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131: , salesrep_id NUMBER := FND_API.G_MISS_NUM
132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133: , wh_update_date DATE := FND_API.G_MISS_DATE
134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , line_index NUMBER := FND_API.G_MISS_NUM

Line 132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM

128: , quote_line_id NUMBER := FND_API.G_MISS_NUM
129: , percent NUMBER := FND_API.G_MISS_NUM
130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131: , salesrep_id NUMBER := FND_API.G_MISS_NUM
132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133: , wh_update_date DATE := FND_API.G_MISS_DATE
134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , line_index NUMBER := FND_API.G_MISS_NUM
136: , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 133: , wh_update_date DATE := FND_API.G_MISS_DATE

129: , percent NUMBER := FND_API.G_MISS_NUM
130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131: , salesrep_id NUMBER := FND_API.G_MISS_NUM
132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133: , wh_update_date DATE := FND_API.G_MISS_DATE
134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , line_index NUMBER := FND_API.G_MISS_NUM
136: , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
137: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

130: , quota_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
131: , salesrep_id NUMBER := FND_API.G_MISS_NUM
132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133: , wh_update_date DATE := FND_API.G_MISS_DATE
134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , line_index NUMBER := FND_API.G_MISS_NUM
136: , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
137: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 135: , line_index NUMBER := FND_API.G_MISS_NUM

131: , salesrep_id NUMBER := FND_API.G_MISS_NUM
132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133: , wh_update_date DATE := FND_API.G_MISS_DATE
134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , line_index NUMBER := FND_API.G_MISS_NUM
136: , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
137: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
139: );

Line 136: , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR

132: , sales_credit_id NUMBER := FND_API.G_MISS_NUM
133: , wh_update_date DATE := FND_API.G_MISS_DATE
134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , line_index NUMBER := FND_API.G_MISS_NUM
136: , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
137: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
139: );
140: G_MISS_SALES_CREDIT_REC SALES_CREDIT_Rec_Type;

Line 137: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR

133: , wh_update_date DATE := FND_API.G_MISS_DATE
134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , line_index NUMBER := FND_API.G_MISS_NUM
136: , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
137: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
139: );
140: G_MISS_SALES_CREDIT_REC SALES_CREDIT_Rec_Type;
141: TYPE Sales_Credit_Tbl_type IS TABLE OF Sales_Credit_Rec_type

Line 138: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

134: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
135: , line_index NUMBER := FND_API.G_MISS_NUM
136: , orig_sys_credit_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
137: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
139: );
140: G_MISS_SALES_CREDIT_REC SALES_CREDIT_Rec_Type;
141: TYPE Sales_Credit_Tbl_type IS TABLE OF Sales_Credit_Rec_type
142: INDEX BY BINARY_INTEGER;

Line 147: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

143: G_MISS_Sales_Credit_Tbl Sales_Credit_Tbl_Type;
144:
145:
146: TYPE Lot_Serial_Rec_Type IS RECORD
147: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 148: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

144:
145:
146: TYPE Lot_Serial_Rec_Type IS RECORD
147: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 149: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

145:
146: TYPE Lot_Serial_Rec_Type IS RECORD
147: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

146: TYPE Lot_Serial_Rec_Type IS RECORD
147: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

147: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

148: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

149: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

150: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

151: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

152: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

153: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

154: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

155: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , created_by NUMBER := FND_API.G_MISS_NUM

Line 160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

156: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , created_by NUMBER := FND_API.G_MISS_NUM
164: , creation_date DATE := FND_API.G_MISS_DATE

Line 161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

157: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , created_by NUMBER := FND_API.G_MISS_NUM
164: , creation_date DATE := FND_API.G_MISS_DATE
165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

158: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , created_by NUMBER := FND_API.G_MISS_NUM
164: , creation_date DATE := FND_API.G_MISS_DATE
165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 163: , created_by NUMBER := FND_API.G_MISS_NUM

159: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , created_by NUMBER := FND_API.G_MISS_NUM
164: , creation_date DATE := FND_API.G_MISS_DATE
165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , last_updated_by NUMBER := FND_API.G_MISS_NUM
167: , last_update_date DATE := FND_API.G_MISS_DATE

Line 164: , creation_date DATE := FND_API.G_MISS_DATE

160: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , created_by NUMBER := FND_API.G_MISS_NUM
164: , creation_date DATE := FND_API.G_MISS_DATE
165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , last_updated_by NUMBER := FND_API.G_MISS_NUM
167: , last_update_date DATE := FND_API.G_MISS_DATE
168: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR

161: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , created_by NUMBER := FND_API.G_MISS_NUM
164: , creation_date DATE := FND_API.G_MISS_DATE
165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , last_updated_by NUMBER := FND_API.G_MISS_NUM
167: , last_update_date DATE := FND_API.G_MISS_DATE
168: , last_update_login NUMBER := FND_API.G_MISS_NUM
169: , line_id NUMBER := FND_API.G_MISS_NUM

Line 166: , last_updated_by NUMBER := FND_API.G_MISS_NUM

162: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
163: , created_by NUMBER := FND_API.G_MISS_NUM
164: , creation_date DATE := FND_API.G_MISS_DATE
165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , last_updated_by NUMBER := FND_API.G_MISS_NUM
167: , last_update_date DATE := FND_API.G_MISS_DATE
168: , last_update_login NUMBER := FND_API.G_MISS_NUM
169: , line_id NUMBER := FND_API.G_MISS_NUM
170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 167: , last_update_date DATE := FND_API.G_MISS_DATE

163: , created_by NUMBER := FND_API.G_MISS_NUM
164: , creation_date DATE := FND_API.G_MISS_DATE
165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , last_updated_by NUMBER := FND_API.G_MISS_NUM
167: , last_update_date DATE := FND_API.G_MISS_DATE
168: , last_update_login NUMBER := FND_API.G_MISS_NUM
169: , line_id NUMBER := FND_API.G_MISS_NUM
170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM

Line 168: , last_update_login NUMBER := FND_API.G_MISS_NUM

164: , creation_date DATE := FND_API.G_MISS_DATE
165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , last_updated_by NUMBER := FND_API.G_MISS_NUM
167: , last_update_date DATE := FND_API.G_MISS_DATE
168: , last_update_login NUMBER := FND_API.G_MISS_NUM
169: , line_id NUMBER := FND_API.G_MISS_NUM
170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172: , quantity NUMBER := FND_API.G_MISS_NUM

Line 169: , line_id NUMBER := FND_API.G_MISS_NUM

165: , from_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
166: , last_updated_by NUMBER := FND_API.G_MISS_NUM
167: , last_update_date DATE := FND_API.G_MISS_DATE
168: , last_update_login NUMBER := FND_API.G_MISS_NUM
169: , line_id NUMBER := FND_API.G_MISS_NUM
170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172: , quantity NUMBER := FND_API.G_MISS_NUM
173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR

166: , last_updated_by NUMBER := FND_API.G_MISS_NUM
167: , last_update_date DATE := FND_API.G_MISS_DATE
168: , last_update_login NUMBER := FND_API.G_MISS_NUM
169: , line_id NUMBER := FND_API.G_MISS_NUM
170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172: , quantity NUMBER := FND_API.G_MISS_NUM
173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM

167: , last_update_date DATE := FND_API.G_MISS_DATE
168: , last_update_login NUMBER := FND_API.G_MISS_NUM
169: , line_id NUMBER := FND_API.G_MISS_NUM
170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172: , quantity NUMBER := FND_API.G_MISS_NUM
173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 172: , quantity NUMBER := FND_API.G_MISS_NUM

168: , last_update_login NUMBER := FND_API.G_MISS_NUM
169: , line_id NUMBER := FND_API.G_MISS_NUM
170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172: , quantity NUMBER := FND_API.G_MISS_NUM
173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR

169: , line_id NUMBER := FND_API.G_MISS_NUM
170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172: , quantity NUMBER := FND_API.G_MISS_NUM
173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , line_index NUMBER := FND_API.G_MISS_NUM

Line 174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

170: , lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172: , quantity NUMBER := FND_API.G_MISS_NUM
173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , line_index NUMBER := FND_API.G_MISS_NUM
178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

171: , lot_serial_id NUMBER := FND_API.G_MISS_NUM
172: , quantity NUMBER := FND_API.G_MISS_NUM
173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , line_index NUMBER := FND_API.G_MISS_NUM
178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
179: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

172: , quantity NUMBER := FND_API.G_MISS_NUM
173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , line_index NUMBER := FND_API.G_MISS_NUM
178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
179: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 177: , line_index NUMBER := FND_API.G_MISS_NUM

173: , to_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR
174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , line_index NUMBER := FND_API.G_MISS_NUM
178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
179: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
181: , line_set_id NUMBER := FND_API.G_MISS_NUM

Line 178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR

174: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , line_index NUMBER := FND_API.G_MISS_NUM
178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
179: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
181: , line_set_id NUMBER := FND_API.G_MISS_NUM
182: );

Line 179: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR

175: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , line_index NUMBER := FND_API.G_MISS_NUM
178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
179: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
181: , line_set_id NUMBER := FND_API.G_MISS_NUM
182: );
183:

Line 180: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

176: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
177: , line_index NUMBER := FND_API.G_MISS_NUM
178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
179: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
181: , line_set_id NUMBER := FND_API.G_MISS_NUM
182: );
183:
184: TYPE Lot_Serial_Tbl_Type IS TABLE OF Lot_Serial_Rec_Type

Line 181: , line_set_id NUMBER := FND_API.G_MISS_NUM

177: , line_index NUMBER := FND_API.G_MISS_NUM
178: , orig_sys_lotserial_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
179: , change_request_code VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
181: , line_set_id NUMBER := FND_API.G_MISS_NUM
182: );
183:
184: TYPE Lot_Serial_Tbl_Type IS TABLE OF Lot_Serial_Rec_Type
185: INDEX BY BINARY_INTEGER;

Line 200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

196: -- Pre-Req :
197: -- Parameters:
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- P_qte_lines_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type Required
203: -- P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
204: -- P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type Required

Line 201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

197: -- Parameters:
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- P_qte_lines_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type Required
203: -- P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
204: -- P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type Required
205: -- P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type Required

Line 225: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

221: -- End of Comments
222: --
223: PROCEDURE Create_order(
224: P_Api_Version_Number IN NUMBER,
225: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
226: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
227: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
228: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
229: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type

Line 226: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

222: --
223: PROCEDURE Create_order(
224: P_Api_Version_Number IN NUMBER,
225: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
226: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
227: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
228: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
229: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
230: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,

Line 292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

288: -- Pre-Req :
289: -- Parameters:
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- P_qte_lines_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type Required
295: -- P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
296: -- P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type Required

Line 293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

289: -- Parameters:
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- P_qte_lines_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type Required
295: -- P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
296: -- P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type Required
297: -- P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type Required

Line 318: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

314: --
315: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
316: PROCEDURE Update_order(
317: P_Api_Version_Number IN NUMBER,
318: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
320: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
321: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
322: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,

Line 319: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

315: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
316: PROCEDURE Update_order(
317: P_Api_Version_Number IN NUMBER,
318: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
320: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
321: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
322: P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
323: P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,

Line 362: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

358: -- Pre-Req :
359: -- Parameters:
360: -- IN
361: -- p_api_version_number IN NUMBER Required
362: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
363: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
364: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
365: -- p_order_number IN NUMBER Required
366: -- P_Order_Header_Rec IN Order_Header_Rec_Type

Line 363: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

359: -- Parameters:
360: -- IN
361: -- p_api_version_number IN NUMBER Required
362: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
363: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
364: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
365: -- p_order_number IN NUMBER Required
366: -- P_Order_Header_Rec IN Order_Header_Rec_Type
367: --

Line 382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

378: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
379: -- The Master delete procedure may not be needed depends on different business requirements.
380: PROCEDURE Delete_order(
381: P_Api_Version_Number IN NUMBER,
382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384: P_Order_Header_ID IN NUMBER,
385: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
386: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 383: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

379: -- The Master delete procedure may not be needed depends on different business requirements.
380: PROCEDURE Delete_order(
381: P_Api_Version_Number IN NUMBER,
382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384: P_Order_Header_ID IN NUMBER,
385: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
386: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
387: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 395: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

391: -- This procedure can be used to book orders that are in an entered state.
392:
393: PROCEDURE BOOK_ORDER(
394: P_Api_Version_Number IN NUMBER,
395: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
396: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
397: p_order_header_id IN NUMBER,
398: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
399: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 396: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

392:
393: PROCEDURE BOOK_ORDER(
394: P_Api_Version_Number IN NUMBER,
395: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
396: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
397: p_order_header_id IN NUMBER,
398: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
399: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
400: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 409: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

405: -- cancelled_flag to 'Y' in oe_order_headers
406:
407: PROCEDURE CANCEL_ORDER(
408: P_Api_Version_Number IN NUMBER,
409: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
410: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
411: p_order_header_id IN NUMBER,
412: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
413: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 410: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

406:
407: PROCEDURE CANCEL_ORDER(
408: P_Api_Version_Number IN NUMBER,
409: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
410: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
411: p_order_header_id IN NUMBER,
412: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
413: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
414: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 425: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

421: -- ASO_QUOTE_PUB.
422:
423: PROCEDURE Create_order(
424: P_Api_Version IN NUMBER,
425: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
426: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
427: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
428: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
429: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type

Line 426: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

422:
423: PROCEDURE Create_order(
424: P_Api_Version IN NUMBER,
425: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
426: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
427: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
428: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
429: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
430: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,

Line 493: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

489:
490:
491: PROCEDURE Update_order(
492: P_Api_Version IN NUMBER,
493: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
494: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
495: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
496: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
497: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type

Line 494: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

490:
491: PROCEDURE Update_order(
492: P_Api_Version IN NUMBER,
493: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
494: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
495: P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
496: := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
497: P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
498: := ASO_QUOTE_PUB.G_MISS_Payment_TBL,

Line 620: quote_line_id NUMBER := FND_API.G_MISS_NUM,

616: )
617: RETURN NUMBER;
618:
619: FUNCTION Service_Index (
620: quote_line_id NUMBER := FND_API.G_MISS_NUM,
621: quote_line_index NUMBER := FND_API.G_MISS_NUM,
622: P_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type ,
623: p_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
624: )

Line 621: quote_line_index NUMBER := FND_API.G_MISS_NUM,

617: RETURN NUMBER;
618:
619: FUNCTION Service_Index (
620: quote_line_id NUMBER := FND_API.G_MISS_NUM,
621: quote_line_index NUMBER := FND_API.G_MISS_NUM,
622: P_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type ,
623: p_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type
624: )
625: RETURN NUMBER;