eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_DC_WF dependencies on ZPB_WF

Line 174: zpb_wf_ntf.SHADOWS_FOR_EPBPERFORMER (itemtype => ItemType,

170:
171: IF (l_wait_for_review = 'Y') THEN
172: -- 5301285 06-JUN-27 =============================================
173: -- Will find and set shadow users if EPBPERFORMER is a single user
174: zpb_wf_ntf.SHADOWS_FOR_EPBPERFORMER (itemtype => ItemType,
175: Itemkey => ItemKey,
176: actid => 0,
177: funcmode => 'EPBPERFORMER',
178: resultout => resultout);

Line 1747: zpb_wf_ntf.SetRole(l_frzn_rolename, l_exp_days);

1743: -- Create the roles for fromzen and all users
1744: l_charDate := to_char(sysdate, 'J-SSSSS');
1745: l_frzn_rolename := 'ZPB_DC_SUBMIT_FRZN'|| to_char(l_template_id) || '-' || l_charDate;
1746: l_all_rolename := 'ZPB_DC_SUBMIT_ALLU'|| to_char(l_template_id) || '-' || l_charDate;
1747: zpb_wf_ntf.SetRole(l_frzn_rolename, l_exp_days);
1748: zpb_wf_ntf.SetRole(l_all_rolename, l_exp_days);
1749: l_frzn_role_has_users := 'N';
1750: FOR frzn_rec IN (
1751: SELECT u.user_name as user_name

Line 1748: zpb_wf_ntf.SetRole(l_all_rolename, l_exp_days);

1744: l_charDate := to_char(sysdate, 'J-SSSSS');
1745: l_frzn_rolename := 'ZPB_DC_SUBMIT_FRZN'|| to_char(l_template_id) || '-' || l_charDate;
1746: l_all_rolename := 'ZPB_DC_SUBMIT_ALLU'|| to_char(l_template_id) || '-' || l_charDate;
1747: zpb_wf_ntf.SetRole(l_frzn_rolename, l_exp_days);
1748: zpb_wf_ntf.SetRole(l_all_rolename, l_exp_days);
1749: l_frzn_role_has_users := 'N';
1750: FOR frzn_rec IN (
1751: SELECT u.user_name as user_name
1752: FROM zpb_dc_objects obj, fnd_user u

Line 1759: l_frzn_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_frzn_rolename, frzn_rec.user_name);

1755: AND obj.status NOT IN ('SUBMITTED','FROZEN','APPROVED','SUBMITTED_TO_SHARED')
1756: AND obj.object_user_id = u.user_id
1757: AND (u.end_date is null OR u.end_date > sysdate))
1758: LOOP
1759: l_frzn_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_frzn_rolename, frzn_rec.user_name);
1760: l_frzn_role_has_users := 'Y';
1761: END LOOP;
1762:
1763: FOR all_rec IN (

Line 1770: l_all_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_all_rolename, all_rec.user_name);

1766: WHERE obj.template_id = l_template_id
1767: AND obj.object_type in ('W','C')
1768: AND obj.object_user_id = u.user_id)
1769: LOOP
1770: l_all_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_all_rolename, all_rec.user_name);
1771: END LOOP;
1772:
1773: -- Change the status to submitted to shared for the template records
1774: UPDATE zpb_dc_objects

Line 2110: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);

2106: -- Create the roles for Approver and Submitter users
2107: l_charDate := to_char(sysdate, 'J-SSSSS');
2108: l_appr_rolename := 'ZPB_NOTE_APPR'|| to_char(l_object_id) || '-' || l_charDate;
2109: l_subtr_rolename := 'ZPB_NOTE_SUBTR'|| to_char(l_object_id) || '-' || l_charDate;
2110: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);
2111: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);
2112: -- Set the recipients of the ntfs --
2113:
2114: OPEN approver_csr;

Line 2111: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);

2107: l_charDate := to_char(sysdate, 'J-SSSSS');
2108: l_appr_rolename := 'ZPB_NOTE_APPR'|| to_char(l_object_id) || '-' || l_charDate;
2109: l_subtr_rolename := 'ZPB_NOTE_SUBTR'|| to_char(l_object_id) || '-' || l_charDate;
2110: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);
2111: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);
2112: -- Set the recipients of the ntfs --
2113:
2114: OPEN approver_csr;
2115: FETCH approver_csr INTO l_approver;

Line 2135: l_appr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_appr_rolename, l_approver);

2131: AND obj.object_user_id = fnd.user_id;
2132: END IF;
2133: END IF;
2134:
2135: l_appr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_appr_rolename, l_approver);
2136: wf_engine.SetItemAttrText(
2137: Itemtype => ItemType,
2138: Itemkey => ItemKey,
2139: aname => 'DC_APPROVER',

Line 2146: l_subtr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_subtr_rolename, l_submitter);

