DBA Data[Home] [Help]

APPS.OKS_CONTRACTS_PUB dependencies on OKS_BILL_SCH

Line 737: p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl,

733:
734: Procedure Create_Bill_Schedule
735: (
736: p_billing_sch IN VARCHAR2,
737: p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl,
738: p_invoice_rule_id IN Number,
739: x_return_status OUT NOCOPY VARCHAR2
740: )
741: IS

Line 742: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

738: p_invoice_rule_id IN Number,
739: x_return_status OUT NOCOPY VARCHAR2
740: )
741: IS
742: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
743: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
744: l_time_val NUMBER;
745: l_invoice_rule_id NUMBER;
746: l_msg_data Varchar2(2000);

Line 743: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;

739: x_return_status OUT NOCOPY VARCHAR2
740: )
741: IS
742: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
743: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
744: l_time_val NUMBER;
745: l_invoice_rule_id NUMBER;
746: l_msg_data Varchar2(2000);
747: l_msg_count Number;

Line 790: OKS_BILL_SCH.Create_Bill_Sch_Rules

786: IF l_invoice_rule_id IS NULL THEN
787: l_invoice_rule_id := -3;
788: END IF;
789:
790: OKS_BILL_SCH.Create_Bill_Sch_Rules
791: (
792: p_billing_type => p_billing_sch ,
793: p_sll_tbl => p_strm_level_tbl,
794: p_invoice_rule_id => l_invoice_rule_id,

Line 839: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;

835: )
836: Is
837:
838: --Scedule Billing
839: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
840: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
841: l_bil_sch_out OKS_BILL_SCH.ItemBillSch_tbl;
842: ---Time value
843: l_tavv_tbl_in okc_time_pub.tavv_tbl_type;

Line 840: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

836: Is
837:
838: --Scedule Billing
839: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
840: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
841: l_bil_sch_out OKS_BILL_SCH.ItemBillSch_tbl;
842: ---Time value
843: l_tavv_tbl_in okc_time_pub.tavv_tbl_type;
844: l_tavv_tbl_out okc_time_pub.tavv_tbl_type;

Line 841: l_bil_sch_out OKS_BILL_SCH.ItemBillSch_tbl;

837:
838: --Scedule Billing
839: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
840: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
841: l_bil_sch_out OKS_BILL_SCH.ItemBillSch_tbl;
842: ---Time value
843: l_tavv_tbl_in okc_time_pub.tavv_tbl_type;
844: l_tavv_tbl_out okc_time_pub.tavv_tbl_type;
845: l_tpa_id Number;

Line 934: OKS_BILL_SCH.Create_Bill_Sch_Rules

930:
931: OKS_RENEW_PVT.DEBUG_LOG( '(OKS_CONTRACTS_PUB).Create_Billing_Schd :: P_amount :'|| P_amount);
932: ----dbms_output.put_line('before bill sch rule ');
933:
934: OKS_BILL_SCH.Create_Bill_Sch_Rules
935: (
936: p_billing_type => 'E'
937: , p_sll_tbl => l_sll_tbl
938: , p_invoice_rule_id => p_invoice_rule_id

Line 3433: l_bill_sch_out OKS_BILL_SCH.ItemBillSch_tbl;

3429: l_index VARCHAR2(2000);
3430:
3431: l_ctcv_tbl_in Okc_contract_party_pub.ctcv_tbl_type;
3432: l_ctcv_tbl_out Okc_contract_party_pub.ctcv_tbl_type;
3433: l_bill_sch_out OKS_BILL_SCH.ItemBillSch_tbl;
3434: l_msg_index Number;
3435: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
3436: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
3437:

Line 5320: , p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl

5316: , p_line_sales_crd_tbl_in IN OKS_CONTRACTS_PUB.SalesCredit_tbl
5317: , p_price_attribs_in IN OKS_CONTRACTS_PUB.pricing_attributes_type
5318: , p_contract_header_id IN NUMBER
5319: , bill_type IN varchar2
5320: , p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl
5321: , x_return_status OUT NOCOPY VARCHAR2
5322: , x_msg_count OUT NOCOPY NUMBER
5323: , x_msg_data OUT NOCOPY varchar2
5324: ) IS

