DBA Data[Home] [Help]

APPS.CSI_CUSTOMER_PRODUCTS_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 182: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

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,

Line 183: x_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_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,

Line 184: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_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,

Line 185: x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

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,

Line 186: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_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

Line 187: x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

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

Line 188: x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,

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:

Line 189: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_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:
193: CURSOR GET_IP_Account IS

Line 190: x_ii_relationship_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec

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

Line 634: l_instance_rec csi_datastructures_pub.instance_rec;

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;

Line 635: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_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;

Line 636: l_party_tbl csi_datastructures_pub.party_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;

Line 637: l_account_tbl csi_datastructures_pub.party_account_tbl;

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;

Line 638: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_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;

Line 639: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;

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;

Line 640: l_txn_rec csi_datastructures_pub.transaction_rec;

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);

Line 641: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_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);
645: l_msg_count NUMBER;

Line 642: l_ii_Relationship_rec csi_datastructures_pub.ii_relationship_rec;

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);

Line 643: l_instance_id_lst csi_datastructures_pub.id_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);
647: l_Api_Name VARCHAR2(30) := 'Update_Row';

Line 650: l1_party_tbl csi_datastructures_pub.party_tbl;

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:

Line 651: l1_account_tbl csi_datastructures_pub.party_account_tbl;

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(

Line 1275: ;l_source_instance_rec csi_datastructures_pub.instance_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:

Line 1276: ;x_new_instance_rec csi_datastructures_pub.instance_rec

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

Line 1277: ;l_txn_rec csi_datastructures_pub.transaction_rec

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;