APPS.OKC_TERMS_COPY_GRP dependencies on OKC_BUS_DOC_TYPES_B

Line 84: FROM okc_bus_doc_types_b

80: l_copy_primary_doc_flag VARCHAR2(1) := 'N' ;
81:
82: CURSOR target_response_cur IS
83: SELECT TARGET_RESPONSE_DOC_TYPE
84: FROM okc_bus_doc_types_b
85: WHERE document_type = p_target_doc_type
86: AND document_type_class = 'SOURCING';
87: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
88: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b

Line 87: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;

83: SELECT TARGET_RESPONSE_DOC_TYPE
84: FROM okc_bus_doc_types_b
85: WHERE document_type = p_target_doc_type
86: AND document_type_class = 'SOURCING';
87: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
88: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b
89: -- do not use the p_copy_deliverables param bug#3984339
90: CURSOR DEL_COPY_CUR IS
91: SELECT enable_deliverables_yn

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

84: FROM okc_bus_doc_types_b
85: WHERE document_type = p_target_doc_type
86: AND document_type_class = 'SOURCING';
87: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
88: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b
89: -- do not use the p_copy_deliverables param bug#3984339
90: CURSOR DEL_COPY_CUR IS
91: SELECT enable_deliverables_yn
92: FROM okc_bus_doc_types_b

Line 92: FROM okc_bus_doc_types_b

88: --11.5.10+ derive deliverables_enabled_yn flag from okc_bus_doc_types_b
89: -- do not use the p_copy_deliverables param bug#3984339
90: CURSOR DEL_COPY_CUR IS
91: SELECT enable_deliverables_yn
92: FROM okc_bus_doc_types_b
93: where document_type = p_target_doc_type;
94:
95: l_deliverables_enabled VARCHAR2(1);
96: l_copy_deliverables VARCHAR2(1);

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

462: )IS
463: l_api_version CONSTANT NUMBER := 1;
464: l_api_name CONSTANT VARCHAR2(30) := 'copy_terms_template';
465: l_template_rec OKC_TERMS_TEMPLATES_PVT.template_rec_type;
466: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
467: l_dummy VARCHAR2(1) :='?';
468: l_deliverables_exist VARCHAR2(100);
469:
470: CURSOR l_get_tmpl_csr IS

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

805: l_api_version CONSTANT NUMBER := 1;
806: l_api_name CONSTANT VARCHAR2(30) := 'copy_terms';
807: l_ok_to_commit VARCHAR2(1);
808: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_target_doc_id;
809: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_target_doc_type;
810:
811: CURSOR target_response_cur IS
812: SELECT TARGET_RESPONSE_DOC_TYPE
813: FROM okc_bus_doc_types_b

Line 813: FROM okc_bus_doc_types_b

809: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_target_doc_type;
810:
811: CURSOR target_response_cur IS
812: SELECT TARGET_RESPONSE_DOC_TYPE
813: FROM okc_bus_doc_types_b
814: WHERE document_type = p_target_doc_type
815: AND document_type_class = 'SOURCING';
816:
817: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;

Line 817: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;

813: FROM okc_bus_doc_types_b
814: WHERE document_type = p_target_doc_type
815: AND document_type_class = 'SOURCING';
816:
817: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
818:
819: CURSOR l_get_num_scheme_id(p_doc_type IN VARCHAR2, p_doc_id IN NUMBER) IS
820: SELECT doc_numbering_scheme
821: FROM okc_template_usages

Line 829: FROM okc_bus_doc_types_b

825: l_num_scheme_id NUMBER:=0;
826: -- bug#4113619
827: CURSOR enable_deliverables_cur IS
828: SELECT enable_deliverables_yn
829: FROM okc_bus_doc_types_b
830: WHERE document_type = p_target_doc_type;
831: l_enable_deliverables VARCHAR2(1);
832:
833: BEGIN

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

1089:
1090: l_api_version CONSTANT NUMBER := 1;
1091: l_api_name CONSTANT VARCHAR2(30) := 'create_template_revision';
1092: l_template_rec OKC_TERMS_TEMPLATES_PVT.template_rec_type;
1093: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
1094: l_copy_deliverables VARCHAR2(1);
1095:
1096: CURSOR l_get_tmpl_csr IS
1097: SELECT * FROM OKC_TERMS_TEMPLATES_ALL