DBA Data[Home] [Help]

APPS.OKC_UTIL dependencies on FND_GLOBAL

Line 173: (g_user_id <> fnd_global.user_id) Then

169:
170: Procedure Set_Connection_Context Is
171: Begin
172: If (g_user_id = OKC_API.G_MISS_NUM) Or
173: (g_user_id <> fnd_global.user_id) Then
174: g_user_id := fnd_global.user_id;
175: g_reset_access_flag := True;
176: g_reset_lang_flag := True;
177: End If;

Line 174: g_user_id := fnd_global.user_id;

170: Procedure Set_Connection_Context Is
171: Begin
172: If (g_user_id = OKC_API.G_MISS_NUM) Or
173: (g_user_id <> fnd_global.user_id) Then
174: g_user_id := fnd_global.user_id;
175: g_reset_access_flag := True;
176: g_reset_lang_flag := True;
177: End If;
178:

Line 180: (g_resp_id <> fnd_global.resp_id) Then

176: g_reset_lang_flag := True;
177: End If;
178:
179: If (g_resp_id = OKC_API.G_MISS_NUM) Or
180: (g_resp_id <> fnd_global.resp_id) Then
181: g_resp_id := fnd_global.resp_id;
182: g_reset_resp_flag := True;
183: End If;
184: End;

Line 181: g_resp_id := fnd_global.resp_id;

177: End If;
178:
179: If (g_resp_id = OKC_API.G_MISS_NUM) Or
180: (g_resp_id <> fnd_global.resp_id) Then
181: g_resp_id := fnd_global.resp_id;
182: g_reset_resp_flag := True;
183: End If;
184: End;
185:

Line 1672: AND ras.resp_id = fnd_global.resp_id

1668: CURSOR resp_csr IS
1669: SELECT ras.access_level
1670: FROM okc_subclass_resps ras
1671: WHERE ras.scs_code = l_scs_code
1672: AND ras.resp_id = fnd_global.resp_id
1673: AND l_date BETWEEN ras.start_date AND nvl(ras.end_date, l_date);
1674:
1675: -- This cursor retrieves the resource id corresponding to the logged
1676: -- in user. The resource has to have a role of CONTRACT for this to be

Line 1684: WHERE res.user_id = fnd_global.user_id

1680: SELECT res.resource_id
1681: FROM jtf_rs_resource_extns res,
1682: jtf_rs_role_relations rrr,
1683: jtf_rs_roles_b rr
1684: WHERE res.user_id = fnd_global.user_id
1685: AND l_date between res.start_date_active
1686: and nvl(res.end_date_active, l_date)
1687: AND res.resource_id = rrr.role_resource_id
1688: AND rrr.role_resource_type = 'RS_INDIVIDUAL'

Line 2089: and resp_id=fnd_global.resp_id

2085: Cursor access_level_csr is
2086: Select access_level
2087: from okc_subclass_resps_v
2088: where scs_code=p_scs_code
2089: and resp_id=fnd_global.resp_id
2090: and sysdate between start_date and nvl(end_date,sysdate);
2091:
2092: Cursor subclass_csr is
2093: Select meaning

Line 2152: last_updated_by = FND_GLOBAL.USER_ID,

2148: IF (p_text IS NOT NULL) THEN
2149: UPDATE okc_article_versions
2150: SET article_text = p_text,
2151: object_version_number = object_version_number+1,
2152: last_updated_by = FND_GLOBAL.USER_ID,
2153: last_update_login = FND_GLOBAL.LOGIN_ID,
2154: last_update_date = Sysdate
2155: WHERE article_version_id=(SELECT article_version_id
2156: FROM okc_k_articles_b WHERE id = p_id);

Line 2153: last_update_login = FND_GLOBAL.LOGIN_ID,

2149: UPDATE okc_article_versions
2150: SET article_text = p_text,
2151: object_version_number = object_version_number+1,
2152: last_updated_by = FND_GLOBAL.USER_ID,
2153: last_update_login = FND_GLOBAL.LOGIN_ID,
2154: last_update_date = Sysdate
2155: WHERE article_version_id=(SELECT article_version_id
2156: FROM okc_k_articles_b WHERE id = p_id);
2157: END IF;

Line 2215: last_updated_by = FND_GLOBAL.USER_ID,

