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_UBB_INTEGRATION_PVT dependencies on OKC_K_HEADERS_V

Line 45: CURSOR usage_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

41: );
42:
43: -- Cursors
44: --Fixed Bug # 5484903
45: CURSOR usage_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
46: select *
47: from okl_k_lines_full_v line
48: where line.dnz_chr_id = p_chr_id and
49: --Bug# 6374869: subquesry was fetching multiple records as 'USAGE' line

Line 67: CURSOR link_asset_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

63:
64:
65: g_usage_rec usage_csr%ROWTYPE;
66:
67: CURSOR link_asset_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
68: p_usage_line_id OKC_K_LINES_V.ID%TYPE) IS
69: SELECT id,
70: name ASSET_NUMBER,
71: line_number

Line 82: CURSOR ib_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

78: FROM okc_statuses_v okcsts
79: WHERE okcsts.code = line.sts_code
80: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
81:
82: CURSOR ib_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
83: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
84: SELECT ib_line.id,
85: ib_line.line_number
86: FROM okl_k_lines_full_v ib_line,

Line 97: CURSOR counter_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

93: AND top_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM1')
94: AND top_line.id = p_top_line_id
95: AND top_line.dnz_chr_id = p_chr_id;
96:
97: CURSOR counter_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
98: p_usage_item_id NUMBER,
99: p_ib_line_id OKC_K_LINES_V.ID%TYPE) IS
100: SELECT cc.counter_id,
101: cc.uom_code

Line 173: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_rule_information_category IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
171: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
172: p_jtot_object1_code IN OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,
173: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
174: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
175: x_rulv_rec OUT NOCOPY rulv_rec_type
176: ) IS
177:

Line 182: p_chr_id OKC_K_HEADERS_V.ID%TYPE,

178:
179: CURSOR rulv_csr (p_rule_info_catg OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
180: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
181: p_jtot_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE,
182: p_chr_id OKC_K_HEADERS_V.ID%TYPE,
183: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
184: SELECT
185: rule.ID,
186: rule.OBJECT_VERSION_NUMBER,

Line 389: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

385: PROCEDURE get_party_id(
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,
388: x_msg_data OUT NOCOPY VARCHAR2,
389: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
390: p_rle_code IN OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,
391: p_jtot_object1_code IN OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE,
392: x_party_id OUT NOCOPY OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE
393: ) IS

Line 395: CURSOR party_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,

391: p_jtot_object1_code IN OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE,
392: x_party_id OUT NOCOPY OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE
393: ) IS
394: --Fixed Bug # 5484903
395: CURSOR party_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
396: p_rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,
397: p_jtot_object1_code OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE) IS
398: SELECT object1_id1
399: FROM okc_k_party_roles_b

Line 1001: CURSOR oks_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

997: l_authoring_org_id NUMBER;
998:
999: l_uom_code mtl_system_items.primary_uom_code%TYPE;
1000:
1001: CURSOR oks_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1002: SELECT start_date,
1003: end_date,
1004: authoring_org_id
1005: FROM okc_k_headers_v

Line 1005: FROM okc_k_headers_v

1001: CURSOR oks_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1002: SELECT start_date,
1003: end_date,
1004: authoring_org_id
1005: FROM okc_k_headers_v
1006: WHERE id = p_chr_id;
1007:
1008: /*
1009: CURSOR ra_rule_csr (p_name ra_rules.name%TYPE) IS

Line 1354: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1350: PROCEDURE get_top_line_id (
1351: x_return_status OUT NOCOPY VARCHAR2,
1352: x_msg_count OUT NOCOPY NUMBER,
1353: x_msg_data OUT NOCOPY VARCHAR2,
1354: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1355: p_link_asset_line_id IN OKL_K_LINES_FULL_V.ID%TYPE,
1356: p_link_asset_line_no IN OKL_K_LINES_FULL_V.LINE_NUMBER%TYPE,
1357: x_top_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
1358: ) IS

Line 1364: CURSOR top_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

1360: l_id OKC_K_LINES_V.ID%TYPE;
1361: top_failed EXCEPTION;
1362: l_proc_name VARCHAR2(35) := 'GET_TOP_LINE_ID';
1363:
1364: CURSOR top_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1365: p_link_asset_line_id OKL_K_LINES_FULL_V.ID%TYPE) IS
1366: SELECT oki.object1_id1
1367: FROM okl_k_lines_full_v oklf,
1368: okc_k_items oki

Line 1604: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1600: p_init_msg_list IN VARCHAR2,
1601: x_return_status OUT NOCOPY VARCHAR2,
1602: x_msg_count OUT NOCOPY NUMBER,
1603: x_msg_data OUT NOCOPY VARCHAR2,
1604: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1605: x_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
1606: ) IS
1607:
1608: l_proc_name VARCHAR2(35) := 'CREATE_UBB_CONTRACT';

Line 1605: x_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE

1601: x_return_status OUT NOCOPY VARCHAR2,
1602: x_msg_count OUT NOCOPY NUMBER,
1603: x_msg_data OUT NOCOPY VARCHAR2,
1604: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1605: x_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
1606: ) IS
1607:
1608: l_proc_name VARCHAR2(35) := 'CREATE_UBB_CONTRACT';
1609: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_UBB_CONTRACT';

Line 2148: p_okl_header_id IN OKC_K_HEADERS_V.ID%TYPE,

2144: PROCEDURE link_oks_header(
2145: x_return_status OUT NOCOPY VARCHAR2,
2146: x_msg_count OUT NOCOPY NUMBER,
2147: x_msg_data OUT NOCOPY VARCHAR2,
2148: p_okl_header_id IN OKC_K_HEADERS_V.ID%TYPE,
2149: p_oks_header_id IN OKC_K_HEADERS_V.ID%TYPE
2150: ) IS
2151: l_proc_name VARCHAR2(35) := 'LINK_OKS_HEADER';
2152: l_crjv_rec crjv_rec_type;

Line 2149: p_oks_header_id IN OKC_K_HEADERS_V.ID%TYPE

2145: x_return_status OUT NOCOPY VARCHAR2,
2146: x_msg_count OUT NOCOPY NUMBER,
2147: x_msg_data OUT NOCOPY VARCHAR2,
2148: p_okl_header_id IN OKC_K_HEADERS_V.ID%TYPE,
2149: p_oks_header_id IN OKC_K_HEADERS_V.ID%TYPE
2150: ) IS
2151: l_proc_name VARCHAR2(35) := 'LINK_OKS_HEADER';
2152: l_crjv_rec crjv_rec_type;
2153: x_crjv_rec crjv_rec_type;

Line 2214: p_okl_header_id IN OKC_K_HEADERS_V.ID%TYPE,

2210: PROCEDURE link_oks_line(
2211: x_return_status OUT NOCOPY VARCHAR2,
2212: x_msg_count OUT NOCOPY NUMBER,
2213: x_msg_data OUT NOCOPY VARCHAR2,
2214: p_okl_header_id IN OKC_K_HEADERS_V.ID%TYPE,
2215: p_okl_usage_line_id IN OKC_K_LINES_V.ID%TYPE,
2216: p_oks_usage_line_id IN OKC_K_LINES_V.ID%TYPE
2217: ) IS
2218: CURSOR item_csr (p_cle_id NUMBER) IS