DBA Data[Home] [Help]

APPS.OKC_REPORT_PVT dependencies on OKC_TREE_INDEX

Line 29: -- okc_tree_index (.set_root_id)

25:
26: --
27: -- Dependencies:
28: --
29: -- okc_tree_index (.set_root_id)
30: -- wf_mail (.urlencode)
31: --
32: -- okcFormsXmlPrint.jsp (former okcxmlkf.jsp) - print xml contract
33: --

Line 811: -- besides it sets okc_tree_index.set_root_id(p_kid):

807: -- PURPOSE
808: -- call only from JSP apllication (not from forms apps)
809: --
810: -- dinamicly executes
811: -- besides it sets okc_tree_index.set_root_id(p_kid):
812: -- SQL statements use okc_tree_index.get_root_id as Contact Id
813: --
814: procedure set_env(p_kid varchar2) is
815: cursor c1 is

Line 812: -- SQL statements use okc_tree_index.get_root_id as Contact Id

808: -- call only from JSP apllication (not from forms apps)
809: --
810: -- dinamicly executes
811: -- besides it sets okc_tree_index.set_root_id(p_kid):
812: -- SQL statements use okc_tree_index.get_root_id as Contact Id
813: --
814: procedure set_env(p_kid varchar2) is
815: cursor c1 is
816: select '!' from okc_k_headers_b

Line 829: okc_tree_index.set_root_id(p_kid);

825: and P.sql_id = X.sql_id
826: and P.code not in ('xid', 'kid', 'vid', 'content_type');
827: l_value varchar2(200);
828: begin
829: okc_tree_index.set_root_id(p_kid);
830: G_xid := fnd_profile.value('OKC_WEB_REPORT');
831: G_kid := p_kid;
832: G_vid := OKC_PARAMETERS_PUB.Get('vid');
833: get_k_version(G_kid, G_vid, G_mid);

Line 891: -- besides it sets okc_tree_index.set_root_id(p_kid):

887: --
888: -- call only from JSP apllication (not from forms apps)
889: --
890: -- dinamicly executes
891: -- besides it sets okc_tree_index.set_root_id(p_kid):
892: -- SQL statements use okc_tree_index.get_root_id as Contact Id
893: --
894: procedure set_env(
895: p_kid varchar2

Line 892: -- SQL statements use okc_tree_index.get_root_id as Contact Id

888: -- call only from JSP apllication (not from forms apps)
889: --
890: -- dinamicly executes
891: -- besides it sets okc_tree_index.set_root_id(p_kid):
892: -- SQL statements use okc_tree_index.get_root_id as Contact Id
893: --
894: procedure set_env(
895: p_kid varchar2
896: ,p_xid varchar2

Line 915: -- besides it sets okc_tree_index.set_root_id(p_kid):

911: --
912: -- PURPOSE - previous overload with request parameter's set
913: --
914: -- dinamicly executes
915: -- besides it sets okc_tree_index.set_root_id(p_kid):
916: --
917: procedure set_env(p_array in JTF_VARCHAR2_TABLE_2000) is
918: cursor c1(p_kn varchar2) is
919: select to_char(id) from okc_k_headers_b

Line 991: -- 4. besides it sets okc_tree_index.set_root_id(p_kid)

987: --
988: -- 1. apps_initialize
989: -- 2. dbms_session.set_nls
990: -- 3. exec
991: -- 4. besides it sets okc_tree_index.set_root_id(p_kid)
992: -- SQL statements use okc_tree_index.get_root_id as Contact Id
993: --
994:
995: procedure set_env( -- parameters names as in request

Line 992: -- SQL statements use okc_tree_index.get_root_id as Contact Id

988: -- 1. apps_initialize
989: -- 2. dbms_session.set_nls
990: -- 3. exec
991: -- 4. besides it sets okc_tree_index.set_root_id(p_kid)
992: -- SQL statements use okc_tree_index.get_root_id as Contact Id
993: --
994:
995: procedure set_env( -- parameters names as in request
996: p_uid varchar2, -- User Id