APPS.OKS_CONTRACTS_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 5228: p_instance_rec_out IN OUT NOCOPY csi_datastructures_pub.instance_rec

5224: ----------------------------------------------------------------------------------------
5225:
5226: PROCEDURE create_item
5227: (
5228: p_instance_rec_out IN OUT NOCOPY csi_datastructures_pub.instance_rec
5229: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5230: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 5229: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

5225:
5226: PROCEDURE create_item
5227: (
5228: p_instance_rec_out IN OUT NOCOPY csi_datastructures_pub.instance_rec
5229: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5230: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5233: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

Line 5230: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

5226: PROCEDURE create_item
5227: (
5228: p_instance_rec_out IN OUT NOCOPY csi_datastructures_pub.instance_rec
5229: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5230: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5233: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5234: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

Line 5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

5227: (
5228: p_instance_rec_out IN OUT NOCOPY csi_datastructures_pub.instance_rec
5229: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5230: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5233: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5234: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5235: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

5228: p_instance_rec_out IN OUT NOCOPY csi_datastructures_pub.instance_rec
5229: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5230: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5233: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5234: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5235: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5236: ,x_return_status OUT NOCOPY VARCHAR2

Line 5233: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

5229: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5230: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5233: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5234: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5235: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5236: ,x_return_status OUT NOCOPY VARCHAR2
5237: ,x_msg_count OUT NOCOPY NUMBER

Line 5234: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

5230: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5233: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5234: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5235: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5236: ,x_return_status OUT NOCOPY VARCHAR2
5237: ,x_msg_count OUT NOCOPY NUMBER
5238: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5235: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5231: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
5232: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
5233: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
5234: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
5235: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5236: ,x_return_status OUT NOCOPY VARCHAR2
5237: ,x_msg_count OUT NOCOPY NUMBER
5238: ,x_msg_data OUT NOCOPY VARCHAR2
5239: )

Line 5249: l_instance_rec_out CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

5245: l_flag VARCHAR2(1) := 'N';
5246: l_msg_data VARCHAR2(2000);
5247: l_msg_index NUMBER;
5248: l_msg_count NUMBER;
5249: l_instance_rec_out CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
5250: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
5251: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 5250: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

5246: l_msg_data VARCHAR2(2000);
5247: l_msg_index NUMBER;
5248: l_msg_count NUMBER;
5249: l_instance_rec_out CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
5250: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
5251: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5254: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 5251: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

5247: l_msg_index NUMBER;
5248: l_msg_count NUMBER;
5249: l_instance_rec_out CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
5250: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
5251: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5254: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5255: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

5248: l_msg_count NUMBER;
5249: l_instance_rec_out CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
5250: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
5251: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5254: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5255: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5256: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

5249: l_instance_rec_out CSI_DATASTRUCTURES_PUB.INSTANCE_REC;
5250: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
5251: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5254: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5255: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5256: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
5257: l_return_status VARCHAR2(2000);

Line 5254: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

5250: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
5251: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5254: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5255: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5256: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
5257: l_return_status VARCHAR2(2000);
5258: l_msg_index_out NUMBER;

Line 5255: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

5251: l_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5254: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5255: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5256: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
5257: l_return_status VARCHAR2(2000);
5258: l_msg_index_out NUMBER;
5259: t_output VARCHAR2(2000);

Line 5256: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

5252: l_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5253: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5254: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5255: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5256: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
5257: l_return_status VARCHAR2(2000);
5258: l_msg_index_out NUMBER;
5259: t_output VARCHAR2(2000);
5260: t_msg_dummy NUMBER;

Line 5380: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC; -- Item Instance record

5376: l_K_usage_rec OKS_CONTRACTS_PUB.line_Rec_Type; -- Usage line record
5377: l_K_covd_rec OKS_CONTRACTS_PUB.Covered_level_Rec_Type; -- Covered level record for support line
5378: l_K_counter_rec OKS_CONTRACTS_PUB.Covered_level_Rec_Type; -- covered level record for usage line
5379: l_k_hdr_rec OKS_CONTRACTS_PUB.header_rec_type; -- Header record
5380: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC; -- Item Instance record
5381: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL; -- Attributes value table
5382: p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 5381: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL; -- Attributes value table

5377: l_K_covd_rec OKS_CONTRACTS_PUB.Covered_level_Rec_Type; -- Covered level record for support line
5378: l_K_counter_rec OKS_CONTRACTS_PUB.Covered_level_Rec_Type; -- covered level record for usage line
5379: l_k_hdr_rec OKS_CONTRACTS_PUB.header_rec_type; -- Header record
5380: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC; -- Item Instance record
5381: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL; -- Attributes value table
5382: p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5385: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

Line 5382: p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;

5378: l_K_counter_rec OKS_CONTRACTS_PUB.Covered_level_Rec_Type; -- covered level record for usage line
5379: l_k_hdr_rec OKS_CONTRACTS_PUB.header_rec_type; -- Header record
5380: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC; -- Item Instance record
5381: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL; -- Attributes value table
5382: p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5385: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5386: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

Line 5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;

5379: l_k_hdr_rec OKS_CONTRACTS_PUB.header_rec_type; -- Header record
5380: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC; -- Item Instance record
5381: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL; -- Attributes value table
5382: p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5385: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5386: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5387: p_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

Line 5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

5380: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_REC; -- Item Instance record
5381: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL; -- Attributes value table
5382: p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5385: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5386: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5387: p_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
5388: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

Line 5385: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;

5381: p_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL; -- Attributes value table
5382: p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5385: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5386: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5387: p_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
5388: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5389: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;

Line 5386: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;

5382: p_party_tbl CSI_DATASTRUCTURES_PUB.PARTY_TBL;
5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5385: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5386: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5387: p_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
5388: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5389: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
5390: l_msg_index Number;

Line 5387: p_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;

5383: p_account_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL;
5384: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
5385: p_org_assignments_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
5386: p_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
5387: p_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
5388: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5389: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
5390: l_msg_index Number;
5391: l_inst_id Number;