830: -- Begin partial period computation logic
831: -- Developer Mani Choudhary
832: -- Date 04-MAY-2005
833: -------------------------------------------------------------------------
834: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
835: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
836: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
837: -------------------------------------------------------------------------
838: /* Start Addition for bug fix 5945006 (FP Bug for 5926840) */
831: -- Developer Mani Choudhary
832: -- Date 04-MAY-2005
833: -------------------------------------------------------------------------
834: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
835: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
836: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
837: -------------------------------------------------------------------------
838: /* Start Addition for bug fix 5945006 (FP Bug for 5926840) */
839: CURSOR c_khr_csr(c_chr_id IN NUMBER) IS
832: -- Date 04-MAY-2005
833: -------------------------------------------------------------------------
834: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
835: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
836: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
837: -------------------------------------------------------------------------
838: /* Start Addition for bug fix 5945006 (FP Bug for 5926840) */
839: CURSOR c_khr_csr(c_chr_id IN NUMBER) IS
840: SELECT khr.acct_rule_id acct_rule_id
837: -------------------------------------------------------------------------
838: /* Start Addition for bug fix 5945006 (FP Bug for 5926840) */
839: CURSOR c_khr_csr(c_chr_id IN NUMBER) IS
840: SELECT khr.acct_rule_id acct_rule_id
841: FROM oks_k_headers_b khr
842: WHERE khr.chr_id = c_chr_id;
843:
844: l_acct_rule_id NUMBER;
845:
960: || ', p_billing_type = ' || p_billing_type
961: );
962: END IF;
963:
964: /*UPDATE OKS_K_HEADERS_B SET billing_schedule_type = p_billing_type
965: WHERE chr_id = l_Contract_Rec.id;*/
966:
967: -----create 'SLL' REC
968: -------------------------------------------------------------------------
1256: -- Begin partial period computation logic
1257: -- Developer Mani Choudhary
1258: -- Date 04-MAY-2005
1259: -------------------------------------------------------------------------
1260: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1261: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1262: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1263: l_return_status VARCHAR2(30);
1264: l_tangible BOOLEAN;
1257: -- Developer Mani Choudhary
1258: -- Date 04-MAY-2005
1259: -------------------------------------------------------------------------
1260: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1261: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1262: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1263: l_return_status VARCHAR2(30);
1264: l_tangible BOOLEAN;
1265: l_pricing_method VARCHAR2(30);
1258: -- Date 04-MAY-2005
1259: -------------------------------------------------------------------------
1260: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1261: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1262: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1263: l_return_status VARCHAR2(30);
1264: l_tangible BOOLEAN;
1265: l_pricing_method VARCHAR2(30);
1266: -------------------------------------------------------------------------
4040: -- Begin partial period computation logic
4041: -- Developer Mani Choudhary
4042: -- Date 04-MAY-2005
4043: -------------------------------------------------------------------------
4044: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4045: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4046: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4047: l_tangible BOOLEAN;
4048: l_pricing_method Varchar2(30);
4041: -- Developer Mani Choudhary
4042: -- Date 04-MAY-2005
4043: -------------------------------------------------------------------------
4044: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4045: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4046: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4047: l_tangible BOOLEAN;
4048: l_pricing_method Varchar2(30);
4049: -------------------------------------------------------------------------
4042: -- Date 04-MAY-2005
4043: -------------------------------------------------------------------------
4044: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4045: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4046: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4047: l_tangible BOOLEAN;
4048: l_pricing_method Varchar2(30);
4049: -------------------------------------------------------------------------
4050: -- End partial period computation logic
4659: -- Begin partial period computation logic
4660: -- Developer Mani Choudhary
4661: -- Date 04-MAY-2005
4662: -------------------------------------------------------------------------
4663: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4664: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4665: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4666: -------------------------------------------------------------------------
4667: -- End partial period computation logic
4660: -- Developer Mani Choudhary
4661: -- Date 04-MAY-2005
4662: -------------------------------------------------------------------------
4663: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4664: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4665: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4666: -------------------------------------------------------------------------
4667: -- End partial period computation logic
4668: -- Date 04-MAY-2005
4661: -- Date 04-MAY-2005
4662: -------------------------------------------------------------------------
4663: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4664: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4665: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4666: -------------------------------------------------------------------------
4667: -- End partial period computation logic
4668: -- Date 04-MAY-2005
4669: -------------------------------------------------------------------------
5120: -- Begin partial period computation logic
5121: -- Developer Mani Choudhary
5122: -- Date 04-MAY-2005
5123: -------------------------------------------------------------------------
5124: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5125: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5126: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5127: l_return_status VARCHAR2(30);
5128: l_tangible BOOLEAN;
5121: -- Developer Mani Choudhary
5122: -- Date 04-MAY-2005
5123: -------------------------------------------------------------------------
5124: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5125: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5126: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5127: l_return_status VARCHAR2(30);
5128: l_tangible BOOLEAN;
5129: l_pricing_method VARCHAR2(30);
5122: -- Date 04-MAY-2005
5123: -------------------------------------------------------------------------
5124: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5125: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5126: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5127: l_return_status VARCHAR2(30);
5128: l_tangible BOOLEAN;
5129: l_pricing_method VARCHAR2(30);
5130: -------------------------------------------------------------------------
5619: -- Developer Mani Choudhary
5620: -- Date 04-MAY-2005
5621: -- Local variables and cursors defined here required for cascade
5622: ---------------------------------------------------------------------------
5623: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5624: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5625: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5626: l_level_periods NUMBER;
5627: ---------------------------------------------------------------------------
5620: -- Date 04-MAY-2005
5621: -- Local variables and cursors defined here required for cascade
5622: ---------------------------------------------------------------------------
5623: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5624: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5625: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5626: l_level_periods NUMBER;
5627: ---------------------------------------------------------------------------
5628: BEGIN
5621: -- Local variables and cursors defined here required for cascade
5622: ---------------------------------------------------------------------------
5623: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5624: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5625: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5626: l_level_periods NUMBER;
5627: ---------------------------------------------------------------------------
5628: BEGIN
5629:
7976: -- Developer Mani Choudhary
7977: -- Date 09-MAY-2005
7978: -------------------------------------------------------------------------
7979: l_pricing_method Varchar2(30);
7980: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
7981: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
7982: BEGIN
7983:
7984: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7977: -- Date 09-MAY-2005
7978: -------------------------------------------------------------------------
7979: l_pricing_method Varchar2(30);
7980: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
7981: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
7982: BEGIN
7983:
7984: x_return_status := OKC_API.G_RET_STS_SUCCESS;
7985:
8415: -- Begin partial period computation logic
8416: -- Developer Mani Choudhary
8417: -- Date 04-MAY-2005
8418: -------------------------------------------------------------------------
8419: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8420: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8421: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8422: l_return_status VARCHAR2(30);
8423: -------------------------------------------------------------------------
8416: -- Developer Mani Choudhary
8417: -- Date 04-MAY-2005
8418: -------------------------------------------------------------------------
8419: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8420: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8421: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8422: l_return_status VARCHAR2(30);
8423: -------------------------------------------------------------------------
8424: -- End partial period computation logic
8417: -- Date 04-MAY-2005
8418: -------------------------------------------------------------------------
8419: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8420: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8421: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8422: l_return_status VARCHAR2(30);
8423: -------------------------------------------------------------------------
8424: -- End partial period computation logic
8425: -- Date 04-MAY-2005
8819: -- Begin partial period computation logic
8820: -- Developer Mani Choudhary
8821: -- Date 04-MAY-2005
8822: -------------------------------------------------------------------------
8823: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8824: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8825: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8826: l_return_status VARCHAR2(30);
8827: l_tangible BOOLEAN;
8820: -- Developer Mani Choudhary
8821: -- Date 04-MAY-2005
8822: -------------------------------------------------------------------------
8823: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8824: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8825: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8826: l_return_status VARCHAR2(30);
8827: l_tangible BOOLEAN;
8828: l_pricing_method VARCHAR2(30);
8821: -- Date 04-MAY-2005
8822: -------------------------------------------------------------------------
8823: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8824: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8825: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8826: l_return_status VARCHAR2(30);
8827: l_tangible BOOLEAN;
8828: l_pricing_method VARCHAR2(30);
8829: -------------------------------------------------------------------------
10301: Cursor l_contract_Csr Is
10302: SELECT hdr.id, TRUNC(hdr.start_date) start_dt,
10303: nvl(trunc(hdr.date_terminated - 1) ,TRUNC(hdr.end_date)) end_dt,
10304: hdr.inv_rule_id inv_rule_id, dtl.billing_schedule_type billing_schedule_type
10305: FROM okc_k_headers_b hdr, oks_k_headers_b dtl
10306: WHERE hdr.id = dtl.chr_id
10307: AND hdr.Id = p_contract_id ;
10308:
10309:
10338: -- Begin partial period computation logic
10339: -- Developer Mani Choudhary
10340: -- Date 04-MAY-2005
10341: -------------------------------------------------------------------------
10342: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
10343: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
10344: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
10345: l_return_status VARCHAR2(30);
10346: -------------------------------------------------------------------------
10339: -- Developer Mani Choudhary
10340: -- Date 04-MAY-2005
10341: -------------------------------------------------------------------------
10342: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
10343: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
10344: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
10345: l_return_status VARCHAR2(30);
10346: -------------------------------------------------------------------------
10347: -- End partial period computation logic
10340: -- Date 04-MAY-2005
10341: -------------------------------------------------------------------------
10342: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
10343: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
10344: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
10345: l_return_status VARCHAR2(30);
10346: -------------------------------------------------------------------------
10347: -- End partial period computation logic
10348: -- Date 04-MAY-2005
11706: -- Begin partial period computation logic
11707: -- Developer Mani Choudhary
11708: -- Date 04-MAY-2005
11709: -------------------------------------------------------------------------
11710: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
11711: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
11712: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
11713: l_return_status VARCHAR2(30);
11714: l_tangible BOOLEAN;
11707: -- Developer Mani Choudhary
11708: -- Date 04-MAY-2005
11709: -------------------------------------------------------------------------
11710: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
11711: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
11712: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
11713: l_return_status VARCHAR2(30);
11714: l_tangible BOOLEAN;
11715: l_pricing_method VARCHAR2(30);
11708: -- Date 04-MAY-2005
11709: -------------------------------------------------------------------------
11710: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
11711: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
11712: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
11713: l_return_status VARCHAR2(30);
11714: l_tangible BOOLEAN;
11715: l_pricing_method VARCHAR2(30);
11716: -------------------------------------------------------------------------