42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
50: p_l_last_updated_by IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
51: p_l_last_update_date IN jtf_date_table := NULL ,
52: p_l_last_update_login IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
53: p_l_request_id IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
54: p_l_program_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
55: p_l_program_application_id IN jtf_number_table := NULL ,
56: p_l_program_update_date IN jtf_date_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
63: p_l_config_revision_num IN jtf_number_table := NULL ,
57: p_l_shp_list_id IN jtf_number_table := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
63: p_l_config_revision_num IN jtf_number_table := NULL ,
64: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
65: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
58: p_l_inventory_item_id IN jtf_number_table := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
63: p_l_config_revision_num IN jtf_number_table := NULL ,
64: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
65: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
66: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
59: p_l_organization_id IN jtf_number_table := NULL ,
60: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61: p_l_quantity IN jtf_number_table := NULL ,
62: p_l_config_header_id IN jtf_number_table := NULL ,
63: p_l_config_revision_num IN jtf_number_table := NULL ,
64: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
65: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
66: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
67: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
79: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
80: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
81: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
82: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
80: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
81: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
82: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
81: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
82: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
82: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
83: p_l_org_id IN jtf_number_table := NULL ,
84: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
85: p_lr_request_id IN jtf_number_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
86: p_lr_program_application_id IN jtf_number_table := NULL ,
87: p_lr_program_id IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
88: p_lr_program_update_date IN jtf_date_table := NULL ,
89: p_lr_object_version_number IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
90: p_lr_created_by IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
91: p_lr_creation_date IN jtf_date_table := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
99: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
92: p_lr_last_updated_by IN jtf_number_table := NULL ,
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
99: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
100: x_sl_header_id OUT NOCOPY NUMBER
93: p_lr_last_update_date IN jtf_date_table := NULL ,
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
99: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
100: x_sl_header_id OUT NOCOPY NUMBER
101: );
94: p_lr_last_update_login IN jtf_number_table := NULL ,
95: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96: p_lr_line_index IN jtf_number_table := NULL ,
97: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98: p_lr_related_line_index IN jtf_number_table := NULL ,
99: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
100: x_sl_header_id OUT NOCOPY NUMBER
101: );
102:
107: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108: x_return_status OUT NOCOPY VARCHAR2 ,
109: x_msg_count OUT NOCOPY NUMBER ,
110: x_msg_data OUT NOCOPY VARCHAR2 ,
111: p_sl_line_ids IN jtf_number_table ,
112: p_sl_line_ovns IN jtf_number_table := NULL ,
113: p_mode IN VARCHAR2 := 'MERGE' ,
114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
108: x_return_status OUT NOCOPY VARCHAR2 ,
109: x_msg_count OUT NOCOPY NUMBER ,
110: x_msg_data OUT NOCOPY VARCHAR2 ,
111: p_sl_line_ids IN jtf_number_table ,
112: p_sl_line_ovns IN jtf_number_table := NULL ,
113: p_mode IN VARCHAR2 := 'MERGE' ,
114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
204: x_return_status OUT NOCOPY VARCHAR2 ,
205: x_msg_count OUT NOCOPY NUMBER ,
206: x_msg_data OUT NOCOPY VARCHAR2 ,
207: p_sl_line_ids IN jtf_number_table ,
208: p_sl_line_ovns IN jtf_number_table := NULL ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
204: x_return_status OUT NOCOPY VARCHAR2 ,
205: x_msg_count OUT NOCOPY NUMBER ,
206: x_msg_data OUT NOCOPY VARCHAR2 ,
207: p_sl_line_ids IN jtf_number_table ,
208: p_sl_line_ovns IN jtf_number_table := NULL ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,