Line 5388: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_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;
5392:

Line 5389: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;

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;
5392:
5393:

Line 5788: OKS_BILL_SCH.Create_Bill_Sch_Rules

5784: END IF;
5785: END IF;
5786:
5787: --dbms_output.put_line('rule information catagory '|| l_slh_rec.Rule_Information_Category );
5788: OKS_BILL_SCH.Create_Bill_Sch_Rules
5789: (
5790: p_billing_type => p_billing_sch_type,
5791: p_sll_tbl => p_strm_level_tbl,
5792: p_invoice_rule_id => l_K_support_rec.invoicing_rule_type,

Line 5892: OKS_BILL_SCH.Create_Bill_Sch_Rules

5888: END IF;
5889: END IF;
5890:
5891: --dbms_output.put_line('rule information catagory '|| l_slh_rec.Rule_Information_Category );
5892: OKS_BILL_SCH.Create_Bill_Sch_Rules
5893: (
5894: p_billing_type => bill_type,
5895: p_sll_tbl => p_strm_level_tbl,
5896: p_invoice_rule_id => l_K_line_rec.invoicing_rule_type,

Line 5955: , p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl

5951: , p_merge_rule IN Varchar2
5952: , p_usage_instantiate IN Varchar2
5953: , p_ib_creation IN Varchar2
5954: , p_billing_sch_type IN Varchar2
5955: , p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl
5956: , x_chrid OUT NOCOPY Number
5957: , x_return_status OUT NOCOPY Varchar2
5958: , x_msg_count OUT NOCOPY Number
5959: , x_msg_data OUT NOCOPY Varchar2

Line 5966: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

5962:
5963: l_contract_header_id NUMBER;
5964: l_service_line_id NUMBER;
5965: l_cp_line_id NUMBER;
5966: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5967: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
5968: l_K_line_rec OKS_CONTRACTS_PUB.line_Rec_Type;
5969: l_k_support_rec OKS_CONTRACTS_PUB.line_Rec_Type;
5970: l_k_hdr_rec OKS_CONTRACTS_PUB.header_Rec_Type;

Line 5967: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;

5963: l_contract_header_id NUMBER;
5964: l_service_line_id NUMBER;
5965: l_cp_line_id NUMBER;
5966: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
5967: --l_slh_rec OKS_BILL_SCH.StreamHdr_type;
5968: l_K_line_rec OKS_CONTRACTS_PUB.line_Rec_Type;
5969: l_k_support_rec OKS_CONTRACTS_PUB.line_Rec_Type;
5970: l_k_hdr_rec OKS_CONTRACTS_PUB.header_Rec_Type;
5971: l_K_covd_rec OKS_CONTRACTS_PUB.Covered_level_Rec_Type;

Line 6126: OKS_BILL_SCH.Create_Bill_Sch_Rules

6122: Raise G_EXCEPTION_HALT_VALIDATION;
6123: END IF;
6124: END IF;*/
6125:
6126: OKS_BILL_SCH.Create_Bill_Sch_Rules
6127: (
6128: p_billing_type => p_billing_sch_type,
6129: p_sll_tbl => p_strm_level_tbl,
6130: p_invoice_rule_id => l_K_line_rec.invoicing_rule_type,

Line 6171: Procedure Create_Bill_Schedule(p_Strm_hdr_rec IN OKS_BILL_SCH.StreamHdr_Type,

6167: END Create_Contract;
6168:
6169: /* dummy overloaded procedure for OKL*/
6170:
6171: Procedure Create_Bill_Schedule(p_Strm_hdr_rec IN OKS_BILL_SCH.StreamHdr_Type,
6172: p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl,
6173: p_invoice_rule_id IN Number,
6174: x_return_status OUT NOCOPY VARCHAR2
6175: )

Line 6172: p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl,

6168:
6169: /* dummy overloaded procedure for OKL*/
6170:
6171: Procedure Create_Bill_Schedule(p_Strm_hdr_rec IN OKS_BILL_SCH.StreamHdr_Type,
6172: p_strm_level_tbl IN OKS_BILL_SCH.StreamLvl_tbl,
6173: p_invoice_rule_id IN Number,
6174: x_return_status OUT NOCOPY VARCHAR2
6175: )
6176: