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_RENCPY_PVT dependencies on STANDARD

Line 1490: l_standard_cov_yn VARCHAR2(1);

1486: l_api_name CONSTANT VARCHAR2(50) := 'COPY_CONTRACT_LINE.INSTANTIATE_COUNTERS_EVENTS';
1487: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
1488:
1489: l_item_id VARCHAR2(40);
1490: l_standard_cov_yn VARCHAR2(1);
1491: l_counter_grp_id NUMBER;
1492: l_found BOOLEAN;
1493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1494: l_ctr_grp_id_template NUMBER;

Line 1500: SELECT a.object1_id1, b.standard_cov_yn

1496: l_instcnd_inp_rec OKC_INST_CND_PUB.instcnd_inp_rec;
1497: l_actual_coverage_id NUMBER;
1498:
1499: CURSOR c_item IS
1500: SELECT a.object1_id1, b.standard_cov_yn
1501: FROM okc_k_items a, oks_k_lines_b b
1502: WHERE a.cle_id = p_old_cle_id
1503: AND b.cle_id = p_old_cle_id;
1504:

Line 1518: FETCH c_item INTO l_item_id, l_standard_cov_yn;

1514: END IF;
1515:
1516: x_return_status := l_return_status;
1517: OPEN c_item;
1518: FETCH c_item INTO l_item_id, l_standard_cov_yn;
1519: CLOSE c_item;
1520:
1521: IF l_item_id IS NOT NULL AND Is_Number(l_item_id) THEN
1522:

Line 1590: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.chk_cov_type','p_old_lse_id='||p_old_lse_id||' ,l_standard_cov_yn='||l_standard_cov_yn);

1586: END IF;
1587:
1588:
1589: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1590: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.chk_cov_type','p_old_lse_id='||p_old_lse_id||' ,l_standard_cov_yn='||l_standard_cov_yn);
1591: END IF;
1592:
1593: IF p_old_lse_id IN (1,19) THEN
1594:

Line 1595: --Instantiate the coverage, if only if it's a non standard coverage

1591: END IF;
1592:
1593: IF p_old_lse_id IN (1,19) THEN
1594:
1595: --Instantiate the coverage, if only if it's a non standard coverage
1596: IF (l_standard_cov_yn = 'N') THEN
1597:
1598: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1599: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_adj_cov','calling OKS_COVERAGES_PUB.create_adjusted_coverage, P_Source_contract_Line_Id='||p_old_cle_id||' ,P_Target_contract_Line_Id='||p_new_cle_id);

Line 1596: IF (l_standard_cov_yn = 'N') THEN

1592:
1593: IF p_old_lse_id IN (1,19) THEN
1594:
1595: --Instantiate the coverage, if only if it's a non standard coverage
1596: IF (l_standard_cov_yn = 'N') THEN
1597:
1598: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1599: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_adj_cov','calling OKS_COVERAGES_PUB.create_adjusted_coverage, P_Source_contract_Line_Id='||p_old_cle_id||' ,P_Target_contract_Line_Id='||p_new_cle_id);
1600: END IF;

Line 1629: --for both standard and non standard coverage, need to copy

1625: WHERE cle_id = p_new_cle_id;
1626: END IF;
1627:
1628:
1629: --for both standard and non standard coverage, need to copy
1630: --coverage notes and pm schedules. These coverage entities are
1631: --associated to the topline and the not the coverage
1632:
1633: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

Line 1909: --standard api initilization and checks

1905: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_cle_id='||p_from_cle_id||' ,p_from_chr_id='||p_from_chr_id||' ,p_to_cle_id='||p_to_cle_id||' ,p_to_chr_id='||p_to_chr_id||' ,p_lse_id='||p_lse_id||
1906: ' ,p_to_template_yn='||p_to_template_yn||' ,p_copy_reference='||p_copy_reference||' ,p_copy_line_party_yn='||p_copy_line_party_yn||' ,p_renew_ref_yn='||p_renew_ref_yn||' ,p_need_conversion='||p_need_conversion);
1907: END IF;
1908:
1909: --standard api initilization and checks
1910: SAVEPOINT copy_contract_line_PVT;
1911: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
1912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1913: END IF;

Line 3242: ,standard_cov_yn

3238: ,tax_classification_code
3239: ,exempt_certificate_number
3240: ,exempt_reason_code
3241: ,coverage_id
3242: ,standard_cov_yn
3243: ,orig_system_id1
3244: ,orig_system_reference1
3245: ,orig_system_source_code
3246: ,counter_value_id

Line 3354: ,x_klnv_rec.standard_cov_yn

3350: ,x_klnv_rec.tax_classification_code
3351: ,x_klnv_rec.exempt_certificate_number
3352: ,x_klnv_rec.exempt_reason_code
3353: ,x_klnv_rec.coverage_id
3354: ,x_klnv_rec.standard_cov_yn
3355: ,x_klnv_rec.orig_system_id1
3356: ,x_klnv_rec.orig_system_reference1
3357: ,x_klnv_rec.orig_system_source_code
3358: ,x_klnv_rec.counter_value_id;

Line 4278: --standard api initilization and checks

4274: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4275: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_old_trx_ext_id='||p_old_trx_ext_id||' ,p_order_id='||p_order_id||' ,p_cust_acct_id='||p_cust_acct_id||' ,p_bill_to_site_use_id='||p_bill_to_site_use_id);
4276: END IF;
4277:
4278: --standard api initilization and checks
4279: SAVEPOINT create_trxn_extn_PVT;
4280: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4282: END IF;