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.

APPS.OKC_REPORT_PVT dependencies on OKC_PARAMETERS_PUB

Line 832: G_vid := OKC_PARAMETERS_PUB.Get('vid');

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);
834: if (G_vid = -1) then
835: G_ignore_cache := 'Y';
836: else

Line 926: OKC_PARAMETERS_PUB.Set_Params(p_array);

922: k_ind number;
923: k_ind1 number;
924: k_num varchar2(300);
925: begin
926: OKC_PARAMETERS_PUB.Set_Params(p_array);
927: k_ind := OKC_PARAMETERS_PUB.Get_Index('kid');
928: if (k_ind is not null) then
929: if (OKC_PARAMETERS_PUB.Get_Value(k_ind) is null) then
930: k_ind1 := OKC_PARAMETERS_PUB.Get_Index('_kid');

Line 927: k_ind := OKC_PARAMETERS_PUB.Get_Index('kid');

923: k_ind1 number;
924: k_num varchar2(300);
925: begin
926: OKC_PARAMETERS_PUB.Set_Params(p_array);
927: k_ind := OKC_PARAMETERS_PUB.Get_Index('kid');
928: if (k_ind is not null) then
929: if (OKC_PARAMETERS_PUB.Get_Value(k_ind) is null) then
930: k_ind1 := OKC_PARAMETERS_PUB.Get_Index('_kid');
931: if (k_ind1 is not null) then

Line 929: if (OKC_PARAMETERS_PUB.Get_Value(k_ind) is null) then

925: begin
926: OKC_PARAMETERS_PUB.Set_Params(p_array);
927: k_ind := OKC_PARAMETERS_PUB.Get_Index('kid');
928: if (k_ind is not null) then
929: if (OKC_PARAMETERS_PUB.Get_Value(k_ind) is null) then
930: k_ind1 := OKC_PARAMETERS_PUB.Get_Index('_kid');
931: if (k_ind1 is not null) then
932: k_num := OKC_PARAMETERS_PUB.Get_Value(k_ind1);
933: if (k_num is not null) then

Line 930: k_ind1 := OKC_PARAMETERS_PUB.Get_Index('_kid');

926: OKC_PARAMETERS_PUB.Set_Params(p_array);
927: k_ind := OKC_PARAMETERS_PUB.Get_Index('kid');
928: if (k_ind is not null) then
929: if (OKC_PARAMETERS_PUB.Get_Value(k_ind) is null) then
930: k_ind1 := OKC_PARAMETERS_PUB.Get_Index('_kid');
931: if (k_ind1 is not null) then
932: k_num := OKC_PARAMETERS_PUB.Get_Value(k_ind1);
933: if (k_num is not null) then
934: open c1(k_num);

Line 932: k_num := OKC_PARAMETERS_PUB.Get_Value(k_ind1);

928: if (k_ind is not null) then
929: if (OKC_PARAMETERS_PUB.Get_Value(k_ind) is null) then
930: k_ind1 := OKC_PARAMETERS_PUB.Get_Index('_kid');
931: if (k_ind1 is not null) then
932: k_num := OKC_PARAMETERS_PUB.Get_Value(k_ind1);
933: if (k_num is not null) then
934: open c1(k_num);
935: fetch c1 into kid;
936: close c1;

Line 938: OKC_PARAMETERS_PUB.Reset_Param(k_ind,kid);

934: open c1(k_num);
935: fetch c1 into kid;
936: close c1;
937: if (kid is not null) then
938: OKC_PARAMETERS_PUB.Reset_Param(k_ind,kid);
939: end if;
940: end if;
941: end if;
942: else

Line 943: kid := OKC_PARAMETERS_PUB.Get_Value(k_ind);

939: end if;
940: end if;
941: end if;
942: else
943: kid := OKC_PARAMETERS_PUB.Get_Value(k_ind);
944: end if;
945: end if;
946: -- Changes for bugfix 3404142 start
947: -- set_env(kid, OKC_PARAMETERS_PUB.Get('xid'));

Line 947: -- set_env(kid, OKC_PARAMETERS_PUB.Get('xid'));

943: kid := OKC_PARAMETERS_PUB.Get_Value(k_ind);
944: end if;
945: end if;
946: -- Changes for bugfix 3404142 start
947: -- set_env(kid, OKC_PARAMETERS_PUB.Get('xid'));
948: set_env(kid, fnd_profile.value('OKC_WEB_REPORT'));
949: -- Changes for bugfix 3404142 end
950: exception
951: when others then NULL;

Line 954: function url_other_params(p_array in OKC_PARAMETERS_PUB.name_value_tbl_type) return varchar2 is

950: exception
951: when others then NULL;
952: end set_env;
953:
954: function url_other_params(p_array in OKC_PARAMETERS_PUB.name_value_tbl_type) return varchar2 is
955: l_url varchar2(4000);
956: l_name varchar2(200);
957: l_value varchar2(4000);
958: i number;

Line 1848: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(p_code),NULL);

1844: ,p_token1_value => p_prompt
1845: ,p_token2 => 'VALUE'
1846: ,p_token2_value => p_value
1847: );
1848: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(p_code),NULL);
1849: end;
1850:
1851: procedure set_sql_id is
1852: cursor c_sql_id is

Line 1891: OKC_PARAMETERS_PUB.get(code) value

1887: prompt,
1888: type,
1889: required_yn,
1890: lov_query,
1891: OKC_PARAMETERS_PUB.get(code) value
1892: from OKC_REPORT_PRM_V
1893: where sql_id = p
1894: order by sequence_num;
1895: r c1%ROWTYPE;

Line 1916: ni := OKC_PARAMETERS_PUB.get_index('_'||r.code);

