APPS.ZPB_DC_OBJECTS_PVT dependencies on ZPB_WF_NTF

Line 2346: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);

2342:
2343: -- Create the role
2344: l_charDate := to_char(sysdate, 'J-SSSSS');
2345: l_rolename := 'ZPB_DC_TMPL_USER'|| to_char(p_template_id) || '-' || l_charDate;
2346: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);
2347:
2348: FND_FILE.Put_Line ( FND_FILE.LOG, 'set_template_recipient - l_rolename=' || l_rolename ) ;
2349: FOR template_user_rec IN template_user_csr
2350: LOOP

Line 2352: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, template_user_rec.user_name);

2348: FND_FILE.Put_Line ( FND_FILE.LOG, 'set_template_recipient - l_rolename=' || l_rolename ) ;
2349: FOR template_user_rec IN template_user_csr
2350: LOOP
2351: FND_FILE.Put_Line ( FND_FILE.LOG, 'set_template_recipient - template_user_rec.user_name=' || template_user_rec.user_name ) ;
2352: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, template_user_rec.user_name);
2353: FND_FILE.Put_Line ( FND_FILE.LOG, 'set_template_recipient - after call to update_Role_with_Shadows') ;
2354: END LOOP;
2355: x_role_name := l_rolename;
2356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2502: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);

2498:
2499: -- Create the role
2500: l_charDate := to_char(sysdate, 'J-SSSSS');
2501: l_rolename := 'ZPB_DC_AUTO'|| to_char(p_task_id) || '-' || l_charDate;
2502: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);
2503: l_role_has_users := 'N';
2504:
2505: SELECT object_id, object_user_id
2506: INTO l_object_id, l_object_user_id

Line 2516: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, l_user );

2512: OPEN specific_user_csr;
2513: LOOP
2514: FETCH specific_user_csr INTO l_user;
2515: EXIT WHEN specific_user_csr%NOTFOUND;
2516: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, l_user );
2517: l_role_has_users := 'Y';
2518: END LOOP;
2519: CLOSE specific_user_csr;
2520:

Line 2580: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, fnd_rec.user_name);

2576: fnd_user fndu
2577: where fndu.user_id = aw_users.column_value
2578: )
2579: LOOP
2580: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, fnd_rec.user_name);
2581: l_role_has_users := 'Y';
2582: END LOOP;
2583:
2584: END IF; --recipients types

Line 2607: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);

2603: l_charDate := to_char(sysdate, 'J-SSSSS');
2604: l_rolename := 'ZPB_DC_MAN'|| to_char(p_dist_list_id) || '-' || l_charDate;
2605: ZPB_LOG.WRITE(G_PKG_NAME||'.'||l_api_name, ' l_rolename='||l_rolename);
2606:
2607: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);
2608:
2609: l_role_has_users := 'N';
2610:
2611: IF (p_recipient_type ='SPECIFIC_USERS') THEN

Line 2619: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, l_user);

2615: OPEN dist_list_csr;
2616: LOOP
2617: FETCH dist_list_csr INTO l_user;
2618: EXIT WHEN dist_list_csr%NOTFOUND;
2619: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, l_user);
2620: l_role_has_users := 'Y';
2621: END LOOP;
2622: CLOSE dist_list_csr;
2623:

Line 2684: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, fnd_rec.user_name);

2680: fnd_user fndu
2681: where fndu.user_id = aw_users.column_value
2682: )
2683: LOOP
2684: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, fnd_rec.user_name);
2685: l_role_has_users := 'Y';
2686: END LOOP;
2687:
2688: END IF; --recipients types

Line 3022: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);

3018:
3019: -- Create the role
3020: l_charDate := to_char(sysdate, 'J-SSSSS');
3021: l_rolename := 'ZPB_DC_SUB'|| to_char(p_object_id) || '-' || l_charDate;
3022: zpb_wf_ntf.SetRole(l_rolename, l_exp_days);
3023:
3024: get_user_id_clob(
3025: p_api_version => p_api_version,
3026: p_init_msg_list => p_init_msg_list,