eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 4061: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

4057: -- Begin partial period computation logic
4058: -- Developer Mani Choudhary
4059: -- Date 04-MAY-2005
4060: -------------------------------------------------------------------------
4061: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4062: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4063: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4064: l_tangible BOOLEAN;
4065: l_pricing_method Varchar2(30);

Line 4062: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

4058: -- Developer Mani Choudhary
4059: -- Date 04-MAY-2005
4060: -------------------------------------------------------------------------
4061: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4062: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4063: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4064: l_tangible BOOLEAN;
4065: l_pricing_method Varchar2(30);
4066: -------------------------------------------------------------------------

Line 4063: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

4059: -- Date 04-MAY-2005
4060: -------------------------------------------------------------------------
4061: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4062: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4063: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4064: l_tangible BOOLEAN;
4065: l_pricing_method Varchar2(30);
4066: -------------------------------------------------------------------------
4067: -- End partial period computation logic

Line 4680: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

4676: -- Begin partial period computation logic
4677: -- Developer Mani Choudhary
4678: -- Date 04-MAY-2005
4679: -------------------------------------------------------------------------
4680: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4681: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4682: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4683: -------------------------------------------------------------------------
4684: -- End partial period computation logic

Line 4681: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

4677: -- Developer Mani Choudhary
4678: -- Date 04-MAY-2005
4679: -------------------------------------------------------------------------
4680: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4681: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4682: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4683: -------------------------------------------------------------------------
4684: -- End partial period computation logic
4685: -- Date 04-MAY-2005

Line 4682: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

4678: -- Date 04-MAY-2005
4679: -------------------------------------------------------------------------
4680: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
4681: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
4682: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
4683: -------------------------------------------------------------------------
4684: -- End partial period computation logic
4685: -- Date 04-MAY-2005
4686: -------------------------------------------------------------------------

Line 5141: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

5137: -- Begin partial period computation logic
5138: -- Developer Mani Choudhary
5139: -- Date 04-MAY-2005
5140: -------------------------------------------------------------------------
5141: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5142: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5143: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5144: l_return_status VARCHAR2(30);
5145: l_tangible BOOLEAN;

Line 5142: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

5138: -- Developer Mani Choudhary
5139: -- Date 04-MAY-2005
5140: -------------------------------------------------------------------------
5141: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5142: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5143: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5144: l_return_status VARCHAR2(30);
5145: l_tangible BOOLEAN;
5146: l_pricing_method VARCHAR2(30);

Line 5143: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

5139: -- Date 04-MAY-2005
5140: -------------------------------------------------------------------------
5141: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5142: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5143: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5144: l_return_status VARCHAR2(30);
5145: l_tangible BOOLEAN;
5146: l_pricing_method VARCHAR2(30);
5147: -------------------------------------------------------------------------

Line 5640: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

5636: -- Developer Mani Choudhary
5637: -- Date 04-MAY-2005
5638: -- Local variables and cursors defined here required for cascade
5639: ---------------------------------------------------------------------------
5640: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5641: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5642: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5643: l_level_periods NUMBER;
5644: ---------------------------------------------------------------------------

Line 5641: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

5637: -- Date 04-MAY-2005
5638: -- Local variables and cursors defined here required for cascade
5639: ---------------------------------------------------------------------------
5640: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5641: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5642: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5643: l_level_periods NUMBER;
5644: ---------------------------------------------------------------------------
5645: l_end_date DATE; /*Added for ceredian bug 13799709*/

Line 5642: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

5638: -- Local variables and cursors defined here required for cascade
5639: ---------------------------------------------------------------------------
5640: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
5641: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
5642: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
5643: l_level_periods NUMBER;
5644: ---------------------------------------------------------------------------
5645: l_end_date DATE; /*Added for ceredian bug 13799709*/
5646:

Line 8193: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

8189: -- Developer Mani Choudhary
8190: -- Date 09-MAY-2005
8191: -------------------------------------------------------------------------
8192: l_pricing_method Varchar2(30);
8193: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8194: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8195: BEGIN
8196:
8197: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 8194: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

8190: -- Date 09-MAY-2005
8191: -------------------------------------------------------------------------
8192: l_pricing_method Varchar2(30);
8193: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8194: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8195: BEGIN
8196:
8197: x_return_status := OKC_API.G_RET_STS_SUCCESS;
8198:

Line 8632: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