1912: end if;
1913: for r in c1(G_sql_id) LOOP
1914: if ( (p_required_yn = 'Y') and (r.required_yn = 'Y') ) then
1915: nv := r.value;
1916: ni := OKC_PARAMETERS_PUB.get_index('_'||r.code);
1917: if (ni is not NULL) then
1918: nv := OKC_PARAMETERS_PUB.get_value(ni);
1919: end if;
1920: if (nv is NULL) then

Line 1918: nv := OKC_PARAMETERS_PUB.get_value(ni);

1914: if ( (p_required_yn = 'Y') and (r.required_yn = 'Y') ) then
1915: nv := r.value;
1916: ni := OKC_PARAMETERS_PUB.get_index('_'||r.code);
1917: if (ni is not NULL) then
1918: nv := OKC_PARAMETERS_PUB.get_value(ni);
1919: end if;
1920: if (nv is NULL) then
1921: OKC_API.SET_MESSAGE(p_app_name => 'OKC'
1922: ,p_msg_name => 'OKC_REQUIRED_FIELD'

Line 1953: ni := OKC_PARAMETERS_PUB.get_index('_'||r.code);

1949: end;
1950: end if;
1951:
1952: if (r.type = 'LOV') then
1953: ni := OKC_PARAMETERS_PUB.get_index('_'||r.code);
1954: if (ni is NULL) then
1955: if (r.value is NULL) then
1956: GOTO continue;
1957: else

Line 1975: nv := OKC_PARAMETERS_PUB.get_value(ni);

1971: end;
1972: end if;
1973: else
1974: begin
1975: nv := OKC_PARAMETERS_PUB.get_value(ni);
1976:
1977: if (nv is NULL) then
1978: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(r.code),NULL);
1979: GOTO continue;

Line 1978: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(r.code),NULL);

1974: begin
1975: nv := OKC_PARAMETERS_PUB.get_value(ni);
1976:
1977: if (nv is NULL) then
1978: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(r.code),NULL);
1979: GOTO continue;
1980: end if;
1981:
1982: n := NULL;

Line 1999: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(r.code),m);

1995: using nv;
1996: fetch c2 into m;
1997: close c2;
1998: if (m is not NULL) then
1999: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(r.code),m);
2000: GOTO continue;
2001: end if;
2002: open c2 for
2003: 'select id from ('||r.lov_query||') where name like :2'

Line 2008: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(r.code),m);

2004: using nv;
2005: fetch c2 into m;
2006: close c2;
2007: if (m is not NULL) then
2008: OKC_PARAMETERS_PUB.Reset_Param(OKC_PARAMETERS_PUB.Get_Index(r.code),m);
2009: GOTO continue;
2010: end if;
2011: set_message('OKC_XML_PARAM_LOV', r.code, r.prompt, nv);
2012: GOTO continue;

Line 2059: and PRM.code = OKC_PARAMETERS_PUB.get('__param_code');

2055: select replace(prompt,'<',fnd_global.local_chr(38)||'lt;'), lov_query
2056: from okc_report_prm_v PRM, okc_report_xst_v XST
2057: where PRM.sql_id = XST.sql_id
2058: and XST.id = fnd_profile.value('OKC_WEB_REPORT')
2059: and PRM.code = OKC_PARAMETERS_PUB.get('__param_code');
2060: cursor c2 is
2061: select replace(MEANING,'<',fnd_global.local_chr(38)||'lt;') from fnd_lookups
2062: where LOOKUP_TYPE='OKS_ITEM_DISPLAY_PREFERENCE'
2063: and lookup_code='DISPLAY_NAME';

Line 2147: P_RECIPIENT varchar2(100) := OKC_PARAMETERS_PUB.get('P_RECIPIENT');

2143: p_chr_id in NUMBER,
2144: p_major_version NUMBER ,
2145: p_scn_id in NUMBER ) is
2146:
2147: P_RECIPIENT varchar2(100) := OKC_PARAMETERS_PUB.get('P_RECIPIENT');
2148: P_SUBJECT varchar2(2000) := OKC_PARAMETERS_PUB.get('P_SUBJECT');
2149: P_BODY varchar2(2000) := OKC_PARAMETERS_PUB.get('P_BODY');
2150: P_XID varchar2(40) := fnd_profile.value('OKC_WEB_REPORT');
2151:

Line 2148: P_SUBJECT varchar2(2000) := OKC_PARAMETERS_PUB.get('P_SUBJECT');

2144: p_major_version NUMBER ,
2145: p_scn_id in NUMBER ) is
2146:
2147: P_RECIPIENT varchar2(100) := OKC_PARAMETERS_PUB.get('P_RECIPIENT');
2148: P_SUBJECT varchar2(2000) := OKC_PARAMETERS_PUB.get('P_SUBJECT');
2149: P_BODY varchar2(2000) := OKC_PARAMETERS_PUB.get('P_BODY');
2150: P_XID varchar2(40) := fnd_profile.value('OKC_WEB_REPORT');
2151:
2152: l_dummy varchar2(1) := '?';

Line 2149: P_BODY varchar2(2000) := OKC_PARAMETERS_PUB.get('P_BODY');

2145: p_scn_id in NUMBER ) is
2146:
2147: P_RECIPIENT varchar2(100) := OKC_PARAMETERS_PUB.get('P_RECIPIENT');
2148: P_SUBJECT varchar2(2000) := OKC_PARAMETERS_PUB.get('P_SUBJECT');
2149: P_BODY varchar2(2000) := OKC_PARAMETERS_PUB.get('P_BODY');
2150: P_XID varchar2(40) := fnd_profile.value('OKC_WEB_REPORT');
2151:
2152: l_dummy varchar2(1) := '?';
2153: