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_TERMS_COPY_GRP dependencies on OKC_BUS_DOC_TYPES_B

Line 92: FROM okc_bus_doc_types_b

88: l_copy_primary_doc_flag VARCHAR2(1) := 'N' ;
89:
90: CURSOR target_response_cur IS
91: SELECT TARGET_RESPONSE_DOC_TYPE
92: FROM okc_bus_doc_types_b
93: WHERE document_type = p_target_doc_type
94: AND document_type_class = 'SOURCING';
95: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
96: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b

Line 95: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;

91: SELECT TARGET_RESPONSE_DOC_TYPE
92: FROM okc_bus_doc_types_b
93: WHERE document_type = p_target_doc_type
94: AND document_type_class = 'SOURCING';
95: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
96: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b
97: -- do not use the p_copy_deliverables param bug#3984339
98: CURSOR DEL_COPY_CUR IS
99: SELECT enable_deliverables_yn

Line 96: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b

92: FROM okc_bus_doc_types_b
93: WHERE document_type = p_target_doc_type
94: AND document_type_class = 'SOURCING';
95: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
96: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b
97: -- do not use the p_copy_deliverables param bug#3984339
98: CURSOR DEL_COPY_CUR IS
99: SELECT enable_deliverables_yn
100: FROM okc_bus_doc_types_b

Line 100: FROM okc_bus_doc_types_b

96: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b
97: -- do not use the p_copy_deliverables param bug#3984339
98: CURSOR DEL_COPY_CUR IS
99: SELECT enable_deliverables_yn
100: FROM okc_bus_doc_types_b
101: where document_type = p_target_doc_type;
102:
103: -- CLM changes Begins
104: CURSOR l_get_num_scheme_id(p_doc_type IN VARCHAR2, p_doc_id IN NUMBER) IS

Line 584: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;

580: )IS
581: l_api_version CONSTANT NUMBER := 1;
582: l_api_name CONSTANT VARCHAR2(30) := 'copy_terms_template';
583: l_template_rec OKC_TERMS_TEMPLATES_PVT.template_rec_type;
584: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
585: l_dummy VARCHAR2(1) :='?';
586: l_deliverables_exist VARCHAR2(100);
587:
588: CURSOR l_get_tmpl_csr IS

Line 928: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_target_doc_type;

924: l_api_version CONSTANT NUMBER := 1;
925: l_api_name CONSTANT VARCHAR2(30) := 'copy_terms';
926: l_ok_to_commit VARCHAR2(1);
927: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_target_doc_id;
928: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_target_doc_type;
929: l_template_exists VARCHAR2(1);
930:
931: CURSOR target_response_cur IS
932: SELECT TARGET_RESPONSE_DOC_TYPE

Line 933: FROM okc_bus_doc_types_b

929: l_template_exists VARCHAR2(1);
930:
931: CURSOR target_response_cur IS
932: SELECT TARGET_RESPONSE_DOC_TYPE
933: FROM okc_bus_doc_types_b
934: WHERE document_type = p_target_doc_type
935: AND document_type_class = 'SOURCING';
936:
937: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;

Line 937: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;

933: FROM okc_bus_doc_types_b
934: WHERE document_type = p_target_doc_type
935: AND document_type_class = 'SOURCING';
936:
937: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
938:
939: CURSOR l_get_num_scheme_id(p_doc_type IN VARCHAR2, p_doc_id IN NUMBER) IS
940: SELECT doc_numbering_scheme
941: FROM okc_template_usages

Line 949: FROM okc_bus_doc_types_b

945: l_num_scheme_id NUMBER:=0;
946: -- bug#4113619
947: CURSOR enable_deliverables_cur IS
948: SELECT enable_deliverables_yn
949: FROM okc_bus_doc_types_b
950: WHERE document_type = p_target_doc_type;
951: l_enable_deliverables VARCHAR2(1);
952:
953: BEGIN

Line 1228: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;

1224:
1225: l_api_version CONSTANT NUMBER := 1;
1226: l_api_name CONSTANT VARCHAR2(30) := 'create_template_revision';
1227: l_template_rec OKC_TERMS_TEMPLATES_PVT.template_rec_type;
1228: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
1229: l_copy_deliverables VARCHAR2(1);
1230:
1231: CURSOR l_get_tmpl_csr IS
1232: SELECT * FROM OKC_TERMS_TEMPLATES_ALL