8628: -- Begin partial period computation logic
8629: -- Developer Mani Choudhary
8630: -- Date 04-MAY-2005
8631: -------------------------------------------------------------------------
8632: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8633: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8634: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8635: l_return_status VARCHAR2(30);
8636: -------------------------------------------------------------------------

Line 8633: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

8629: -- Developer Mani Choudhary
8630: -- Date 04-MAY-2005
8631: -------------------------------------------------------------------------
8632: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8633: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8634: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8635: l_return_status VARCHAR2(30);
8636: -------------------------------------------------------------------------
8637: -- End partial period computation logic

Line 8634: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

8630: -- Date 04-MAY-2005
8631: -------------------------------------------------------------------------
8632: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8633: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8634: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8635: l_return_status VARCHAR2(30);
8636: -------------------------------------------------------------------------
8637: -- End partial period computation logic
8638: -- Date 04-MAY-2005

Line 9036: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

9032: -- Begin partial period computation logic
9033: -- Developer Mani Choudhary
9034: -- Date 04-MAY-2005
9035: -------------------------------------------------------------------------
9036: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9037: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9038: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9039: l_return_status VARCHAR2(30);
9040: l_tangible BOOLEAN;

Line 9037: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

9033: -- Developer Mani Choudhary
9034: -- Date 04-MAY-2005
9035: -------------------------------------------------------------------------
9036: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9037: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9038: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9039: l_return_status VARCHAR2(30);
9040: l_tangible BOOLEAN;
9041: l_pricing_method VARCHAR2(30);

Line 9038: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

9034: -- Date 04-MAY-2005
9035: -------------------------------------------------------------------------
9036: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9037: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9038: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9039: l_return_status VARCHAR2(30);
9040: l_tangible BOOLEAN;
9041: l_pricing_method VARCHAR2(30);
9042: -------------------------------------------------------------------------

Line 10548: FROM okc_k_headers_b hdr, oks_k_headers_b dtl

10544: Cursor l_contract_Csr Is
10545: SELECT hdr.id, TRUNC(hdr.start_date) start_dt,
10546: nvl(trunc(hdr.date_terminated - 1) ,TRUNC(hdr.end_date)) end_dt,
10547: hdr.inv_rule_id inv_rule_id, dtl.billing_schedule_type billing_schedule_type
10548: FROM okc_k_headers_b hdr, oks_k_headers_b dtl
10549: WHERE hdr.id = dtl.chr_id
10550: AND hdr.Id = p_contract_id ;
10551:
10552:

Line 10585: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

10581: -- Begin partial period computation logic
10582: -- Developer Mani Choudhary
10583: -- Date 04-MAY-2005
10584: -------------------------------------------------------------------------
10585: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
10586: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
10587: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
10588: l_return_status VARCHAR2(30);
10589: -------------------------------------------------------------------------

Line 10586: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

10582: -- Developer Mani Choudhary
10583: -- Date 04-MAY-2005
10584: -------------------------------------------------------------------------
10585: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
10586: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
10587: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
10588: l_return_status VARCHAR2(30);
10589: -------------------------------------------------------------------------
10590: -- End partial period computation logic

Line 10587: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

10583: -- Date 04-MAY-2005
10584: -------------------------------------------------------------------------
10585: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
10586: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
10587: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
10588: l_return_status VARCHAR2(30);
10589: -------------------------------------------------------------------------
10590: -- End partial period computation logic
10591: -- Date 04-MAY-2005

Line 11953: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

11949: -- Begin partial period computation logic
11950: -- Developer Mani Choudhary
11951: -- Date 04-MAY-2005
11952: -------------------------------------------------------------------------
11953: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
11954: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
11955: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
11956: l_return_status VARCHAR2(30);
11957: l_tangible BOOLEAN;

Line 11954: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

11950: -- Developer Mani Choudhary
11951: -- Date 04-MAY-2005
11952: -------------------------------------------------------------------------
11953: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
11954: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
11955: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
11956: l_return_status VARCHAR2(30);
11957: l_tangible BOOLEAN;
11958: l_pricing_method VARCHAR2(30);

Line 11955: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

11951: -- Date 04-MAY-2005
11952: -------------------------------------------------------------------------
11953: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
11954: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
11955: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
11956: l_return_status VARCHAR2(30);
11957: l_tangible BOOLEAN;
11958: l_pricing_method VARCHAR2(30);
11959: -------------------------------------------------------------------------