2211: = (SELECT article_text FROM okc_article_versions
2212: WHERE article_id=p_sae_id
2213: AND sysdate BETWEEN start_date AND Nvl(end_date,Sysdate+1) ),
2214: object_version_number = object_version_number+1,
2215: last_updated_by = FND_GLOBAL.USER_ID,
2216: last_update_login = FND_GLOBAL.LOGIN_ID,
2217: last_update_date = Sysdate
2218: WHERE article_version_id
2219: =(SELECT article_version_id

Line 2216: last_update_login = FND_GLOBAL.LOGIN_ID,

2212: WHERE article_id=p_sae_id
2213: AND sysdate BETWEEN start_date AND Nvl(end_date,Sysdate+1) ),
2214: object_version_number = object_version_number+1,
2215: last_updated_by = FND_GLOBAL.USER_ID,
2216: last_update_login = FND_GLOBAL.LOGIN_ID,
2217: last_update_date = Sysdate
2218: WHERE article_version_id
2219: =(SELECT article_version_id
2220: FROM okc_k_articles_b WHERE id = p_article_id);

Line 2773: g_request_id:=FND_GLOBAL.conc_request_id;

2769: WHEN OTHERS THEN
2770: NULL;
2771: END;
2772:
2773: g_request_id:=FND_GLOBAL.conc_request_id;
2774: IF g_request_id NOT IN (0, -1) -- The conc. prog. is running
2775: THEN
2776: -- Sets up the log file for the conc.req
2777: set_trace_context(g_request_id, lx_return_status);

Line 2806: l_user_id := fnd_global.user_id; -- obtain the user ID

2802: l_init_profile_log_enabled := FND_PROFILE.VALUE('AFLOG_ENABLED');
2803: l_init_profile_module_level:= FND_PROFILE.VALUE('AFLOG_LEVEL');
2804: l_init_profile_module_name := FND_PROFILE.VALUE('AFLOG_MODULE');
2805:
2806: l_user_id := fnd_global.user_id; -- obtain the user ID
2807:
2808: IF l_user_id = -1 -- Non-Apps Mode.
2809: THEN
2810: IF (l_debug = 'Y') THEN

Line 3383: Fnd_Global.User_Id,

3379: l_org_id,
3380: decode (x_doc_type,'OKE_SELL', 'OKC11510UPG:OKE', 'OKE_BUY', 'OKC11510UPG:OKE', 'OKC11510UPG'),
3381: decode(x_doc_type,'OKS','N','Y'),
3382: 1,
3383: Fnd_Global.User_Id,
3384: trunc(sysdate),
3385: Fnd_Global.User_Id,
3386: Fnd_Global.Login_Id,
3387: trunc(sysdate)

Line 3385: Fnd_Global.User_Id,

3381: decode(x_doc_type,'OKS','N','Y'),
3382: 1,
3383: Fnd_Global.User_Id,
3384: trunc(sysdate),
3385: Fnd_Global.User_Id,
3386: Fnd_Global.Login_Id,
3387: trunc(sysdate)
3388: );
3389: INSERT INTO OKC_ALLOWED_TMPL_USAGES(

Line 3386: Fnd_Global.Login_Id,

3382: 1,
3383: Fnd_Global.User_Id,
3384: trunc(sysdate),
3385: Fnd_Global.User_Id,
3386: Fnd_Global.Login_Id,
3387: trunc(sysdate)
3388: );
3389: INSERT INTO OKC_ALLOWED_TMPL_USAGES(
3390: ALLOWED_TMPL_USAGES_ID,

Line 3406: Fnd_Global.User_Id,

3402: l_tmpl_id,
3403: x_doc_type,
3404: 'N',
3405: 1,
3406: Fnd_Global.User_Id,
3407: trunc(sysdate),
3408: Fnd_Global.User_Id,
3409: Fnd_Global.Login_Id,
3410: trunc(sysdate)

Line 3408: Fnd_Global.User_Id,

3404: 'N',
3405: 1,
3406: Fnd_Global.User_Id,
3407: trunc(sysdate),
3408: Fnd_Global.User_Id,
3409: Fnd_Global.Login_Id,
3410: trunc(sysdate)
3411: );
3412: END IF;

Line 3409: Fnd_Global.Login_Id,

3405: 1,
3406: Fnd_Global.User_Id,
3407: trunc(sysdate),
3408: Fnd_Global.User_Id,
3409: Fnd_Global.Login_Id,
3410: trunc(sysdate)
3411: );
3412: END IF;
3413: IF l_tmpl_id IS NOT NULL THEN