DBA Data[Home] [Help]

APPS.OKS_BILL_SCH dependencies on OKS_K_HEADERS_B

Line 834: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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) */

Line 835: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 836: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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

Line 841: FROM oks_k_headers_b khr

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:

Line 964: /*UPDATE OKS_K_HEADERS_B SET billing_schedule_type = p_billing_type

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: -------------------------------------------------------------------------

Line 1260: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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;

Line 1261: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 1262: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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: -------------------------------------------------------------------------

Line 4044: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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

Line 4045: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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: -------------------------------------------------------------------------

Line 4046: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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

Line 4663: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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

Line 4664: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 4665: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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: -------------------------------------------------------------------------

Line 5124: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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;

Line 5125: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 5126: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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: -------------------------------------------------------------------------

Line 5623: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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: ---------------------------------------------------------------------------

Line 5624: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 5625: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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:

Line 7980: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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;

Line 7981: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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:

Line 8419: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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: -------------------------------------------------------------------------

Line 8420: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 8421: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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

Line 8823: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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;

Line 8824: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 8825: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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: -------------------------------------------------------------------------

Line 10305: FROM okc_k_headers_b hdr, oks_k_headers_b dtl

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:

Line 10342: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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: -------------------------------------------------------------------------

Line 10343: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 10344: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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

Line 11710: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

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;

Line 11711: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

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

Line 11712: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

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: -------------------------------------------------------------------------