178: Px_IPA_Object_Version_Number IN OUT NOCOPY NUMBER, -- := FND_API.G_MISS_NUM,
179: Px_PA_Object_Version_Number IN OUT NOCOPY NUMBER, -- := FND_API.G_MISS_NUM,
180: p_form_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_block IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
183: x_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
184: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
179: Px_PA_Object_Version_Number IN OUT NOCOPY NUMBER, -- := FND_API.G_MISS_NUM,
180: p_form_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_block IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
183: x_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
184: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
180: p_form_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_block IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
183: x_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
184: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
188: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
181: p_block IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
183: x_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
184: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
188: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
189: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
182: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
183: x_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
184: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
188: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
189: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
190: x_ii_relationship_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
183: x_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
184: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
188: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
189: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
190: x_ii_relationship_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
191: ) IS
184: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
188: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
189: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
190: x_ii_relationship_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
191: ) IS
192:
185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
188: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
189: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
190: x_ii_relationship_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
191: ) IS
192:
193: CURSOR GET_IP_Account IS
186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
188: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
189: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
190: x_ii_relationship_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
191: ) IS
192:
193: CURSOR GET_IP_Account IS
194: SELECT ip_account_id
630: l_api_version NUMBER := 1;
631: l_commit VARCHAR2(1) := fnd_api.g_false;
632: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
633: l_validation_level NUMBER := fnd_api.g_valid_level_full;
634: l_instance_rec csi_datastructures_pub.instance_rec;
635: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
636: l_party_tbl csi_datastructures_pub.party_tbl;
637: l_account_tbl csi_datastructures_pub.party_account_tbl;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
631: l_commit VARCHAR2(1) := fnd_api.g_false;
632: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
633: l_validation_level NUMBER := fnd_api.g_valid_level_full;
634: l_instance_rec csi_datastructures_pub.instance_rec;
635: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
636: l_party_tbl csi_datastructures_pub.party_tbl;
637: l_account_tbl csi_datastructures_pub.party_account_tbl;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
632: l_init_msg_list VARCHAR2(1) := fnd_api.g_false;
633: l_validation_level NUMBER := fnd_api.g_valid_level_full;
634: l_instance_rec csi_datastructures_pub.instance_rec;
635: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
636: l_party_tbl csi_datastructures_pub.party_tbl;
637: l_account_tbl csi_datastructures_pub.party_account_tbl;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
640: l_txn_rec csi_datastructures_pub.transaction_rec;
633: l_validation_level NUMBER := fnd_api.g_valid_level_full;
634: l_instance_rec csi_datastructures_pub.instance_rec;
635: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
636: l_party_tbl csi_datastructures_pub.party_tbl;
637: l_account_tbl csi_datastructures_pub.party_account_tbl;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
640: l_txn_rec csi_datastructures_pub.transaction_rec;
641: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
634: l_instance_rec csi_datastructures_pub.instance_rec;
635: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
636: l_party_tbl csi_datastructures_pub.party_tbl;
637: l_account_tbl csi_datastructures_pub.party_account_tbl;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
640: l_txn_rec csi_datastructures_pub.transaction_rec;
641: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
642: l_ii_Relationship_rec csi_datastructures_pub.ii_relationship_rec;
635: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
636: l_party_tbl csi_datastructures_pub.party_tbl;
637: l_account_tbl csi_datastructures_pub.party_account_tbl;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
640: l_txn_rec csi_datastructures_pub.transaction_rec;
641: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
642: l_ii_Relationship_rec csi_datastructures_pub.ii_relationship_rec;
643: l_instance_id_lst csi_datastructures_pub.id_tbl;
636: l_party_tbl csi_datastructures_pub.party_tbl;
637: l_account_tbl csi_datastructures_pub.party_account_tbl;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
640: l_txn_rec csi_datastructures_pub.transaction_rec;
641: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
642: l_ii_Relationship_rec csi_datastructures_pub.ii_relationship_rec;
643: l_instance_id_lst csi_datastructures_pub.id_tbl;
644: l_return_status VARCHAR2(1);
637: l_account_tbl csi_datastructures_pub.party_account_tbl;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
640: l_txn_rec csi_datastructures_pub.transaction_rec;
641: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
642: l_ii_Relationship_rec csi_datastructures_pub.ii_relationship_rec;
643: l_instance_id_lst csi_datastructures_pub.id_tbl;
644: l_return_status VARCHAR2(1);
645: l_msg_count NUMBER;
638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
640: l_txn_rec csi_datastructures_pub.transaction_rec;
641: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
642: l_ii_Relationship_rec csi_datastructures_pub.ii_relationship_rec;
643: l_instance_id_lst csi_datastructures_pub.id_tbl;
644: l_return_status VARCHAR2(1);
645: l_msg_count NUMBER;
646: l_msg_data VARCHAR2(2000);
639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
640: l_txn_rec csi_datastructures_pub.transaction_rec;
641: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
642: l_ii_Relationship_rec csi_datastructures_pub.ii_relationship_rec;
643: l_instance_id_lst csi_datastructures_pub.id_tbl;
644: l_return_status VARCHAR2(1);
645: l_msg_count NUMBER;
646: l_msg_data VARCHAR2(2000);
647: l_Api_Name VARCHAR2(30) := 'Update_Row';
646: l_msg_data VARCHAR2(2000);
647: l_Api_Name VARCHAR2(30) := 'Update_Row';
648: l_Msg_Index NUMBER;
649:
650: l1_party_tbl csi_datastructures_pub.party_tbl;
651: l1_account_tbl csi_datastructures_pub.party_account_tbl;
652:
653: BEGIN
654:
647: l_Api_Name VARCHAR2(30) := 'Update_Row';
648: l_Msg_Index NUMBER;
649:
650: l1_party_tbl csi_datastructures_pub.party_tbl;
651: l1_account_tbl csi_datastructures_pub.party_account_tbl;
652:
653: BEGIN
654:
655: Convert_Cp_Prod_Param_To_Rec(
1271: ;l_validation_level NUMBER := fnd_api.g_valid_level_full
1272: ;l_msg_index NUMBER
1273: ;l_True VARCHAR2(1) := fnd_api.g_true
1274: ;l_Api_Name VARCHAR2(30) := 'SPLIT_PRODUCT'
1275: ;l_source_instance_rec csi_datastructures_pub.instance_rec
1276: ;x_new_instance_rec csi_datastructures_pub.instance_rec
1277: ;l_txn_rec csi_datastructures_pub.transaction_rec
1278: ;
1279:
1272: ;l_msg_index NUMBER
1273: ;l_True VARCHAR2(1) := fnd_api.g_true
1274: ;l_Api_Name VARCHAR2(30) := 'SPLIT_PRODUCT'
1275: ;l_source_instance_rec csi_datastructures_pub.instance_rec
1276: ;x_new_instance_rec csi_datastructures_pub.instance_rec
1277: ;l_txn_rec csi_datastructures_pub.transaction_rec
1278: ;
1279:
1280: BEGIN
1273: ;l_True VARCHAR2(1) := fnd_api.g_true
1274: ;l_Api_Name VARCHAR2(30) := 'SPLIT_PRODUCT'
1275: ;l_source_instance_rec csi_datastructures_pub.instance_rec
1276: ;x_new_instance_rec csi_datastructures_pub.instance_rec
1277: ;l_txn_rec csi_datastructures_pub.transaction_rec
1278: ;
1279:
1280: BEGIN
1281: l_Source_Instance_Rec.Instance_Id := p_Cp_Id;