APPS.OKC_TERMS_UTIL_PVT dependencies on MO_GLOBAL

Line 2009: AND reln.org_id = mo_global.get_current_org_id()

2005: AND reln.relationship_type = 'ALTERNATE'
2006: AND reln.target_article_id = ver.article_id
2007: AND NVL(p_eff_date,SYSDATE) BETWEEN ver.start_date AND NVL(ver.end_date, nvl(p_eff_date,SYSDATE))
2008: AND ver.article_status = 'APPROVED'
2009: AND reln.org_id = mo_global.get_current_org_id()
2010: AND ( ver.provision_yn = 'N' OR
2011: ( p_document_type IN (select document_type
2012: from okc_bus_doc_types_b
2013: where provision_allowed_yn = 'Y'

Line 3705: mo_global.get_current_org_id() current_org_id

3701:
3702: -- cursor to get article org id and local org id
3703: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS
3704: SELECT org_id,
3705: mo_global.get_current_org_id() current_org_id
3706: FROM OKC_ARTICLES_ALL
3707: WHERE article_id = b_article_id;
3708:
3709: -- cursor to get latest adopted article version id for global article

Line 4827: MO_GLOBAL.INIT('PO');

4823: AND otta.print_template_id = xdb.template_id;
4824:
4825: BEGIN
4826: IF p_doc_type_class = 'PO' THEN
4827: MO_GLOBAL.INIT('PO');
4828: mo_global.set_policy_context('S',p_org_id);
4829: l_doc_type := substr(p_doc_type,1,instr(p_doc_type,'_')-1);
4830: l_doc_sub_type := substr(p_doc_type,instr(p_doc_type,'_')+1,length(p_doc_type)- instr(p_doc_type,'_'));
4831: open get_po_lay_templ_csr(l_doc_type,l_doc_sub_type);

Line 4828: mo_global.set_policy_context('S',p_org_id);

4824:
4825: BEGIN
4826: IF p_doc_type_class = 'PO' THEN
4827: MO_GLOBAL.INIT('PO');
4828: mo_global.set_policy_context('S',p_org_id);
4829: l_doc_type := substr(p_doc_type,1,instr(p_doc_type,'_')-1);
4830: l_doc_sub_type := substr(p_doc_type,instr(p_doc_type,'_')+1,length(p_doc_type)- instr(p_doc_type,'_'));
4831: open get_po_lay_templ_csr(l_doc_type,l_doc_sub_type);
4832: fetch get_po_lay_templ_csr into l_layout_template_code;

Line 4835: MO_GLOBAL.INIT('PON');

4831: open get_po_lay_templ_csr(l_doc_type,l_doc_sub_type);
4832: fetch get_po_lay_templ_csr into l_layout_template_code;
4833: close get_po_lay_templ_csr;
4834: ELSIF p_doc_type_class = 'SOURCING' THEN
4835: MO_GLOBAL.INIT('PON');
4836: mo_global.set_policy_context('S',p_org_id);
4837: open get_souring_lay_templ_csr;
4838: fetch get_souring_lay_templ_csr into l_layout_template_code;
4839: close get_souring_lay_templ_csr;

Line 4836: mo_global.set_policy_context('S',p_org_id);

4832: fetch get_po_lay_templ_csr into l_layout_template_code;
4833: close get_po_lay_templ_csr;
4834: ELSIF p_doc_type_class = 'SOURCING' THEN
4835: MO_GLOBAL.INIT('PON');
4836: mo_global.set_policy_context('S',p_org_id);
4837: open get_souring_lay_templ_csr;
4838: fetch get_souring_lay_templ_csr into l_layout_template_code;
4839: close get_souring_lay_templ_csr;
4840: ELSIF p_doc_type_class = 'SO' or p_doc_type_class = 'BSA' THEN

Line 4841: MO_GLOBAL.INIT('ONT');

4837: open get_souring_lay_templ_csr;
4838: fetch get_souring_lay_templ_csr into l_layout_template_code;
4839: close get_souring_lay_templ_csr;
4840: ELSIF p_doc_type_class = 'SO' or p_doc_type_class = 'BSA' THEN
4841: MO_GLOBAL.INIT('ONT');
4842: mo_global.set_policy_context('S',204);
4843: IF p_doc_type = 'O' THEN
4844: open get_order_lay_templ_csr;
4845: fetch get_order_lay_templ_csr into l_layout_template_code;

Line 4842: mo_global.set_policy_context('S',204);

4838: fetch get_souring_lay_templ_csr into l_layout_template_code;
4839: close get_souring_lay_templ_csr;
4840: ELSIF p_doc_type_class = 'SO' or p_doc_type_class = 'BSA' THEN
4841: MO_GLOBAL.INIT('ONT');
4842: mo_global.set_policy_context('S',204);
4843: IF p_doc_type = 'O' THEN
4844: open get_order_lay_templ_csr;
4845: fetch get_order_lay_templ_csr into l_layout_template_code;
4846: close get_order_lay_templ_csr;