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.

[Home] [Help]

APPS.OKC_K_ENTITY_LOCKS_GRP dependencies on OKC_K_ART_VARIABLES

Line 1003: okc_k_art_variables_pvt.delete_set (x_return_status => x_return_status,

999:
1000: --------------------------------------------------
1001: -- Call the API to take care of MRV values etc..
1002: ------------------------------------------------------
1003: okc_k_art_variables_pvt.delete_set (x_return_status => x_return_status,
1004: p_cat_id => p_doc_clause_id
1005: );
1006:
1007: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1012: '1010: After Call to okc_k_art_variables_pvt.delete_set : '

1008: THEN
1009: fnd_log.STRING
1010: (FND_LOG.LEVEL_STATEMENT,
1011: g_pkg_name,
1012: '1010: After Call to okc_k_art_variables_pvt.delete_set : '
1013: || x_return_status
1014: );
1015: END IF;
1016:

Line 1728: FROM okc_k_art_variables var,

1724: busvar.variable_type, busvar.external_yn,
1725: busvar.value_set_id, var.variable_value,
1726: var.variable_value_id, var.override_global_yn,
1727: var.mr_variable_html, var.mr_variable_xml, busvar.mrv_flag
1728: FROM okc_k_art_variables var,
1729: okc_k_articles_b kart,
1730: okc_k_articles_b kart_tar,
1731: okc_bus_variables_b busvar
1732: WHERE kart.ID = p_source_doc_clause_id

Line 1736: TYPE catlist IS TABLE OF okc_k_art_variables.cat_id%TYPE

1732: WHERE kart.ID = p_source_doc_clause_id
1733: AND var.cat_id = kart.ID
1734: AND busvar.variable_code = var.variable_code;
1735:
1736: TYPE catlist IS TABLE OF okc_k_art_variables.cat_id%TYPE
1737: INDEX BY BINARY_INTEGER;
1738:
1739: TYPE varlist IS TABLE OF okc_k_art_variables.variable_code%TYPE
1740: INDEX BY BINARY_INTEGER;

Line 1739: TYPE varlist IS TABLE OF okc_k_art_variables.variable_code%TYPE

1735:
1736: TYPE catlist IS TABLE OF okc_k_art_variables.cat_id%TYPE
1737: INDEX BY BINARY_INTEGER;
1738:
1739: TYPE varlist IS TABLE OF okc_k_art_variables.variable_code%TYPE
1740: INDEX BY BINARY_INTEGER;
1741:
1742: TYPE vartypelist IS TABLE OF okc_k_art_variables.variable_type%TYPE
1743: INDEX BY BINARY_INTEGER;

Line 1742: TYPE vartypelist IS TABLE OF okc_k_art_variables.variable_type%TYPE

1738:
1739: TYPE varlist IS TABLE OF okc_k_art_variables.variable_code%TYPE
1740: INDEX BY BINARY_INTEGER;
1741:
1742: TYPE vartypelist IS TABLE OF okc_k_art_variables.variable_type%TYPE
1743: INDEX BY BINARY_INTEGER;
1744:
1745: TYPE externallist IS TABLE OF okc_k_art_variables.external_yn%TYPE
1746: INDEX BY BINARY_INTEGER;

Line 1745: TYPE externallist IS TABLE OF okc_k_art_variables.external_yn%TYPE

1741:
1742: TYPE vartypelist IS TABLE OF okc_k_art_variables.variable_type%TYPE
1743: INDEX BY BINARY_INTEGER;
1744:
1745: TYPE externallist IS TABLE OF okc_k_art_variables.external_yn%TYPE
1746: INDEX BY BINARY_INTEGER;
1747:
1748: TYPE valsetlist IS TABLE OF okc_k_art_variables.attribute_value_set_id%TYPE
1749: INDEX BY BINARY_INTEGER;

Line 1748: TYPE valsetlist IS TABLE OF okc_k_art_variables.attribute_value_set_id%TYPE

1744:
1745: TYPE externallist IS TABLE OF okc_k_art_variables.external_yn%TYPE
1746: INDEX BY BINARY_INTEGER;
1747:
1748: TYPE valsetlist IS TABLE OF okc_k_art_variables.attribute_value_set_id%TYPE
1749: INDEX BY BINARY_INTEGER;
1750:
1751: TYPE varvallist IS TABLE OF okc_k_art_variables.variable_value%TYPE
1752: INDEX BY BINARY_INTEGER;

Line 1751: TYPE varvallist IS TABLE OF okc_k_art_variables.variable_value%TYPE

1747:
1748: TYPE valsetlist IS TABLE OF okc_k_art_variables.attribute_value_set_id%TYPE
1749: INDEX BY BINARY_INTEGER;
1750:
1751: TYPE varvallist IS TABLE OF okc_k_art_variables.variable_value%TYPE
1752: INDEX BY BINARY_INTEGER;
1753:
1754: TYPE varidlist IS TABLE OF okc_k_art_variables.variable_value_id%TYPE
1755: INDEX BY BINARY_INTEGER;

Line 1754: TYPE varidlist IS TABLE OF okc_k_art_variables.variable_value_id%TYPE

1750:
1751: TYPE varvallist IS TABLE OF okc_k_art_variables.variable_value%TYPE
1752: INDEX BY BINARY_INTEGER;
1753:
1754: TYPE varidlist IS TABLE OF okc_k_art_variables.variable_value_id%TYPE
1755: INDEX BY BINARY_INTEGER;
1756:
1757: TYPE overrideglobalynlist IS TABLE OF okc_k_art_variables.override_global_yn%TYPE
1758: INDEX BY BINARY_INTEGER;

Line 1757: TYPE overrideglobalynlist IS TABLE OF okc_k_art_variables.override_global_yn%TYPE

1753:
1754: TYPE varidlist IS TABLE OF okc_k_art_variables.variable_value_id%TYPE
1755: INDEX BY BINARY_INTEGER;
1756:
1757: TYPE overrideglobalynlist IS TABLE OF okc_k_art_variables.override_global_yn%TYPE
1758: INDEX BY BINARY_INTEGER;
1759:
1760: TYPE mrvariablehtmllist IS TABLE OF okc_k_art_variables.mr_variable_html%TYPE
1761: INDEX BY BINARY_INTEGER;

Line 1760: TYPE mrvariablehtmllist IS TABLE OF okc_k_art_variables.mr_variable_html%TYPE

1756:
1757: TYPE overrideglobalynlist IS TABLE OF okc_k_art_variables.override_global_yn%TYPE
1758: INDEX BY BINARY_INTEGER;
1759:
1760: TYPE mrvariablehtmllist IS TABLE OF okc_k_art_variables.mr_variable_html%TYPE
1761: INDEX BY BINARY_INTEGER;
1762:
1763: TYPE mrvariablexmllist IS TABLE OF okc_k_art_variables.mr_variable_xml%TYPE
1764: INDEX BY BINARY_INTEGER;

Line 1763: TYPE mrvariablexmllist IS TABLE OF okc_k_art_variables.mr_variable_xml%TYPE

1759:
1760: TYPE mrvariablehtmllist IS TABLE OF okc_k_art_variables.mr_variable_html%TYPE
1761: INDEX BY BINARY_INTEGER;
1762:
1763: TYPE mrvariablexmllist IS TABLE OF okc_k_art_variables.mr_variable_xml%TYPE
1764: INDEX BY BINARY_INTEGER;
1765:
1766: TYPE mrvflaglist IS TABLE OF okc_bus_variables_b.mrv_flag%TYPE
1767: INDEX BY BINARY_INTEGER;

Line 1823: INSERT INTO okc_k_art_variables

1819:
1820: IF cat_tbl.COUNT > 0
1821: THEN
1822: FORALL i IN cat_tbl.FIRST .. cat_tbl.LAST
1823: INSERT INTO okc_k_art_variables
1824: (cat_id, variable_code, variable_type,
1825: external_yn, attribute_value_set_id,
1826: variable_value, variable_value_id,
1827: override_global_yn, mr_variable_html,

Line 1846: '1020: Inserted records into okc_k_art_variables ||'

1842: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1843: THEN
1844: fnd_log.STRING (FND_LOG.LEVEL_STATEMENT,
1845: g_pkg_name,
1846: '1020: Inserted records into okc_k_art_variables ||'
1847: );
1848: END IF;
1849:
1850: FOR i IN mrvflag_tbl.FIRST .. mrvflag_tbl.LAST

Line 3016: FROM okc_k_art_variables v,

3012:
3013: CURSOR cur_lock_exists
3014: IS
3015: SELECT 'Y'
3016: FROM okc_k_art_variables v,
3017: okc_k_articles_b k
3018: WHERE k.id = v.cat_id
3019: AND v.variable_code = p_variable_code
3020: AND k.document_type = p_tgt_document_type

Line 3497: update okc_k_art_variables

3493: where id=l_tgt_id_tbl(i);
3494:
3495:
3496: forall i in l_tgt_id_tbl.first..l_tgt_id_tbl.last
3497: update okc_k_art_variables
3498: set cat_id= l_src_ref_id_tbl(i)
3499: where cat_id=l_tgt_id_tbl(i);
3500:
3501: -- Add code for MRV