DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_PVT dependencies on FND_GLOBAL

Line 362: x_user_id := fnd_global.user_id;

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

Line 363: x_login_id := fnd_global.login_id;

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

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

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

Line 1777: l_user NUMBER := FND_GLOBAL.user_id;

1773: l_created_by number;
1774: l_login number;
1775: j pls_integer;
1776: i1 pls_integer;
1777: l_user NUMBER := FND_GLOBAL.user_id;
1778: l_user_login NUMBER := FND_GLOBAL.login_id;
1779:
1780: CURSOR Get_Defaulted_Category IS
1781: SELECT category_id

Line 1778: l_user_login NUMBER := FND_GLOBAL.login_id;

1774: l_login number;
1775: j pls_integer;
1776: i1 pls_integer;
1777: l_user NUMBER := FND_GLOBAL.user_id;
1778: l_user_login NUMBER := FND_GLOBAL.login_id;
1779:
1780: CURSOR Get_Defaulted_Category IS
1781: SELECT category_id
1782: FROM CS_KB_SOLN_CATEGORIES_B

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

2802: l_string := Remove_Parenthesis(l_string);
2803: l_string := Remove_Braces(l_string);
2804:
2805: -- replace all the other special reserved characters
2806: l_string := replace(l_string, FND_GLOBAL.LOCAL_CHR(39),
2807: FND_GLOBAL.LOCAL_CHR(39)||FND_GLOBAL.LOCAL_CHR(39)); -- quote ' to ''
2808: l_string := replace(l_string, '\', '\\'); -- back slash (escape char)
2809: l_string := replace(l_string, ',', '\,'); -- accumulate
2810: l_string := replace(l_string, '&', '\&'); -- and

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

2803: l_string := Remove_Braces(l_string);
2804:
2805: -- replace all the other special reserved characters
2806: l_string := replace(l_string, FND_GLOBAL.LOCAL_CHR(39),
2807: FND_GLOBAL.LOCAL_CHR(39)||FND_GLOBAL.LOCAL_CHR(39)); -- quote ' to ''
2808: l_string := replace(l_string, '\', '\\'); -- back slash (escape char)
2809: l_string := replace(l_string, ',', '\,'); -- accumulate
2810: l_string := replace(l_string, '&', '\&'); -- and
2811: l_string := replace(l_string, '=', '\='); -- equivalance

Line 4443: WHERE csmap.responsibility_id = fnd_global.resp_id

4439:
4440: Cursor get_secured_SR_types_csr Is
4441: SELECT incident_type_id
4442: FROM cs_sr_type_mapping csmap
4443: WHERE csmap.responsibility_id = fnd_global.resp_id
4444: AND trunc(sysdate)between trunc(nvl(csmap.start_date, sysdate))
4445: AND trunc(nvl(csmap.end_date,sysdate));
4446:
4447: l_security_state VARCHAR2(200);