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.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 8: g_scs_code okc_k_headers_b.scs_code%TYPE := Okl_Api.G_MISS_CHAR;

4: g_resp_id NUMBER := Okl_Api.G_MISS_NUM;
5: g_user_resource_id okc_k_accesses.resource_id%TYPE := Okl_Api.G_MISS_NUM;
6: g_resp_access okc_k_accesses.access_level%TYPE := Okl_Api.G_MISS_CHAR;
7: g_reset_access_flag BOOLEAN := FALSE;
8: g_scs_code okc_k_headers_b.scs_code%TYPE := Okl_Api.G_MISS_CHAR;
9: g_groups_processed BOOLEAN := FALSE;
10: g_reset_lang_flag BOOLEAN := FALSE;
11: g_reset_resp_flag BOOLEAN := FALSE;
12: --varangan added the formula name variable for bug #5036582

Line 291: okc_k_headers_b chr,

287: --Transaction currency to Functional Curreny.
288: --dkagrawa changed the query to adopt new billing architecture
289: /*SELECT (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
290: FROM ar_cash_receipts_all ar,
291: okc_k_headers_b chr,
292: ar_receivable_applications_all ara,
293: okl_cnSld_ar_strms_b lsm
294: WHERE
295: ar.pay_from_customer = chr.cust_acct_id

Line 305: okc_k_headers_b chr

301:
302: SELECT (AR.amount * NVL(AR.exchange_rate,1)), AR.receipt_date
303: FROM ar_cash_receipts_all ar,
304: okl_receipt_applications_uv app,
305: okc_k_headers_b chr
306: WHERE chr.id = p_contract_id
307: AND ar.cash_receipt_id = app.cash_receipt_id
308: AND ar.pay_from_customer = p_customer_id
309: AND CHR.contract_number = app.contract_number

Line 581: FROM OKC_K_HEADERS_B CHR,okc_rule_groups_b RGP,okc_rules_b RUL

577: AND NVL (ste.amount, 0) <> 0;
578: --rkuttiya modifed for bug # 5031455 join condition of cursor to use dnz_chr_id instead of chr_id
579: CURSOR Interest_Type IS
580: SELECT DECODE(rule_information1, 'Y', 'Variable', 'N', 'Fixed', 'Unknown')
581: FROM OKC_K_HEADERS_B CHR,okc_rule_groups_b RGP,okc_rules_b RUL
582: WHERE CHR.ID = RGP.DNZ_CHR_ID AND
583: --CHR.ID = RGP.CHR_ID AND
584: RGP.ID = RUL.RGP_ID AND
585: RUL.rule_information_category = 'LAINTP' AND

Line 719: FROM okc_k_headers_b

715: RETURN VARCHAR2
716: IS
717: CURSOR currency_cur(p_contract_id NUMBER) IS
718: SELECT currency_code
719: FROM okc_k_headers_b
720: WHERE id = p_contract_id;
721: l_currency VARCHAR2(240);
722: l_api_version NUMBER;
723: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 752: SELECT 'Y' FROM okc_k_headers_b CHR

748: x_syndicate_flag OUT NOCOPY VARCHAR2)
749: RETURN VARCHAR2
750: IS
751: CURSOR syndicate_flag_cur(p_contract_id NUMBER) IS
752: SELECT 'Y' FROM okc_k_headers_b CHR
753: WHERE id = p_contract_id
754: AND EXISTS
755: (
756: SELECT 'x' FROM okc_k_items cim

Line 767: SELECT 'x' FROM okc_k_headers_b chr2

763: AND cle.id = cim.cle_id
764: )
765: AND EXISTS
766: (
767: SELECT 'x' FROM okc_k_headers_b chr2
768: WHERE chr2.id = cim.dnz_chr_id
769: AND chr2.scs_code = 'SYNDICATION'
770: AND chr2.sts_code NOT IN ('TERMINATED','ABANDONED')
771: )

Line 807: FROM okc_k_headers_b

803: RETURN VARCHAR2 AS
804: -- get org_id for contract
805: CURSOR get_org_id_cur (p_contract_id IN VARCHAR2) IS
806: SELECT authoring_org_id
807: FROM okc_k_headers_b
808: WHERE id = p_contract_id;
809: l_api_version NUMBER;
810: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
811: l_msg_count NUMBER;

Line 874: SELECT 'Y' FROM okc_k_headers_b CHR

870: )
871: RETURN VARCHAR2
872: IS
873: CURSOR syndicate_flag_cur(p_contract_id NUMBER) IS
874: SELECT 'Y' FROM okc_k_headers_b CHR
875: WHERE id = p_contract_id
876: AND EXISTS
877: (
878: SELECT 'x' FROM okc_k_items cim

Line 889: SELECT 'x' FROM okc_k_headers_b chr2

885: AND cle.id = cim.cle_id
886: )
887: AND EXISTS
888: (
889: SELECT 'x' FROM okc_k_headers_b chr2
890: WHERE chr2.id = cim.dnz_chr_id
891: AND chr2.scs_code = 'SYNDICATION'
892: AND chr2.sts_code NOT IN ('TERMINATED','ABANDONED')
893: )

Line 935: l_scs_code okc_k_headers_b.scs_code%TYPE;

931: END;
932: FUNCTION Get_K_Access_Level(p_chr_id IN NUMBER,
933: p_scs_code IN VARCHAR2 DEFAULT NULL)
934: RETURN VARCHAR2 IS
935: l_scs_code okc_k_headers_b.scs_code%TYPE;
936: l_modify_access CONSTANT VARCHAR2(1) := 'U';
937: l_read_access CONSTANT VARCHAR2(1) := 'R';
938: l_no_access CONSTANT VARCHAR2(1) := 'N';
939: l_resp_access okc_subclass_resps.access_level%TYPE;

Line 953: FROM okc_k_headers_b

949: -- This cursor retrieves the sub class code for the contract. This is
950: -- executed only if the subclass is not passed in
951: CURSOR chr_csr IS
952: SELECT scs_code
953: FROM okc_k_headers_b
954: WHERE id = p_chr_id;
955: -- This cursor checks to see the type of access granted to the current
956: -- user'S responsibility TO the sub class
957: CURSOR resp_csr IS

Line 1330: SELECT sts_code FROM okc_k_headers_b

1326: x_allowed OUT NOCOPY VARCHAR2 )
1327: RETURN VARCHAR2
1328: IS
1329: CURSOR okl_status_cur(p_contract_id NUMBER) IS
1330: SELECT sts_code FROM okc_k_headers_b
1331: WHERE ID = p_contract_id;
1332:
1333: CURSOR okc_status_cur(p_okl_status VARCHAR2) IS
1334: SELECT ste_code FROM okc_statuses_b

Line 1924: OKC_K_HEADERS_B OKC

1920: SELECT SUM(NVL(APS.AMOUNT_ADJUSTED,0)) AMOUNT_ADJUSTED
1921: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1922: RA_CUSTOMER_TRX_ALL RACTRX,
1923: RA_CUSTOMER_TRX_LINES_ALL RACTRX_LINE,
1924: OKC_K_HEADERS_B OKC
1925: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1926: AND RACTRX.CUSTOMER_TRX_ID = RACTRX_LINE.CUSTOMER_TRX_ID
1927: AND OKC.CONTRACT_NUMBER = RACTRX_LINE.INTERFACE_LINE_ATTRIBUTE6
1928: AND OKC.ID = cp_khr_id;