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_OC_INT_KTO_PVT dependencies on OKC_K_HEADERS_B

Line 40: FROM okc_k_headers_b

36: ,date_renewed
37: ,scs_code
38: ,total_line_list_price
39: ,price_list_id
40: FROM okc_k_headers_b
41: WHERE id = p_chr_id;
42:
43: -- 4915691 --
44: -- Cursor for contract line information

Line 76: okc_k_headers_b kh,

72: ks.cls_code ,
73: ks.meaning ,
74: kst.ste_code
75: FROM okc_statuses_b kst,
76: okc_k_headers_b kh,
77: okc_subclasses_v ks
78: WHERE kh.id = p_chr_id
79: AND ks.code = kh.scs_code
80: AND kst.code = kh.sts_code;

Line 138: chr_id okc_k_headers_b.id%TYPE

134: TYPE line_info_tab_typ IS TABLE OF line_info_rec_typ INDEX BY BINARY_INTEGER;
135:
136: TYPE kh_attr_rec_type IS RECORD
137: (
138: chr_id okc_k_headers_b.id%TYPE
139: ,CUST_ACCT_ID okc_k_headers_b.CUST_ACCT_ID%TYPE
140: ,BILL_TO_SITE_USE_ID okc_k_headers_b.BILL_TO_SITE_USE_ID%TYPE
141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE
142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE

Line 139: ,CUST_ACCT_ID okc_k_headers_b.CUST_ACCT_ID%TYPE

135:
136: TYPE kh_attr_rec_type IS RECORD
137: (
138: chr_id okc_k_headers_b.id%TYPE
139: ,CUST_ACCT_ID okc_k_headers_b.CUST_ACCT_ID%TYPE
140: ,BILL_TO_SITE_USE_ID okc_k_headers_b.BILL_TO_SITE_USE_ID%TYPE
141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE
142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE
143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE

Line 140: ,BILL_TO_SITE_USE_ID okc_k_headers_b.BILL_TO_SITE_USE_ID%TYPE

136: TYPE kh_attr_rec_type IS RECORD
137: (
138: chr_id okc_k_headers_b.id%TYPE
139: ,CUST_ACCT_ID okc_k_headers_b.CUST_ACCT_ID%TYPE
140: ,BILL_TO_SITE_USE_ID okc_k_headers_b.BILL_TO_SITE_USE_ID%TYPE
141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE
142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE
143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE
144: ,CONVERSION_RATE okc_k_headers_b.CONVERSION_RATE%TYPE

Line 141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE

137: (
138: chr_id okc_k_headers_b.id%TYPE
139: ,CUST_ACCT_ID okc_k_headers_b.CUST_ACCT_ID%TYPE
140: ,BILL_TO_SITE_USE_ID okc_k_headers_b.BILL_TO_SITE_USE_ID%TYPE
141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE
142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE
143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE
144: ,CONVERSION_RATE okc_k_headers_b.CONVERSION_RATE%TYPE
145: ,CONVERSION_RATE_DATE okc_k_headers_b.CONVERSION_RATE_DATE%TYPE

Line 142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE

138: chr_id okc_k_headers_b.id%TYPE
139: ,CUST_ACCT_ID okc_k_headers_b.CUST_ACCT_ID%TYPE
140: ,BILL_TO_SITE_USE_ID okc_k_headers_b.BILL_TO_SITE_USE_ID%TYPE
141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE
142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE
143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE
144: ,CONVERSION_RATE okc_k_headers_b.CONVERSION_RATE%TYPE
145: ,CONVERSION_RATE_DATE okc_k_headers_b.CONVERSION_RATE_DATE%TYPE
146: ,CONVERSION_EURO_RATE okc_k_headers_b.CONVERSION_EURO_RATE%TYPE

Line 143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE

139: ,CUST_ACCT_ID okc_k_headers_b.CUST_ACCT_ID%TYPE
140: ,BILL_TO_SITE_USE_ID okc_k_headers_b.BILL_TO_SITE_USE_ID%TYPE
141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE
142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE
143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE
144: ,CONVERSION_RATE okc_k_headers_b.CONVERSION_RATE%TYPE
145: ,CONVERSION_RATE_DATE okc_k_headers_b.CONVERSION_RATE_DATE%TYPE
146: ,CONVERSION_EURO_RATE okc_k_headers_b.CONVERSION_EURO_RATE%TYPE
147: );

Line 144: ,CONVERSION_RATE okc_k_headers_b.CONVERSION_RATE%TYPE

140: ,BILL_TO_SITE_USE_ID okc_k_headers_b.BILL_TO_SITE_USE_ID%TYPE
141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE
142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE
143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE
144: ,CONVERSION_RATE okc_k_headers_b.CONVERSION_RATE%TYPE
145: ,CONVERSION_RATE_DATE okc_k_headers_b.CONVERSION_RATE_DATE%TYPE
146: ,CONVERSION_EURO_RATE okc_k_headers_b.CONVERSION_EURO_RATE%TYPE
147: );
148:

Line 145: ,CONVERSION_RATE_DATE okc_k_headers_b.CONVERSION_RATE_DATE%TYPE

141: ,INV_RULE_ID okc_k_headers_b.INV_RULE_ID%TYPE
142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE
143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE
144: ,CONVERSION_RATE okc_k_headers_b.CONVERSION_RATE%TYPE
145: ,CONVERSION_RATE_DATE okc_k_headers_b.CONVERSION_RATE_DATE%TYPE
146: ,CONVERSION_EURO_RATE okc_k_headers_b.CONVERSION_EURO_RATE%TYPE
147: );
148:
149: TYPE kh_attr_tbl_type IS TABLE OF kh_attr_rec_type INDEX BY BINARY_INTEGER;

Line 146: ,CONVERSION_EURO_RATE okc_k_headers_b.CONVERSION_EURO_RATE%TYPE

142: ,SHIP_TO_SITE_USE_ID okc_k_headers_b.SHIP_TO_SITE_USE_ID%TYPE
143: ,CONVERSION_TYPE okc_k_headers_b.CONVERSION_TYPE%TYPE
144: ,CONVERSION_RATE okc_k_headers_b.CONVERSION_RATE%TYPE
145: ,CONVERSION_RATE_DATE okc_k_headers_b.CONVERSION_RATE_DATE%TYPE
146: ,CONVERSION_EURO_RATE okc_k_headers_b.CONVERSION_EURO_RATE%TYPE
147: );
148:
149: TYPE kh_attr_tbl_type IS TABLE OF kh_attr_rec_type INDEX BY BINARY_INTEGER;
150: l_kh_attr_tab kh_attr_tbl_type;

