DBA Data[Home] [Help]

APPS.PA_CI_SECURITY_PKG dependencies on FND_GLOBAL

Line 18: p_user_id NUMBER DEFAULT fnd_global.user_id,

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

Line 19: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

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

Line 85: p_user_id NUMBER DEFAULT fnd_global.user_id,

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

Line 86: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

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

Line 224: p_user_id NUMBER DEFAULT fnd_global.user_id,

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

Line 225: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

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

Line 271: p_user_id NUMBER DEFAULT fnd_global.user_id,

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

Line 272: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

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

Line 310: p_user_id NUMBER DEFAULT fnd_global.user_id,

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

Line 311: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

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

Line 366: p_user_id NUMBER DEFAULT fnd_global.user_id,

362: FUNCTION check_update_access1(
363: p_ci_id NUMBER,
364: p_project_id NUMBER,
365: p_proj_org_id NUMBER,
366: p_user_id NUMBER DEFAULT fnd_global.user_id,
367: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
368: RETURN VARCHAR2
369: IS
370: l_tmp NUMBER;

Line 367: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

363: p_ci_id NUMBER,
364: p_project_id NUMBER,
365: p_proj_org_id NUMBER,
366: p_user_id NUMBER DEFAULT fnd_global.user_id,
367: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
368: RETURN VARCHAR2
369: IS
370: l_tmp NUMBER;
371: l_project_id NUMBER;

Line 425: p_user_id NUMBER DEFAULT fnd_global.user_id,

421: END;
422:
423: FUNCTION check_change_owner_access(
424: p_ci_id NUMBER,
425: p_user_id NUMBER DEFAULT fnd_global.user_id,
426: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
427: RETURN VARCHAR2
428: IS
429: l_tmp NUMBER;

Line 426: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

422:
423: FUNCTION check_change_owner_access(
424: p_ci_id NUMBER,
425: p_user_id NUMBER DEFAULT fnd_global.user_id,
426: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
427: RETURN VARCHAR2
428: IS
429: l_tmp NUMBER;
430: l_project_id NUMBER;

Line 457: p_user_id NUMBER DEFAULT fnd_global.user_id,

453: END;
454:
455: FUNCTION check_change_status_access(
456: p_ci_id NUMBER,
457: p_user_id NUMBER DEFAULT fnd_global.user_id,
458: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
459: RETURN VARCHAR2
460: IS
461: BEGIN

Line 458: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

454:
455: FUNCTION check_change_status_access(
456: p_ci_id NUMBER,
457: p_user_id NUMBER DEFAULT fnd_global.user_id,
458: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
459: RETURN VARCHAR2
460: IS
461: BEGIN
462: RETURN check_change_owner_access(p_ci_id, p_user_id, p_resp_id);

Line 467: p_user_id NUMBER DEFAULT fnd_global.user_id,

463: END;
464:
465: FUNCTION check_highlight_access(
466: p_ci_id NUMBER,
467: p_user_id NUMBER DEFAULT fnd_global.user_id,
468: p_resp_id NUMBER DEFAULT fnd_global.resp_id,
469: p_project_id NUMBER DEFAULT NULL)
470: RETURN VARCHAR2
471: IS

Line 468: p_resp_id NUMBER DEFAULT fnd_global.resp_id,

464:
465: FUNCTION check_highlight_access(
466: p_ci_id NUMBER,
467: p_user_id NUMBER DEFAULT fnd_global.user_id,
468: p_resp_id NUMBER DEFAULT fnd_global.resp_id,
469: p_project_id NUMBER DEFAULT NULL)
470: RETURN VARCHAR2
471: IS
472: l_tmp NUMBER;

Line 492: p_user_id NUMBER DEFAULT fnd_global.user_id,

488: END;
489:
490: FUNCTION check_implement_impact_access(
491: p_ci_id NUMBER,
492: p_user_id NUMBER DEFAULT fnd_global.user_id,
493: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
494: RETURN VARCHAR2
495: IS
496: BEGIN

Line 493: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

489:
490: FUNCTION check_implement_impact_access(
491: p_ci_id NUMBER,
492: p_user_id NUMBER DEFAULT fnd_global.user_id,
493: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
494: RETURN VARCHAR2
495: IS
496: BEGIN
497: RETURN check_change_owner_access(p_ci_id, p_user_id, p_resp_id);

Line 503: p_user_id IN NUMBER DEFAULT fnd_global.user_id,

499:
500:
501: FUNCTION check_create_action(
502: p_ci_id IN NUMBER,
503: p_user_id IN NUMBER DEFAULT fnd_global.user_id,
504: p_calling_context IN VARCHAR2 DEFAULT 'UI')-- Bug 5676037. Added the parameter to identify the amg context.
505: return VARCHAR2
506: IS
507: l_result varchar2(1);

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

551: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
552: RETURN 'F';
553: END IF;
554:
555: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR
556: is_owner(p_ci_id, p_user_id) = 'T' THEN
557: RETURN 'T';
558: END IF;
559:

Line 574: p_user_id IN NUMBER DEFAULT fnd_global.user_id)

570: END check_create_action;
571:
572: FUNCTION check_item_owner_project_auth(
573: p_ci_id in NUMBER,
574: p_user_id IN NUMBER DEFAULT fnd_global.user_id)
575: RETURN VARCHAR2
576: IS
577: l_project_id number;
578: l_project_org_id number;

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

590: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
591: RETURN 'F';
592: END IF;
593:
594: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR
595: is_owner(p_ci_id, p_user_id) = 'T' THEN
596: RETURN 'T';
597: END IF;
598:

Line 605: p_user_id IN NUMBER DEFAULT fnd_global.user_id)

601:
602:
603: FUNCTION check_open_action_assigned_to(
604: p_ci_action_id IN NUMBER,
605: p_user_id IN NUMBER DEFAULT fnd_global.user_id)
606: return varchar2
607: IS
608: l_result varchar2(1);
609: l_party_id number;

Line 645: p_user_id IN NUMBER DEFAULT fnd_global.user_id)

641: END check_open_action_assigned_to;
642:
643: FUNCTION check_updatable_comment(
644: p_ci_comment_id IN NUMBER,
645: p_user_id IN NUMBER DEFAULT fnd_global.user_id)
646: return varchar2
647: IS
648: l_ci_id number;
649: l_created_by number;

Line 680: p_user_id NUMBER DEFAULT fnd_global.user_id,

676:
677: FUNCTION check_create_CI(
678: p_ci_type_id NUMBER,
679: p_project_id NUMBER,
680: p_user_id NUMBER DEFAULT fnd_global.user_id,
681: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
682: RETURN VARCHAR2
683: IS
684: l_tmp NUMBER;

Line 681: p_resp_id NUMBER DEFAULT fnd_global.resp_id)

677: FUNCTION check_create_CI(
678: p_ci_type_id NUMBER,
679: p_project_id NUMBER,
680: p_user_id NUMBER DEFAULT fnd_global.user_id,
681: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
682: RETURN VARCHAR2
683: IS
684: l_tmp NUMBER;
685: l_allow_all_usage_flag VARCHAR2(1);