DBA Data[Home] [Help]

APPS.ZPB_DC_WF dependencies on FND_NEW_MESSAGES

Line 29: l_issue_msg fnd_new_messages.message_text%TYPE;

25: l_template_name zpb_dc_objects.template_name%TYPE;
26: l_template_id number;
27: l_wait_for_review varchar2(1);
28: l_owner varchar2(30);
29: l_issue_msg fnd_new_messages.message_text%TYPE;
30:
31: BEGIN
32:
33: IF (funcmode = 'RUN') THEN

Line 299: l_issue_msg fnd_new_messages.message_text%TYPE;

295: l_object_user_name fnd_user.description%TYPE;
296: l_distribute_message zpb_task_parameters.value%TYPE;
297: l_template_name zpb_dc_objects.template_name%TYPE;
298: l_prior_item_key zpb_analysis_cycle_tasks.item_key%TYPE;
299: l_issue_msg fnd_new_messages.message_text%TYPE;
300:
301: l_respapp_id number := 0;
302: l_user_id number := 0;
303: l_resp_id number := 0;

Line 443: l_process_name fnd_new_messages.message_text%TYPE;

439: l_rolename VARCHAR2(320);
440: l_dist_list_id NUMBER;
441: l_recipient_type VARCHAR2(30);
442: l_owner VARCHAR2(30);
443: l_process_name fnd_new_messages.message_text%TYPE;
444: l_from_name fnd_user.user_name%TYPE;
445: l_template_name zpb_dc_objects.template_name%TYPE;
446:
447: l_api_version NUMBER;

Line 2269: l_process_name fnd_new_messages.message_text%TYPE;

2265: l_template_id NUMBER;
2266: l_object_id NUMBER;
2267: l_object_user_id NUMBER;
2268: l_owner VARCHAR2(30);
2269: l_process_name fnd_new_messages.message_text%TYPE;
2270: l_template_name zpb_dc_objects.template_name%TYPE;
2271:
2272: l_user_id NUMBER ;
2273: l_resp_id NUMBER ;