Line 168: chr_id okc_k_headers_b.id%TYPE,

164: l_kl_attr_tab kl_attr_tbl_type;
165:
166: TYPE bto_sto_rec_typ IS RECORD
167: (
168: chr_id okc_k_headers_b.id%TYPE,
169: cle_id okc_k_lines_b.id%TYPE,
170: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
171: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
172: party_id okx_cust_site_uses_v.party_id%TYPE,

Line 298: PROCEDURE build_k_attributes( p_chr_id IN okc_k_headers_b.ID%TYPE,

294: -- x_sto_data_rec STO details
295:
296: ---------------------------------------------------------------------
297:
298: PROCEDURE build_k_attributes( p_chr_id IN okc_k_headers_b.ID%TYPE,
299: p_cle_id IN okc_k_lines_v.id%TYPE,
300: x_hdr_attr_tab OUT NOCOPY kh_attr_tbl_type,
301: x_line_attr_tab OUT NOCOPY kl_attr_tbl_type,
302: x_bto_data_rec OUT NOCOPY bto_sto_rec_typ,

Line 318: FROM OKC_K_HEADERS_B

314: ,CONVERSION_TYPE
315: ,CONVERSION_RATE
316: ,CONVERSION_RATE_DATE
317: ,CONVERSION_EURO_RATE
318: FROM OKC_K_HEADERS_B
319: WHERE id = p_chr_id;
320:
321: --cursor for getting line rules/attributes
322:

Line 547: p_chr_id IN okc_k_headers_b.ID%TYPE

543: -- Out Parameters: x_return_status standard return status
544: ---------------------------------------------------------------------
545:
546: PROCEDURE validate_k_eligibility(
547: p_chr_id IN okc_k_headers_b.ID%TYPE
548: ,p_k_header_rec IN c_k_header%ROWTYPE
549: ,x_return_status OUT NOCOPY VARCHAR2
550: ) IS
551:

Line 598: PROCEDURE build_k_structures (p_chr_id IN okc_k_headers_b.ID%TYPE

594: -- In Parameters: p_chr_id the contract id
595: -- Out Parameters: x_return_status standard return status
596: -----------------------------------------------------------------------------
597:
598: PROCEDURE build_k_structures (p_chr_id IN okc_k_headers_b.ID%TYPE
599: ,p_cle_id IN okc_k_lines_b.id%TYPE
600: ,p_k_header_rec IN c_k_header%ROWTYPE
601: ,x_return_status OUT NOCOPY VARCHAR2
602: ) IS

Line 1259: ,p_contract_id IN okc_k_headers_b.ID%TYPE

1255: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1256: ,x_return_status OUT NOCOPY VARCHAR2
1257: ,x_msg_count OUT NOCOPY NUMBER
1258: ,x_msg_data OUT NOCOPY VARCHAR2
1259: ,p_contract_id IN okc_k_headers_b.ID%TYPE
1260: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
1261: ,P_Customer_id IN NUMBER
1262: ,P_Grp_id IN NUMBER
1263: ,P_org_id IN NUMBER

Line 1353: okc_k_headers_b hdr,

1349: select
1350: hdr.id,
1351: hdr.contract_number
1352: from
1353: okc_k_headers_b hdr,
1354: okc_k_party_roles_b pr
1355: where hdr.id = nvl(p_contract_id ,hdr.id)
1356: and hdr.id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),hdr.id)
1357: and nvl(nvl(p_contract_id,p_contract_hdr_id_hi),hdr.id)

Line 1401: okc_k_headers_b hdr,

1397: sub.end_date,
1398: sub.om_interface_date,
1399: hdr.contract_number
1400: from oks_subscr_elements sub,
1401: okc_k_headers_b hdr,
1402: okc_k_party_roles_b pr,
1403: okc_statuses_b st
1404: where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)
1405: --== and sub.dnz_chr_id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),sub.dnz_chr_id)