2142: OPEN submitter_csr;
2143: FETCH submitter_csr INTO l_submitter;
2144: CLOSE submitter_csr;
2145:
2146: l_subtr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_subtr_rolename, l_submitter);
2147: wf_engine.SetItemAttrText(
2148: Itemtype => ItemType,
2149: Itemkey => ItemKey,
2150: aname => 'DC_SUBMITTER',

Line 2209: zpb_wf_ntf.SetRole(l_frozen_rolename, l_exp_days);

2205:
2206: -- Create the role for frozen ws user
2207: l_charDate := to_char(sysdate, 'J-SSSSS');
2208: l_frozen_rolename := 'ZPB_DC_SUB_FZN'|| to_char(l_object_id) || '-' || l_charDate;
2209: zpb_wf_ntf.SetRole(l_frozen_rolename, l_exp_days);
2210: l_frzn_role_has_users := 'N';
2211: FOR frozen_user_rec IN (
2212: SELECT u.user_name as user_name
2213: FROM zpb_dc_objects obj, fnd_user u

Line 2219: l_frozen_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_frozen_rolename, frozen_user_rec.user_name);

2215: AND obj.object_type = 'W'
2216: AND obj.status = 'FROZEN'
2217: AND obj.object_user_id = u.user_id)
2218: LOOP
2219: l_frozen_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_frozen_rolename, frozen_user_rec.user_name);
2220: l_frzn_role_has_users := 'Y';
2221: END LOOP;
2222:
2223: wf_engine.SetItemAttrText(

Line 2339: zpb_wf.submit_to_shared(l_object_user_id, l_template_id, l_req_id);

2335: avalue => l_template_name);
2336:
2337: -- Push data to shared AW --
2338: fnd_global.apps_initialize(l_user_id,l_resp_id,l_respapp_id);
2339: zpb_wf.submit_to_shared(l_object_user_id, l_template_id, l_req_id);
2340:
2341: -- Set the values for wait for concurrent program
2342: wf_engine.SetItemAttrNumber(
2343: Itemtype => ItemType,

Line 2523: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);

2519: -- Create the roles for Approver and Submitter users
2520: l_char_date := to_char(sysdate, 'J-SSSSS');
2521: l_appr_rolename := 'ZPB_APP_APPR'|| to_char(p_object_id) || '-' || l_char_date;
2522: l_subtr_rolename := 'ZPB_APP_SUBTR'|| to_char(p_object_id) || '-' || l_char_date;
2523: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);
2524: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);
2525:
2526: wf_event.AddParameterToList(
2527: p_name => '#FROM_ROLE',

Line 2524: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);

2520: l_char_date := to_char(sysdate, 'J-SSSSS');
2521: l_appr_rolename := 'ZPB_APP_APPR'|| to_char(p_object_id) || '-' || l_char_date;
2522: l_subtr_rolename := 'ZPB_APP_SUBTR'|| to_char(p_object_id) || '-' || l_char_date;
2523: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);
2524: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);
2525:
2526: wf_event.AddParameterToList(
2527: p_name => '#FROM_ROLE',
2528: p_value => l_from_name,

Line 2536: l_subtr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_subtr_rolename, l_submitter);

2532: p_name => 'DC_APPROVER_FOR_MSG',
2533: p_value => l_approver_for_msg,
2534: p_parameterlist=> l_parameter_list);
2535:
2536: l_subtr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_subtr_rolename, l_submitter);
2537: wf_event.AddParameterToList(
2538: p_name => 'DC_SUBMITTER',
2539: p_value => l_subtr_rolename,
2540: p_parameterlist=> l_parameter_list);

Line 2734: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);

2730: -- Create the roles for Approver and Submitter users
2731: l_char_date := to_char(sysdate, 'J-SSSSS');
2732: l_appr_rolename := 'ZPB_REJ_APPR'|| to_char(p_object_id) || '-' || l_char_date;
2733: l_subtr_rolename := 'ZPB_REJ_SUBTR'|| to_char(p_object_id) || '-' || l_char_date;
2734: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);
2735: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);
2736:
2737: wf_event.AddParameterToList(
2738: p_name => '#FROM_ROLE',

Line 2735: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);

2731: l_char_date := to_char(sysdate, 'J-SSSSS');
2732: l_appr_rolename := 'ZPB_REJ_APPR'|| to_char(p_object_id) || '-' || l_char_date;
2733: l_subtr_rolename := 'ZPB_REJ_SUBTR'|| to_char(p_object_id) || '-' || l_char_date;
2734: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);
2735: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);
2736:
2737: wf_event.AddParameterToList(
2738: p_name => '#FROM_ROLE',
2739: p_value => l_from_name,

Line 2747: l_subtr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_subtr_rolename, l_submitter);

2743: p_name => 'DC_APPROVER_FOR_MSG',
2744: p_value => l_approver_for_msg,
2745: p_parameterlist=> l_parameter_list);
2746:
2747: l_subtr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_subtr_rolename, l_submitter);
2748: wf_event.AddParameterToList(
2749: p_name => 'DC_SUBMITTER',
2750: p_value => l_subtr_rolename,
2751: p_parameterlist=> l_parameter_list);