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.OKC_CNL_PVT dependencies on OKC_ACTION_ATTRIBUTES_V

Line 778: FROM Okc_Action_Attributes_V

774: CREATION_DATE,
775: LAST_UPDATED_BY,
776: LAST_UPDATE_DATE,
777: LAST_UPDATE_LOGIN
778: FROM Okc_Action_Attributes_V
779: WHERE okc_action_attributes_v.id = p_id;
780: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
781: CURSOR okc_pdfv_pk_csr (p_id IN NUMBER) IS
782: SELECT

Line 779: WHERE okc_action_attributes_v.id = p_id;

775: LAST_UPDATED_BY,
776: LAST_UPDATE_DATE,
777: LAST_UPDATE_LOGIN
778: FROM Okc_Action_Attributes_V
779: WHERE okc_action_attributes_v.id = p_id;
780: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
781: CURSOR okc_pdfv_pk_csr (p_id IN NUMBER) IS
782: SELECT
783: ID,

Line 1061: select 'X' from okc_action_attributes_v aae

1057: l_temp NUMBER ;
1058: l_aaev_rec VARCHAR2(1);
1059: l_aae_cnh_rec VARCHAR2(1);
1060: CURSOR aaev_cur IS
1061: select 'X' from okc_action_attributes_v aae
1062: where aae.id = p_cnlv_rec.aae_id;
1063: CURSOR aae_cnh_cur IS
1064: select 'X' from okc_action_attributes_v aae,okc_condition_headers_v cnh
1065: where aae.id = p_cnlv_rec.aae_id

Line 1064: select 'X' from okc_action_attributes_v aae,okc_condition_headers_v cnh

1060: CURSOR aaev_cur IS
1061: select 'X' from okc_action_attributes_v aae
1062: where aae.id = p_cnlv_rec.aae_id;
1063: CURSOR aae_cnh_cur IS
1064: select 'X' from okc_action_attributes_v aae,okc_condition_headers_v cnh
1065: where aae.id = p_cnlv_rec.aae_id
1066: and cnh.id = p_cnlv_rec.cnh_id
1067: and aae.acn_id = cnh.acn_id;
1068: BEGIN

Line 1873: l_format OKC_ACTION_ATTRIBUTES_V.format_mask%TYPE;

1869: IS
1870:
1871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1872: l_value OKC_CONDITION_LINES_V.right_parenthesis%TYPE;
1873: l_format OKC_ACTION_ATTRIBUTES_V.format_mask%TYPE;
1874: l_csm_rec VARCHAR2(1);
1875: l_cs_rec VARCHAR2(1);
1876: /* CURSOR csm_cur IS
1877: select 'X' from cs_ctr_master csm

Line 1936: select format_mask into l_format from okc_action_attributes_v aae

1932: RAISE G_EXCEPTION_HALT_VALIDATION;
1933: END IF;
1934: ELSIF UPPER(p_cnlv_rec.cnl_type) = 'GEX' THEN
1935: IF p_cnlv_rec.right_operand is not null THEN
1936: select format_mask into l_format from okc_action_attributes_v aae
1937: where aae.id = p_cnlv_rec.aae_id;
1938: IF no_data_found THEN
1939: null;
1940: ELSE