DBA Data[Home] [Help]

APPS.ASO_INSTDTLS_INT dependencies on FND_API

Line 39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,

35: G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
36:
37: TYPE Inst_detail_rec_type IS RECORD
38: (
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

36:
37: TYPE Inst_detail_rec_type IS RECORD
38: (
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,

37: TYPE Inst_detail_rec_type IS RECORD
38: (
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,

38: (
39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,

39: line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,

40: order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,

41: quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,

Line 46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

42: source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,

43: transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,

44: system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,

Line 49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,

45: customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,

Line 50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

46: type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,

Line 51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,

47: quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,

Line 52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,

48: installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM

Line 53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,

49: installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57: --desc_flex DFF_Rec_Type

Line 54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,

50: installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57: --desc_flex DFF_Rec_Type
58: );

Line 55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,

51: new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57: --desc_flex DFF_Rec_Type
58: );
59: G_MISS_Inst_detail_Rec Inst_detail_Rec_Type;

Line 56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM

52: new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53: expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54: start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55: end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56: object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57: --desc_flex DFF_Rec_Type
58: );
59: G_MISS_Inst_detail_Rec Inst_detail_Rec_Type;
60: TYPE Inst_detail_Tbl_type IS TABLE OF Inst_detail_Rec_type

Line 68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,

64:
65:
66: TYPE Contact_Rec_Type IS RECORD
67: (
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

Line 69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,

65:
66: TYPE Contact_Rec_Type IS RECORD
67: (
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api

Line 70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts

66: TYPE Contact_Rec_Type IS RECORD
67: (
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde

Line 71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,

67: (
68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75:

Line 72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

68: CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75:
76: );

Line 73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api

69: CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75:
76: );
77:

Line 74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde

70: CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71: OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73: OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74: CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75:
76: );
77:
78:

Line 128: LINE_ID NUMBER := FND_API.G_MISS_NUM,

124:
125:
126: TYPE Cascade_Line_Rec_Type IS RECORD
127: (
128: LINE_ID NUMBER := FND_API.G_MISS_NUM,
129: PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
130: QTY_FACTOR NUMBER := 1,
131: INST_DETAIL_CREATED VARCHAR2(1) := FND_API.G_FALSE
132: );

Line 129: PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,

125:
126: TYPE Cascade_Line_Rec_Type IS RECORD
127: (
128: LINE_ID NUMBER := FND_API.G_MISS_NUM,
129: PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
130: QTY_FACTOR NUMBER := 1,
131: INST_DETAIL_CREATED VARCHAR2(1) := FND_API.G_FALSE
132: );
133:

Line 131: INST_DETAIL_CREATED VARCHAR2(1) := FND_API.G_FALSE

127: (
128: LINE_ID NUMBER := FND_API.G_MISS_NUM,
129: PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
130: QTY_FACTOR NUMBER := 1,
131: INST_DETAIL_CREATED VARCHAR2(1) := FND_API.G_FALSE
132: );
133:
134:
135: G_MISS_Cascade_Line_Rec Cascade_Line_Rec_Type;

Line 146: LINE_ID NUMBER := FND_API.G_MISS_NUM,

142:
143:
144: TYPE Line_Inst_Rec_Type IS RECORD
145: (
146: LINE_ID NUMBER := FND_API.G_MISS_NUM,
147: INST_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
148: QUANTITY NUMBER := FND_API.G_MISS_NUM
149: );
150:

Line 147: INST_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,

143:
144: TYPE Line_Inst_Rec_Type IS RECORD
145: (
146: LINE_ID NUMBER := FND_API.G_MISS_NUM,
147: INST_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
148: QUANTITY NUMBER := FND_API.G_MISS_NUM
149: );
150:
151:

Line 148: QUANTITY NUMBER := FND_API.G_MISS_NUM

144: TYPE Line_Inst_Rec_Type IS RECORD
145: (
146: LINE_ID NUMBER := FND_API.G_MISS_NUM,
147: INST_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
148: QUANTITY NUMBER := FND_API.G_MISS_NUM
149: );
150:
151:
152: G_MISS_Line_Inst_Rec Line_Inst_Rec_Type;

Line 179: -- Default = FND_API.G_FALSE

175: --
176: -- Standard IN Parameters:
177: -- p_api_version IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional
179: -- Default = FND_API.G_FALSE
180: --
181: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
182: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
183: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 202: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

198:
199: PROCEDURE Create_Installation_Detail
200: (
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
203: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
205: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
206: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 203: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

199: PROCEDURE Create_Installation_Detail
200: (
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
203: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
205: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
206: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
207: -- p_object_version_number IN NUMBER,

Line 223: -- Default = FND_API.G_FALSE

219: --
220: -- Standard IN Parameters:
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional
223: -- Default = FND_API.G_FALSE
224: --
225: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
226: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
227: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 246: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

242:
243: PROCEDURE Update_Installation_Detail
244: (
245: p_api_version_number IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
249: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
250: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

243: PROCEDURE Update_Installation_Detail
244: (
245: p_api_version_number IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
247: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
249: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
250: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251: p_object_version_number IN NUMBER,

Line 254: p_cascade_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE );

250: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251: p_object_version_number IN NUMBER,
252: p_line_inst_dtl_tbl IN Inst_Detail_Tbl_Type,
253: p_contact_tbl IN contact_tbl_type DEFAULT G_MISS_Contact_Tbl,
254: p_cascade_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE );
255:
256:
257: --------------------------------------------------------------------------
258:

Line 268: -- Default = FND_API.G_FALSE

264: --
265: -- Standard IN Parameters:
266: -- p_api_version_number IN NUMBER Required
267: -- p_init_msg_list IN VARCHAR2 Optional
268: -- Default = FND_API.G_FALSE
269: --
270: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
271: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
272: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 290: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

286:
287: PROCEDURE Delete_Installation_Detail
288: (
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
291: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
293: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
294: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 291: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

287: PROCEDURE Delete_Installation_Detail
288: (
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
291: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
293: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
294: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
295: p_line_inst_dtl_id IN NUMBER

Line 302: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

298:
299: PROCEDURE Autocreate_systems
300: (
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
303: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
304: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
305: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
306: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 303: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

299: PROCEDURE Autocreate_systems
300: (
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
303: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
304: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
305: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
306: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
307: -- p_system_tbl IN OUT NOCOPY /* file.sql.39 change */ System_Tbl_Type

Line 315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

311:
312: PROCEDURE Update_Inst_Details_ORDER
313: (
314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
318: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
319: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

312: PROCEDURE Update_Inst_Details_ORDER
313: (
314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
318: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
319: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
320: p_quote_line_shipment_id IN NUMBER,

Line 327: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

323:
324:
325: PROCEDURE CASCADE_DETAILS_YN(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
328: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
329: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
330: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
331: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 328: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

324:
325: PROCEDURE CASCADE_DETAILS_YN(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
328: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
329: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
330: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
331: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
332: p_object_version_number IN NUMBER,