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_XPRT_IMPORT_TEMPLATE_PVT dependencies on FND_GLOBAL

Line 128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

124: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;

Line 129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;

Line 146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

142: l_cz_imp_devl_project_rec.PRODUCT_KEY:= G_TEMPLATE_MODEL_OSR||
143: p_org_id||':'||
144: p_intent||':'||
145: p_template_id;
146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
147: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
148: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
149: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
150:

Line 343: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

339: SEEDED_FLAG
340: )
341: VALUES
342: (
343: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
344: NULL, -- LOCALE_ID
345: p_template_name, --LOCALIZED_STR
346: NULL, -- INTL_TEXT_ID
347: SYSDATE, -- CREATION_DATE

Line 352: FND_GLOBAL.USER_ID, -- CREATED_BY

348: SYSDATE, -- LAST_UPDATE_DATE
349: '0', -- DELETED_FLAG
350: NULL, -- EFF_FROM
351: NULL, -- EFF_TO
352: FND_GLOBAL.USER_ID, -- CREATED_BY
353: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
354: NULL, -- SECURITY_MASK
355: NULL, -- EFF_MASK
356: NULL, -- CHECKOUT_USER

Line 353: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

349: '0', -- DELETED_FLAG
350: NULL, -- EFF_FROM
351: NULL, -- EFF_TO
352: FND_GLOBAL.USER_ID, -- CREATED_BY
353: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
354: NULL, -- SECURITY_MASK
355: NULL, -- EFF_MASK
356: NULL, -- CHECKOUT_USER
357: l_language, --LANGUAGE

Line 429: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

425: l_cz_imp_ps_nodes_rec.USER_NUM04:= NULL;
426: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
427: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
428: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
429: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
430: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
431: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
432: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_TEMPLATE_MODEL_TOPNODE_OSR||
433: p_org_id||':'||

Line 430: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

426: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
427: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
428: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
429: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
430: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
431: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
432: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_TEMPLATE_MODEL_TOPNODE_OSR||
433: p_org_id||':'||
434: p_intent||':'||

Line 471: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

467: l_cz_imp_ps_nodes_rec.PRIMARY_UOM_CODE:= NULL;
468: l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_PATH:= NULL; -- Must be NULL
469: l_cz_imp_ps_nodes_rec.BOM_SORT_ORDER:= NULL;
470: l_cz_imp_ps_nodes_rec.IB_TRACKABLE:= NULL;
471: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
472: l_cz_imp_ps_nodes_rec.INITIAL_NUM_VALUE:= NULL;
473: l_cz_imp_ps_nodes_rec.SRC_APPLICATION_ID:= G_APPLICATION_ID;
474: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_2:= NULL;
475: l_cz_imp_ps_nodes_rec.INSTANTIABLE_FLAG:= NULL;

Line 881: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

877: SEEDED_FLAG
878: )
879: VALUES
880: (
881: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
882: NULL, -- LOCALE_ID
883: TmplQstName_tbl(i), --LOCALIZED_STR
884: NULL, -- INTL_TEXT_ID
885: SYSDATE, -- CREATION_DATE

Line 890: FND_GLOBAL.USER_ID, -- CREATED_BY

886: SYSDATE, -- LAST_UPDATE_DATE
887: '0', -- DELETED_FLAG
888: NULL, -- EFF_FROM
889: NULL, -- EFF_TO
890: FND_GLOBAL.USER_ID, -- CREATED_BY
891: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
892: NULL, -- SECURITY_MASK
893: NULL, -- EFF_MASK
894: NULL, -- CHECKOUT_USER

Line 891: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

887: '0', -- DELETED_FLAG
888: NULL, -- EFF_FROM
889: NULL, -- EFF_TO
890: FND_GLOBAL.USER_ID, -- CREATED_BY
891: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
892: NULL, -- SECURITY_MASK
893: NULL, -- EFF_MASK
894: NULL, -- CHECKOUT_USER
895: language_tbl(i), --LANGUAGE

Line 989: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

985: l_cz_imp_ps_nodes_rec.USER_NUM04:= NULL;
986: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
987: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
988: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
989: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
990: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
991: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
992: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_TEMPLATE_MODEL_FEATURE_OSR||
993: p_org_id||':'||

Line 990: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

986: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
987: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
988: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
989: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
990: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
991: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
992: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_TEMPLATE_MODEL_FEATURE_OSR||
993: p_org_id||':'||
994: p_intent||':'||

Line 1035: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

1031: l_cz_imp_ps_nodes_rec.PRIMARY_UOM_CODE:= NULL;
1032: l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_PATH:= NULL; -- Must be NULL
1033: l_cz_imp_ps_nodes_rec.BOM_SORT_ORDER:= NULL;
1034: l_cz_imp_ps_nodes_rec.IB_TRACKABLE:= NULL;
1035: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
1036: l_cz_imp_ps_nodes_rec.INITIAL_NUM_VALUE:= NULL;
1037: l_cz_imp_ps_nodes_rec.SRC_APPLICATION_ID:= G_APPLICATION_ID;
1038: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_2:= NULL;
1039: l_cz_imp_ps_nodes_rec.INSTANTIABLE_FLAG:= NULL;

Line 1649: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

1645: SEEDED_FLAG
1646: )
1647: VALUES
1648: (
1649: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
1650: NULL, -- LOCALE_ID
1651: NameList_tbl(i), --LOCALIZED_STR
1652: NULL, -- INTL_TEXT_ID
1653: SYSDATE, -- CREATION_DATE

Line 1658: FND_GLOBAL.USER_ID, -- CREATED_BY

1654: SYSDATE, -- LAST_UPDATE_DATE
1655: '0', -- DELETED_FLAG
1656: NULL, -- EFF_FROM
1657: NULL, -- EFF_TO
1658: FND_GLOBAL.USER_ID, -- CREATED_BY
1659: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
1660: NULL, -- SECURITY_MASK
1661: NULL, -- EFF_MASK
1662: NULL, -- CHECKOUT_USER

Line 1659: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

1655: '0', -- DELETED_FLAG
1656: NULL, -- EFF_FROM
1657: NULL, -- EFF_TO
1658: FND_GLOBAL.USER_ID, -- CREATED_BY
1659: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
1660: NULL, -- SECURITY_MASK
1661: NULL, -- EFF_MASK
1662: NULL, -- CHECKOUT_USER
1663: l_language, --LANGUAGE

Line 1839: FND_GLOBAL.USER_ID, --CREATED_BY

1835: NULL, --USER_NUM04,
1836: NULL, --CHECKOUT_USER,
1837: SYSDATE, --CREATION_DATE
1838: SYSDATE, --LAST_UPDATE_DATE
1839: FND_GLOBAL.USER_ID, --CREATED_BY
1840: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
1841: NULL, --SECURITY_MASK,
1842: G_TEMPLATE_MODEL_OPTION_OSR||
1843: p_org_id||':'||

Line 1840: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY

1836: NULL, --CHECKOUT_USER,
1837: SYSDATE, --CREATION_DATE
1838: SYSDATE, --LAST_UPDATE_DATE
1839: FND_GLOBAL.USER_ID, --CREATED_BY
1840: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
1841: NULL, --SECURITY_MASK,
1842: G_TEMPLATE_MODEL_OPTION_OSR||
1843: p_org_id||':'||
1844: p_intent||':'||

Line 1887: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,

1883: NULL, --PRIMARY_UOM_CODE,
1884: NULL, --COMPONENT_SEQUENCE_PATH, -- Must be NULL
1885: NULL, --BOM_SORT_ORDER,
1886: NULL, --IB_TRACKABLE,
1887: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
1888: NULL, --INITIAL_NUM_VALUE,
1889: G_APPLICATION_ID, --SRC_APPLICATION_ID
1890: NULL, --FSK_ITEMMASTER_2_2,
1891: NULL, --INSTANTIABLE_FLAG,

Line 2036: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

2032: SEEDED_FLAG
2033: )
2034: VALUES
2035: (
2036: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
2037: NULL, -- LOCALE_ID
2038: l_clause_model_name, --LOCALIZED_STR
2039: NULL, -- INTL_TEXT_ID
2040: SYSDATE, -- CREATION_DATE

Line 2045: FND_GLOBAL.USER_ID, -- CREATED_BY

2041: SYSDATE, -- LAST_UPDATE_DATE
2042: '0', -- DELETED_FLAG
2043: NULL, -- EFF_FROM
2044: NULL, -- EFF_TO
2045: FND_GLOBAL.USER_ID, -- CREATED_BY
2046: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2047: NULL, -- SECURITY_MASK
2048: NULL, -- EFF_MASK
2049: NULL, -- CHECKOUT_USER

Line 2046: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

2042: '0', -- DELETED_FLAG
2043: NULL, -- EFF_FROM
2044: NULL, -- EFF_TO
2045: FND_GLOBAL.USER_ID, -- CREATED_BY
2046: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2047: NULL, -- SECURITY_MASK
2048: NULL, -- EFF_MASK
2049: NULL, -- CHECKOUT_USER
2050: l_language, --LANGUAGE

Line 2122: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

2118: l_cz_imp_ps_nodes_rec.USER_NUM04:= NULL;
2119: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
2120: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
2121: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
2122: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
2123: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
2124: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
2125: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_TMPL_MODEL_CM_REF_NODE_OSR||
2126: p_org_id||':'||

Line 2123: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

2119: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
2120: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
2121: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
2122: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
2123: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
2124: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
2125: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_TMPL_MODEL_CM_REF_NODE_OSR||
2126: p_org_id||':'||
2127: p_intent||':'||

Line 2167: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

2163: l_cz_imp_ps_nodes_rec.PRIMARY_UOM_CODE:= NULL;
2164: l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_PATH:= NULL; -- Must be NULL
2165: l_cz_imp_ps_nodes_rec.BOM_SORT_ORDER:= NULL;
2166: l_cz_imp_ps_nodes_rec.IB_TRACKABLE:= NULL;
2167: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
2168: l_cz_imp_ps_nodes_rec.INITIAL_NUM_VALUE:= NULL;
2169: l_cz_imp_ps_nodes_rec.SRC_APPLICATION_ID:= G_APPLICATION_ID;
2170: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_2:= NULL;
2171: l_cz_imp_ps_nodes_rec.INSTANTIABLE_FLAG:= NULL;

Line 2533: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,

2529:
2530:
2531: -- Update the xprt_request_id for the current template
2532: UPDATE okc_terms_templates_all
2533: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,
2534: last_update_login = FND_GLOBAL.LOGIN_ID,
2535: last_update_date = SYSDATE,
2536: last_updated_by = FND_GLOBAL.USER_ID
2537: WHERE template_id = p_template_id;

Line 2534: last_update_login = FND_GLOBAL.LOGIN_ID,

2530:
2531: -- Update the xprt_request_id for the current template
2532: UPDATE okc_terms_templates_all
2533: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,
2534: last_update_login = FND_GLOBAL.LOGIN_ID,
2535: last_update_date = SYSDATE,
2536: last_updated_by = FND_GLOBAL.USER_ID
2537: WHERE template_id = p_template_id;
2538:

Line 2536: last_updated_by = FND_GLOBAL.USER_ID

2532: UPDATE okc_terms_templates_all
2533: SET xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID,
2534: last_update_login = FND_GLOBAL.LOGIN_ID,
2535: last_update_date = SYSDATE,
2536: last_updated_by = FND_GLOBAL.USER_ID
2537: WHERE template_id = p_template_id;
2538:
2539: -- debug log
2540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2921: AND h.request_id = FND_GLOBAL.CONC_REQUEST_ID

2917: okc_xprt_rule_hdrs_all h
2918: WHERE r.template_id = t.template_id
2919: AND r.rule_id = h.rule_id
2920: AND t.status_code IN ('APPROVED','ON_HOLD')
2921: AND h.request_id = FND_GLOBAL.CONC_REQUEST_ID
2922: UNION
2923: -- templates already pushed to CZ
2924: SELECT DISTINCT SUBSTR(orig_sys_ref, INSTR(orig_sys_ref,':',-1,3)+1,
2925: (INSTR(orig_sys_ref,':',1,5) - (INSTR(orig_sys_ref,':',1,4)+1))

Line 2932: AND h.request_id = FND_GLOBAL.CONC_REQUEST_ID

2928: )
2929: FROM cz_rules cz,
2930: okc_xprt_rule_hdrs_all h
2931: WHERE SUBSTR(cz.orig_sys_ref,INSTR(cz.orig_sys_ref,':',-1,1)+1) = to_char(h.rule_id)
2932: AND h.request_id = FND_GLOBAL.CONC_REQUEST_ID
2933: AND cz.deleted_flag = '0'
2934: AND cz.rule_type = 200; --Perf Bug#5030272 Added rule_type = 200
2935:
2936: CURSOR csr_org_rules_templates(p_org_id IN NUMBER) IS

Line 2944: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

2940: WHERE t.org_id = p_org_id
2941: AND t.intent IN (
2942: SELECT DISTINCT intent
2943: FROM okc_xprt_rule_hdrs_all
2944: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
2945: )
2946: AND t.contract_expert_enabled = 'Y'
2947: AND t.status_code IN ('APPROVED','ON_HOLD');
2948:

Line 2953: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID

2949: -- Cursor to check if any rule is Org Wide
2950: CURSOR csr_org_rule_exists IS
2951: SELECT 'X'
2952: FROM okc_xprt_rule_hdrs_all
2953: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID
2954: AND NVL(org_wide_flag,'N') = 'Y';
2955:
2956: -- Get the Rule Org Id
2957: CURSOR csr_rule_org_id IS

Line 2960: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;

2956: -- Get the Rule Org Id
2957: CURSOR csr_rule_org_id IS
2958: SELECT org_id
2959: FROM okc_xprt_rule_hdrs_all
2960: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID;
2961:
2962: l_api_name CONSTANT VARCHAR2(30) := 'rebuild_tmpl_pub_disable';
2963: l_template_id okc_terms_templates_all.template_id%TYPE;
2964: l_org_rules_yn okc_xprt_rule_hdrs_all.org_wide_flag%TYPE := NULL;