DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_PVT dependencies on FND_GLOBAL

Line 364: x_user_id := fnd_global.user_id;

360: x_login_id OUT NOCOPY number
361: ) is
362: begin
363: x_sysdate := sysdate;
364: x_user_id := fnd_global.user_id;
365: x_login_id := fnd_global.login_id;
366: end Get_Who;
367:
368: --

Line 365: x_login_id := fnd_global.login_id;

361: ) is
362: begin
363: x_sysdate := sysdate;
364: x_user_id := fnd_global.user_id;
365: x_login_id := fnd_global.login_id;
366: end Get_Who;
367:
368: --
369: -- return ":a1,:a2,:a3"

Line 533: --||FND_GLOBAL.local_chr(39)||p_sel_id_tbl(i1) || FND_GLOBAL.local_chr(39);

529: l_jtfobj_rec.select_name || ' from ' ||
530: l_jtfobj_rec.from_table || ' where '||
531: l_jtfobj_rec.select_id || '=:1';
532:
533: --||FND_GLOBAL.local_chr(39)||p_sel_id_tbl(i1) || FND_GLOBAL.local_chr(39);
534:
535: if(l_jtfobj_rec.where_clause is not null) then
536: l_query := l_query || ' and '||l_jtfobj_rec.where_clause;
537: end if;

Line 1781: l_user NUMBER := FND_GLOBAL.user_id;

1777: l_created_by number;
1778: l_login number;
1779: j pls_integer;
1780: i1 pls_integer;
1781: l_user NUMBER := FND_GLOBAL.user_id;
1782: l_user_login NUMBER := FND_GLOBAL.login_id;
1783:
1784: CURSOR Get_Defaulted_Category IS
1785: SELECT category_id

Line 1782: l_user_login NUMBER := FND_GLOBAL.login_id;

1778: l_login number;
1779: j pls_integer;
1780: i1 pls_integer;
1781: l_user NUMBER := FND_GLOBAL.user_id;
1782: l_user_login NUMBER := FND_GLOBAL.login_id;
1783:
1784: CURSOR Get_Defaulted_Category IS
1785: SELECT category_id
1786: FROM CS_KB_SOLN_CATEGORIES_B

Line 2821: l_string := replace(l_string, FND_GLOBAL.LOCAL_CHR(39),

2817: l_string := Remove_Parenthesis(l_string);
2818: l_string := Remove_Braces(l_string);
2819:
2820: -- replace all the other special reserved characters
2821: l_string := replace(l_string, FND_GLOBAL.LOCAL_CHR(39),
2822: FND_GLOBAL.LOCAL_CHR(39)||FND_GLOBAL.LOCAL_CHR(39)); -- quote ' to ''
2823: l_string := replace(l_string, '\', '\\'); -- back slash (escape char)
2824: l_string := replace(l_string, ',', '\,'); -- accumulate
2825: l_string := replace(l_string, '&', '\&'); -- and

Line 2822: FND_GLOBAL.LOCAL_CHR(39)||FND_GLOBAL.LOCAL_CHR(39)); -- quote ' to ''

2818: l_string := Remove_Braces(l_string);
2819:
2820: -- replace all the other special reserved characters
2821: l_string := replace(l_string, FND_GLOBAL.LOCAL_CHR(39),
2822: FND_GLOBAL.LOCAL_CHR(39)||FND_GLOBAL.LOCAL_CHR(39)); -- quote ' to ''
2823: l_string := replace(l_string, '\', '\\'); -- back slash (escape char)
2824: l_string := replace(l_string, ',', '\,'); -- accumulate
2825: l_string := replace(l_string, '&', '\&'); -- and
2826: l_string := replace(l_string, '=', '\='); -- equivalance

Line 4468: WHERE csmap.responsibility_id = fnd_global.resp_id

4464:
4465: Cursor get_secured_SR_types_csr Is
4466: SELECT incident_type_id
4467: FROM cs_sr_type_mapping csmap
4468: WHERE csmap.responsibility_id = fnd_global.resp_id
4469: AND trunc(sysdate)between trunc(nvl(csmap.start_date, sysdate))
4470: AND trunc(nvl(csmap.end_date,sysdate));
4471:
4472: l_security_state VARCHAR2(200);