APPS.PSB_SUBMIT_REVISION_PVT dependencies on WF_ROLES

Line 21: (approver_name wf_roles.name%TYPE,

17: g_itemkey VARCHAR2(2000) ;
18:
19: -- For Bug 4475288: Changed approver_name, approver_display_name lenghts.
20: TYPE g_approver_rec_type IS RECORD
21: (approver_name wf_roles.name%TYPE,
22: approver_display_name wf_roles.display_name%TYPE,
23: item_key VARCHAR2(240),
24: sequence number);
25:

Line 22: approver_display_name wf_roles.display_name%TYPE,

18:
19: -- For Bug 4475288: Changed approver_name, approver_display_name lenghts.
20: TYPE g_approver_rec_type IS RECORD
21: (approver_name wf_roles.name%TYPE,
22: approver_display_name wf_roles.display_name%TYPE,
23: item_key VARCHAR2(240),
24: sequence number);
25:
26: TYPE g_approver_tbl_type IS TABLE OF g_approver_rec_type

Line 1123: l_approver_display_name wf_roles.display_name%TYPE;

1119: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
1120: l_notification_group_id NUMBER ;
1121: -- Added the following variable for bug 3394080
1122: -- For Bug 4475288: Changed l_approver_display_name length.
1123: l_approver_display_name wf_roles.display_name%TYPE;
1124: --
1125: BEGIN
1126: --
1127: IF ( funcmode = 'RUN' ) THEN

Line 1140: wf_roles wr

1136: SELECT br.approval_override_by, wr.name,wr.display_name
1137: INTO
1138: l_override_approver , l_approver_name,l_approver_display_name
1139: FROM psb_budget_revisions br,
1140: wf_roles wr
1141: WHERE br.budget_revision_id = l_budget_revision_id
1142: AND br.approval_orig_system = orig_system(+)
1143: AND br.approval_override_by = orig_system_id(+) ;
1144:

Line 1966: l_approver_display_name wf_roles.display_name%TYPE;

1962: -- For Bug 4475288: Changed l_approver_name length.
1963: l_approver_name VARCHAR2(320);
1964: -- Added the following variable for bug 3394080
1965: -- For Bug 4475288: Changed l_approver_display_name length.
1966: l_approver_display_name wf_roles.display_name%TYPE;
1967: l_init_index NUMBER ;
1968:
1969: BEGIN
1970:

Line 2022: wf_roles wfr,

2018: resp.wf_role_name ,
2019: wfr.name name ,
2020: wfr.display_name display_name
2021: FROM psb_budget_group_resp resp,
2022: wf_roles wfr,
2023: ( SELECT level bglevel,
2024: budget_group_id
2025: FROM psb_budget_groups
2026: START WITH budget_group_id = l_parent_budget_group_id CONNECT BY PRIOR parent_budget_group_id = budget_group_id