APPS.OKC_TERMS_UTIL_PVT dependencies on MO_GLOBAL

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

1963: AND reln.relationship_type = 'ALTERNATE'
1964: AND reln.target_article_id = ver.article_id
1965: AND NVL(p_eff_date,SYSDATE) BETWEEN ver.start_date AND NVL(ver.end_date, nvl(p_eff_date,SYSDATE))
1966: AND ver.article_status = 'APPROVED'
1967: AND reln.org_id = mo_global.get_current_org_id()
1968: AND ( ver.provision_yn = 'N' OR
1969: ( p_document_type IN (select document_type
1970: from okc_bus_doc_types_b
1971: where provision_allowed_yn = 'Y'

Line 3662: mo_global.get_current_org_id() current_org_id

3658:
3659: -- cursor to get article org id and local org id
3660: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS
3661: SELECT org_id,
3662: mo_global.get_current_org_id() current_org_id
3663: FROM OKC_ARTICLES_ALL
3664: WHERE article_id = b_article_id;
3665:
3666: -- cursor to get latest adopted article version id for global article

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

4774: AND otta.print_template_id = xdb.template_id;
4775:
4776: BEGIN
4777: IF p_doc_type_class = 'PO' THEN
4778: MO_GLOBAL.INIT('PO');
4779: mo_global.set_policy_context('S',p_org_id);
4780: l_doc_type := substr(p_doc_type,1,instr(p_doc_type,'_')-1);
4781: l_doc_sub_type := substr(p_doc_type,instr(p_doc_type,'_')+1,length(p_doc_type)- instr(p_doc_type,'_'));
4782: open get_po_lay_templ_csr(l_doc_type,l_doc_sub_type);

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

4775:
4776: BEGIN
4777: IF p_doc_type_class = 'PO' THEN
4778: MO_GLOBAL.INIT('PO');
4779: mo_global.set_policy_context('S',p_org_id);
4780: l_doc_type := substr(p_doc_type,1,instr(p_doc_type,'_')-1);
4781: l_doc_sub_type := substr(p_doc_type,instr(p_doc_type,'_')+1,length(p_doc_type)- instr(p_doc_type,'_'));
4782: open get_po_lay_templ_csr(l_doc_type,l_doc_sub_type);
4783: fetch get_po_lay_templ_csr into l_layout_template_code;

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

4782: open get_po_lay_templ_csr(l_doc_type,l_doc_sub_type);
4783: fetch get_po_lay_templ_csr into l_layout_template_code;
4784: close get_po_lay_templ_csr;
4785: ELSIF p_doc_type_class = 'SOURCING' THEN
4786: MO_GLOBAL.INIT('PON');
4787: mo_global.set_policy_context('S',p_org_id);
4788: open get_souring_lay_templ_csr;
4789: fetch get_souring_lay_templ_csr into l_layout_template_code;
4790: close get_souring_lay_templ_csr;

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

4783: fetch get_po_lay_templ_csr into l_layout_template_code;
4784: close get_po_lay_templ_csr;
4785: ELSIF p_doc_type_class = 'SOURCING' THEN
4786: MO_GLOBAL.INIT('PON');
4787: mo_global.set_policy_context('S',p_org_id);
4788: open get_souring_lay_templ_csr;
4789: fetch get_souring_lay_templ_csr into l_layout_template_code;
4790: close get_souring_lay_templ_csr;
4791: ELSIF p_doc_type_class = 'SO' or p_doc_type_class = 'BSA' THEN

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

4788: open get_souring_lay_templ_csr;
4789: fetch get_souring_lay_templ_csr into l_layout_template_code;
4790: close get_souring_lay_templ_csr;
4791: ELSIF p_doc_type_class = 'SO' or p_doc_type_class = 'BSA' THEN
4792: MO_GLOBAL.INIT('ONT');
4793: mo_global.set_policy_context('S',204);
4794: IF p_doc_type = 'O' THEN
4795: open get_order_lay_templ_csr;
4796: fetch get_order_lay_templ_csr into l_layout_template_code;

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

4789: fetch get_souring_lay_templ_csr into l_layout_template_code;
4790: close get_souring_lay_templ_csr;
4791: ELSIF p_doc_type_class = 'SO' or p_doc_type_class = 'BSA' THEN
4792: MO_GLOBAL.INIT('ONT');
4793: mo_global.set_policy_context('S',204);
4794: IF p_doc_type = 'O' THEN
4795: open get_order_lay_templ_csr;
4796: fetch get_order_lay_templ_csr into l_layout_template_code;
4797: close get_order_lay_templ_csr;