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_LINES_V

Line 68: p_usage_line_id OKC_K_LINES_V.ID%TYPE) IS

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
72: FROM OKL_K_LINES_FULL_V line

Line 83: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS

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,
87: okl_k_lines_full_v inst_line,

Line 99: p_ib_line_id OKC_K_LINES_V.ID%TYPE) IS

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
102: FROM cs_counter_groups csg,
103: cs_counters cc,

Line 174: p_cle_id IN OKC_K_LINES_V.ID%TYPE,

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

Line 183: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

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,
187: rule.SFWT_FLAG,

Line 1357: x_top_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

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
1359:
1360: l_id OKC_K_LINES_V.ID%TYPE;
1361: top_failed EXCEPTION;

Line 1360: l_id OKC_K_LINES_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
1359:
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,

Line 1431: p_okl_usage_line_id IN OKC_K_LINES_V.ID%TYPE,

1427: procedure update_counter_instance (
1428: x_return_status OUT NOCOPY VARCHAR2,
1429: x_msg_count OUT NOCOPY NUMBER,
1430: x_msg_data OUT NOCOPY VARCHAR2,
1431: p_okl_usage_line_id IN OKC_K_LINES_V.ID%TYPE,
1432: p_oks_usage_line_id IN OKC_K_LINES_V.ID%TYPE) is
1433:
1434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1435: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER_INSTANCE';

Line 1432: p_oks_usage_line_id IN OKC_K_LINES_V.ID%TYPE) is

1428: x_return_status OUT NOCOPY VARCHAR2,
1429: x_msg_count OUT NOCOPY NUMBER,
1430: x_msg_data OUT NOCOPY VARCHAR2,
1431: p_okl_usage_line_id IN OKC_K_LINES_V.ID%TYPE,
1432: p_oks_usage_line_id IN OKC_K_LINES_V.ID%TYPE) is
1433:
1434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1435: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER_INSTANCE';
1436: l_api_version CONSTANT NUMBER := 1.0;

Line 1613: x_top_line_id OKC_K_LINES_V.ID%TYPE;

1609: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_UBB_CONTRACT';
1610: l_api_version CONSTANT NUMBER := 1;
1611: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1612:
1613: x_top_line_id OKC_K_LINES_V.ID%TYPE;
1614: x_usage_item_id CS_COUNTERS.USAGE_ITEM_ID%TYPE;
1615:
1616: l_usage_count NUMBER := 0;
1617: l_link_asset_count NUMBER := 0;

Line 2215: p_okl_usage_line_id IN OKC_K_LINES_V.ID%TYPE,

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
2219: SELECT id

Line 2216: p_oks_usage_line_id IN OKC_K_LINES_V.ID%TYPE

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
2219: SELECT id
2220: FROM okc_k_items_v