DBA Data[Home] [Help]

APPS.PA_CI_SECURITY_PKG dependencies on FND_GLOBAL

Line 20: p_user_id NUMBER DEFAULT fnd_global.user_id,

16:
17: FUNCTION check_view_project(
18: p_project_id NUMBER,
19: p_ci_id NUMBER,
20: p_user_id NUMBER DEFAULT fnd_global.user_id,
21: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
22: RETURN VARCHAR2
23: IS
24: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;

Line 21: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

17: FUNCTION check_view_project(
18: p_project_id NUMBER,
19: p_ci_id NUMBER,
20: p_user_id NUMBER DEFAULT fnd_global.user_id,
21: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
22: RETURN VARCHAR2
23: IS
24: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;
25: BEGIN

Line 87: p_user_id NUMBER DEFAULT fnd_global.user_id,

83: FUNCTION check_view_project (
84: p_project_id NUMBER,
85: p_ci_id NUMBER,
86: p_ci_type_class_code VARCHAR2,
87: p_user_id NUMBER DEFAULT fnd_global.user_id,
88: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
89: RETURN VARCHAR2
90: IS
91: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;

Line 88: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

84: p_project_id NUMBER,
85: p_ci_id NUMBER,
86: p_ci_type_class_code VARCHAR2,
87: p_user_id NUMBER DEFAULT fnd_global.user_id,
88: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
89: RETURN VARCHAR2
90: IS
91: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;
92: BEGIN

Line 226: p_user_id NUMBER DEFAULT fnd_global.user_id,

222: END is_owner;
223:
224: FUNCTION check_view_access(
225: p_ci_id NUMBER,
226: p_user_id NUMBER DEFAULT fnd_global.user_id,
227: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
228: RETURN VARCHAR2
229: IS
230: l_status_code VARCHAR2(100);

Line 227: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

223:
224: FUNCTION check_view_access(
225: p_ci_id NUMBER,
226: p_user_id NUMBER DEFAULT fnd_global.user_id,
227: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
228: RETURN VARCHAR2
229: IS
230: l_status_code VARCHAR2(100);
231: l_project_id NUMBER;

Line 273: p_user_id NUMBER DEFAULT fnd_global.user_id,

269: p_ci_id NUMBER,
270: p_project_id NUMBER,
271: p_sys_stat_code VARCHAR2,
272: p_ci_type_class_code VARCHAR2,
273: p_user_id NUMBER DEFAULT fnd_global.user_id,
274: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
275: RETURN VARCHAR2
276: IS
277: l_status_code VARCHAR2(100);

Line 274: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

270: p_project_id NUMBER,
271: p_sys_stat_code VARCHAR2,
272: p_ci_type_class_code VARCHAR2,
273: p_user_id NUMBER DEFAULT fnd_global.user_id,
274: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
275: RETURN VARCHAR2
276: IS
277: l_status_code VARCHAR2(100);
278: l_project_id NUMBER;

Line 312: p_user_id NUMBER DEFAULT fnd_global.user_id,

308: END;
309:
310: FUNCTION check_update_access(
311: p_ci_id NUMBER,
312: p_user_id NUMBER DEFAULT fnd_global.user_id,
313: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
314: RETURN VARCHAR2
315: IS
316: l_tmp NUMBER;

Line 313: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

309:
310: FUNCTION check_update_access(
311: p_ci_id NUMBER,
312: p_user_id NUMBER DEFAULT fnd_global.user_id,
313: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
314: RETURN VARCHAR2
315: IS
316: l_tmp NUMBER;
317: l_project_id NUMBER;

Line 381: p_user_id NUMBER DEFAULT fnd_global.user_id,

377: FUNCTION check_update_access1(
378: p_ci_id NUMBER,
379: p_project_id NUMBER,
380: p_proj_org_id NUMBER,
381: p_user_id NUMBER DEFAULT fnd_global.user_id,
382: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
383: RETURN VARCHAR2
384: IS
385: l_tmp NUMBER;

Line 382: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

378: p_ci_id NUMBER,
379: p_project_id NUMBER,
380: p_proj_org_id NUMBER,
381: p_user_id NUMBER DEFAULT fnd_global.user_id,
382: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
383: RETURN VARCHAR2
384: IS
385: l_tmp NUMBER;
386: l_project_id NUMBER;

Line 440: p_user_id NUMBER DEFAULT fnd_global.user_id,

436: END;
437:
438: FUNCTION check_change_owner_access(
439: p_ci_id NUMBER,
440: p_user_id NUMBER DEFAULT fnd_global.user_id,
441: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
442: RETURN VARCHAR2
443: IS
444: l_tmp NUMBER;

Line 441: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

437:
438: FUNCTION check_change_owner_access(
439: p_ci_id NUMBER,
440: p_user_id NUMBER DEFAULT fnd_global.user_id,
441: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
442: RETURN VARCHAR2
443: IS
444: l_tmp NUMBER;
445: l_project_id NUMBER;

Line 473: p_user_id NUMBER DEFAULT fnd_global.user_id,

469: END;
470:
471: FUNCTION check_change_status_access(
472: p_ci_id NUMBER,
473: p_user_id NUMBER DEFAULT fnd_global.user_id,
474: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
475: RETURN VARCHAR2
476: IS
477: BEGIN

Line 474: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

470:
471: FUNCTION check_change_status_access(
472: p_ci_id NUMBER,
473: p_user_id NUMBER DEFAULT fnd_global.user_id,
474: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
475: RETURN VARCHAR2
476: IS
477: BEGIN
478: RETURN check_change_owner_access(p_ci_id, p_user_id, p_resp_id);

Line 484: p_user_id NUMBER DEFAULT fnd_global.user_id,

480: END;
481:
482: FUNCTION check_highlight_access(
483: p_ci_id NUMBER,
484: p_user_id NUMBER DEFAULT fnd_global.user_id,
485: p_resp_id NUMBER DEFAULT fnd_global.resp_id,
486: p_project_id NUMBER DEFAULT NULL)
487: RETURN VARCHAR2
488: IS

Line 485: p_resp_id NUMBER DEFAULT fnd_global.resp_id,

481:
482: FUNCTION check_highlight_access(
483: p_ci_id NUMBER,
484: p_user_id NUMBER DEFAULT fnd_global.user_id,
485: p_resp_id NUMBER DEFAULT fnd_global.resp_id,
486: p_project_id NUMBER DEFAULT NULL)
487: RETURN VARCHAR2
488: IS
489: l_tmp NUMBER;

Line 509: p_user_id NUMBER DEFAULT fnd_global.user_id,

505: END;
506:
507: FUNCTION check_implement_impact_access(
508: p_ci_id NUMBER,
509: p_user_id NUMBER DEFAULT fnd_global.user_id,
510: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
511: RETURN VARCHAR2
512: IS
513: BEGIN

Line 510: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

506:
507: FUNCTION check_implement_impact_access(
508: p_ci_id NUMBER,
509: p_user_id NUMBER DEFAULT fnd_global.user_id,
510: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
511: RETURN VARCHAR2
512: IS
513: BEGIN
514: RETURN check_change_owner_access(p_ci_id, p_user_id, p_resp_id);

Line 520: p_user_id IN NUMBER DEFAULT fnd_global.user_id,

516:
517:
518: FUNCTION check_create_action(
519: p_ci_id IN NUMBER,
520: p_user_id IN NUMBER DEFAULT fnd_global.user_id,
521: p_calling_context IN VARCHAR2 DEFAULT 'UI')-- Bug 5676037. Added the parameter to identify the amg context.
522: return VARCHAR2
523: IS
524: l_result varchar2(1);

Line 572: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR

568: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
569: RETURN 'F';
570: END IF;
571:
572: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR
573: is_owner(p_ci_id, p_user_id) = 'T' THEN
574: RETURN 'T';
575: END IF;
576:

Line 591: p_user_id IN NUMBER DEFAULT fnd_global.user_id)

587: END check_create_action;
588:
589: FUNCTION check_item_owner_project_auth(
590: p_ci_id in NUMBER,
591: p_user_id IN NUMBER DEFAULT fnd_global.user_id)
592: RETURN VARCHAR2
593: IS
594: l_project_id number;
595: l_project_org_id number;

Line 611: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR

607: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
608: RETURN 'F';
609: END IF;
610:
611: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR
612: is_owner(p_ci_id, p_user_id) = 'T' THEN
613: RETURN 'T';
614: END IF;
615:

Line 622: p_user_id IN NUMBER DEFAULT fnd_global.user_id)

618:
619:
620: FUNCTION check_open_action_assigned_to(
621: p_ci_action_id IN NUMBER,
622: p_user_id IN NUMBER DEFAULT fnd_global.user_id)
623: return varchar2
624: IS
625: l_result varchar2(1);
626: l_party_id number;

Line 662: p_user_id IN NUMBER DEFAULT fnd_global.user_id)

658: END check_open_action_assigned_to;
659:
660: FUNCTION check_updatable_comment(
661: p_ci_comment_id IN NUMBER,
662: p_user_id IN NUMBER DEFAULT fnd_global.user_id)
663: return varchar2
664: IS
665: l_ci_id number;
666: l_created_by number;

Line 697: p_user_id NUMBER DEFAULT fnd_global.user_id,

693:
694: FUNCTION check_create_CI(
695: p_ci_type_id NUMBER,
696: p_project_id NUMBER,
697: p_user_id NUMBER DEFAULT fnd_global.user_id,
698: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
699: RETURN VARCHAR2
700: IS
701: l_tmp NUMBER;

Line 698: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

694: FUNCTION check_create_CI(
695: p_ci_type_id NUMBER,
696: p_project_id NUMBER,
697: p_user_id NUMBER DEFAULT fnd_global.user_id,
698: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
699: RETURN VARCHAR2
700: IS
701: l_tmp NUMBER;
702: l_allow_all_usage_flag VARCHAR2(1);

Line 885: l_old_resp_id := FND_GLOBAL.RESP_ID;

881: x_msg_data := null;
882: x_return_status := fnd_api.g_ret_sts_success;
883: x_has_access := 'F';
884:
885: l_old_resp_id := FND_GLOBAL.RESP_ID;
886: l_old_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
887: l_user_id := FND_GLOBAL.USER_ID;
888:
889: IF G_debug_flag = 'Y' THEN

Line 886: l_old_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

882: x_return_status := fnd_api.g_ret_sts_success;
883: x_has_access := 'F';
884:
885: l_old_resp_id := FND_GLOBAL.RESP_ID;
886: l_old_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
887: l_user_id := FND_GLOBAL.USER_ID;
888:
889: IF G_debug_flag = 'Y' THEN
890: pa_debug.write_file('check_access_exist: ' || 'LOG',' p_privilege '||p_privilege||' l_user_id '||l_user_id);

Line 887: l_user_id := FND_GLOBAL.USER_ID;

883: x_has_access := 'F';
884:
885: l_old_resp_id := FND_GLOBAL.RESP_ID;
886: l_old_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
887: l_user_id := FND_GLOBAL.USER_ID;
888:
889: IF G_debug_flag = 'Y' THEN
890: pa_debug.write_file('check_access_exist: ' || 'LOG',' p_privilege '||p_privilege||' l_user_id '||l_user_id);
891: END IF;

Line 895: FND_GLOBAL.Apps_Initialize

891: END IF;
892: --Get the responsibility that has access to view budget.
893: FOR user_resp_rec IN user_resp_csr(l_user_id) LOOP
894:
895: FND_GLOBAL.Apps_Initialize
896: ( user_id => l_user_id
897: , resp_id => user_resp_rec.responsibility_id
898: , resp_appl_id => user_resp_rec.application_id
899: );

Line 931: FND_GLOBAL.Apps_Initialize

927: pa_debug.write_file('check_access_exist: ' || 'LOG',' x_has_access '||x_has_access);
928: pa_debug.write_file('check_access_exist: ' || 'LOG',' x_resp_key '||x_resp_key||' x_appl_short_name '||x_appl_short_name);
929: END IF;
930:
931: FND_GLOBAL.Apps_Initialize
932: ( user_id => l_user_id
933: , resp_id => l_old_resp_id
934: , resp_appl_id => l_old_resp_appl_id
935: );