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 FND_USER

Line 133: l_from_name fnd_user.user_name%TYPE;

129: IS
130: l_wait_for_review varchar2(1);
131: l_notify zpb_task_parameters.value%TYPE;
132: l_task_id number;
133: l_from_name fnd_user.user_name%TYPE;
134: l_user_id number;
135: l_template_name zpb_dc_objects.template_name%TYPE;
136:
137: BEGIN

Line 152: SELECT fnd.user_name

148: Itemkey => ItemKey,
149: aname => 'TASKID');
150:
151: -- Populate the from field in the notification details page
152: SELECT fnd.user_name
153: INTO l_from_name
154: FROM fnd_user fnd,zpb_dc_objects obj
155: WHERE fnd.user_id = obj.object_user_id
156: AND obj.generate_template_task_id = l_task_id

Line 154: FROM fnd_user fnd,zpb_dc_objects obj

150:
151: -- Populate the from field in the notification details page
152: SELECT fnd.user_name
153: INTO l_from_name
154: FROM fnd_user fnd,zpb_dc_objects obj
155: WHERE fnd.user_id = obj.object_user_id
156: AND obj.generate_template_task_id = l_task_id
157: AND obj.object_type = 'M';
158:

Line 155: WHERE fnd.user_id = obj.object_user_id

151: -- Populate the from field in the notification details page
152: SELECT fnd.user_name
153: INTO l_from_name
154: FROM fnd_user fnd,zpb_dc_objects obj
155: WHERE fnd.user_id = obj.object_user_id
156: AND obj.generate_template_task_id = l_task_id
157: AND obj.object_type = 'M';
158:
159: wf_engine.SetItemAttrText(

Line 295: l_object_user_name fnd_user.description%TYPE;

291: l_ac_template_id number := 0;
292: l_req_id number := 0;
293: l_object_id number;
294: l_object_user_id number;
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;

Line 373: SELECT nvl(fnd.description,fnd.user_name)

369: Itemkey => ItemKey,
370: aname => 'RESPAPPID');
371:
372: -- Get the user name to populate dc distributors
373: SELECT nvl(fnd.description,fnd.user_name)
374: INTO l_object_user_name
375: FROM fnd_user fnd, zpb_dc_objects obj
376: WHERE fnd.user_id = obj.object_user_id
377: AND obj.template_id = l_template_id

Line 375: FROM fnd_user fnd, zpb_dc_objects obj

371:
372: -- Get the user name to populate dc distributors
373: SELECT nvl(fnd.description,fnd.user_name)
374: INTO l_object_user_name
375: FROM fnd_user fnd, zpb_dc_objects obj
376: WHERE fnd.user_id = obj.object_user_id
377: AND obj.template_id = l_template_id
378: AND obj.object_type = 'M';
379:

Line 376: WHERE fnd.user_id = obj.object_user_id

372: -- Get the user name to populate dc distributors
373: SELECT nvl(fnd.description,fnd.user_name)
374: INTO l_object_user_name
375: FROM fnd_user fnd, zpb_dc_objects obj
376: WHERE fnd.user_id = obj.object_user_id
377: AND obj.template_id = l_template_id
378: AND obj.object_type = 'M';
379:
380: wf_engine.SetItemAttrText(

Line 444: l_from_name fnd_user.user_name%TYPE;

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;
448: l_init_msg_list VARCHAR2(1);

Line 554: FROM fnd_user

550: END IF;
551:
552: SELECT user_name
553: INTO l_from_name
554: FROM fnd_user
555: WHERE user_id = l_object_user_id;
556:
557: wf_engine.SetItemAttrText(
558: Itemtype => ItemType,

Line 733: wf_event.AddParameterToList(p_name=>'FND_USER_ID',

729:
730: -- set fnd values so workflow process can use this values
731: -- since they can now be run in deferred mode
732:
733: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
734: p_value=> fnd_global.user_id,
735: p_parameterlist=>l_parameter_list);
736:
737:

Line 810: l_object_user_name fnd_user.description%TYPE;

806: l_overwrite_cust varchar2(30);
807: l_overwrite_data varchar2(30);
808: l_req_id number;
809: l_object_user_id number;
810: l_object_user_name fnd_user.description%TYPE;
811: l_from_name fnd_user.user_name%TYPE;
812: l_message varchar2(4000);
813:
814: l_user_id number;

Line 811: l_from_name fnd_user.user_name%TYPE;

807: l_overwrite_data varchar2(30);
808: l_req_id number;
809: l_object_user_id number;
810: l_object_user_name fnd_user.description%TYPE;
811: l_from_name fnd_user.user_name%TYPE;
812: l_message varchar2(4000);
813:
814: l_user_id number;
815: l_resp_id number;

Line 871: aname => 'FND_USER_ID');

867:
868: l_user_id := wf_engine.GetItemAttrNumber(
869: Itemtype => ItemType,
870: Itemkey => ItemKey,
871: aname => 'FND_USER_ID');
872:
873: l_resp_id := wf_engine.GetItemAttrNumber(
874: Itemtype => ItemType,
875: Itemkey => ItemKey,

Line 884: SELECT nvl(fnd.description,fnd.user_name)

880: Itemkey => ItemKey,
881: aname => 'FND_APPLICATION_ID');
882:
883: -- Get the object user id to populate dc distributors
884: SELECT nvl(fnd.description,fnd.user_name)
885: INTO l_object_user_name
886: FROM fnd_user fnd,zpb_dc_objects obj
887: WHERE fnd.user_id = obj.object_user_id
888: AND obj.object_id = l_object_id;

Line 886: FROM fnd_user fnd,zpb_dc_objects obj

882:
883: -- Get the object user id to populate dc distributors
884: SELECT nvl(fnd.description,fnd.user_name)
885: INTO l_object_user_name
886: FROM fnd_user fnd,zpb_dc_objects obj
887: WHERE fnd.user_id = obj.object_user_id
888: AND obj.object_id = l_object_id;
889:
890: wf_engine.SetItemAttrText(

Line 887: WHERE fnd.user_id = obj.object_user_id

883: -- Get the object user id to populate dc distributors
884: SELECT nvl(fnd.description,fnd.user_name)
885: INTO l_object_user_name
886: FROM fnd_user fnd,zpb_dc_objects obj
887: WHERE fnd.user_id = obj.object_user_id
888: AND obj.object_id = l_object_id;
889:
890: wf_engine.SetItemAttrText(
891: Itemtype => ItemType,

Line 898: SELECT fnd.user_name

894: avalue => l_object_user_name);
895:
896: /* Populate the from field in the notification details page
897: This name should be user name from the fnd table */
898: SELECT fnd.user_name
899: INTO l_from_name
900: FROM fnd_user fnd,zpb_dc_objects obj
901: WHERE fnd.user_id = obj.object_user_id
902: AND obj.object_id = l_object_id;

Line 900: FROM fnd_user fnd,zpb_dc_objects obj

896: /* Populate the from field in the notification details page
897: This name should be user name from the fnd table */
898: SELECT fnd.user_name
899: INTO l_from_name
900: FROM fnd_user fnd,zpb_dc_objects obj
901: WHERE fnd.user_id = obj.object_user_id
902: AND obj.object_id = l_object_id;
903:
904: wf_engine.SetItemAttrText(

Line 901: WHERE fnd.user_id = obj.object_user_id

897: This name should be user name from the fnd table */
898: SELECT fnd.user_name
899: INTO l_from_name
900: FROM fnd_user fnd,zpb_dc_objects obj
901: WHERE fnd.user_id = obj.object_user_id
902: AND obj.object_id = l_object_id;
903:
904: wf_engine.SetItemAttrText(
905: Itemtype => ItemType,

Line 979: l_from_name fnd_user.user_name%TYPE;

975: l_count NUMBER ;
976: l_instance_id NUMBER ;
977: l_ac_template_id NUMBER ;
978: l_object_user_id NUMBER ;
979: l_from_name fnd_user.user_name%TYPE;
980: BEGIN
981:
982: l_task_id := 0;
983: l_count := 0;

Line 1046: FROM fnd_user

1042: AND object_type = 'M';
1043:
1044: SELECT user_name
1045: INTO l_from_name
1046: FROM fnd_user
1047: WHERE user_id = l_object_user_id;
1048:
1049: wf_engine.SetItemAttrText(
1050: Itemtype => ItemType,

Line 1155: FROM zpb_dc_objects, fnd_user

1151: l_approval_required_flag = 'N' AND
1152: l_multiple_submissions_flag <>'Y') THEN
1153: SELECT count(*)
1154: INTO l_ws_status_count
1155: FROM zpb_dc_objects, fnd_user
1156: WHERE object_user_id = user_id
1157: AND template_id = l_template_id
1158: AND object_type = 'W'
1159: AND status NOT IN ('SUBMITTED_TO_SHARED')

Line 1552: wf_event.AddParameterToList(p_name=>'FND_USER_ID',

1548:
1549: -- set fnd values so workflow process can use this values
1550: -- since they can now be run in deferred mode
1551:
1552: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
1553: p_value=> fnd_global.user_id,
1554: p_parameterlist=>l_parameter_list);
1555:
1556: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

Line 1698: l_object_user_name fnd_user.description%TYPE;

1694: l_object_id NUMBER;
1695: l_object_user_id NUMBER;
1696: l_template_name VARCHAR2(1000);
1697:
1698: l_object_user_name fnd_user.description%TYPE;
1699: l_from_name fnd_user.user_name%TYPE;
1700: l_frzn_rolename VARCHAR2(320);
1701: l_all_rolename VARCHAR2(320);
1702: l_exp_days NUMBER;

Line 1699: l_from_name fnd_user.user_name%TYPE;

1695: l_object_user_id NUMBER;
1696: l_template_name VARCHAR2(1000);
1697:
1698: l_object_user_name fnd_user.description%TYPE;
1699: l_from_name fnd_user.user_name%TYPE;
1700: l_frzn_rolename VARCHAR2(320);
1701: l_all_rolename VARCHAR2(320);
1702: l_exp_days NUMBER;
1703: l_charDate VARCHAR2(20);

Line 1730: SELECT nvl(fnd.description,fnd.user_name), object_user_id

1726: AND object_type = 'M';
1727:
1728:
1729: -- Populate the dc approver for frozen ntf
1730: SELECT nvl(fnd.description,fnd.user_name), object_user_id
1731: INTO l_object_user_name, l_object_user_id
1732: FROM zpb_dc_objects, fnd_user fnd
1733: WHERE object_id = l_object_id
1734: AND object_user_id = fnd.user_id;

Line 1732: FROM zpb_dc_objects, fnd_user fnd

1728:
1729: -- Populate the dc approver for frozen ntf
1730: SELECT nvl(fnd.description,fnd.user_name), object_user_id
1731: INTO l_object_user_name, l_object_user_id
1732: FROM zpb_dc_objects, fnd_user fnd
1733: WHERE object_id = l_object_id
1734: AND object_user_id = fnd.user_id;
1735:
1736: -- Populate FROM field

Line 1734: AND object_user_id = fnd.user_id;

1730: SELECT nvl(fnd.description,fnd.user_name), object_user_id
1731: INTO l_object_user_name, l_object_user_id
1732: FROM zpb_dc_objects, fnd_user fnd
1733: WHERE object_id = l_object_id
1734: AND object_user_id = fnd.user_id;
1735:
1736: -- Populate FROM field
1737: SELECT fnd.user_name
1738: INTO l_from_name

Line 1737: SELECT fnd.user_name

1733: WHERE object_id = l_object_id
1734: AND object_user_id = fnd.user_id;
1735:
1736: -- Populate FROM field
1737: SELECT fnd.user_name
1738: INTO l_from_name
1739: FROM fnd_user fnd, zpb_dc_objects
1740: WHERE object_id = l_object_id
1741: AND object_user_id = fnd.user_id;

Line 1739: FROM fnd_user fnd, zpb_dc_objects

1735:
1736: -- Populate FROM field
1737: SELECT fnd.user_name
1738: INTO l_from_name
1739: FROM fnd_user fnd, zpb_dc_objects
1740: WHERE object_id = l_object_id
1741: AND object_user_id = fnd.user_id;
1742:
1743: -- Create the roles for fromzen and all users

Line 1741: AND object_user_id = fnd.user_id;

1737: SELECT fnd.user_name
1738: INTO l_from_name
1739: FROM fnd_user fnd, zpb_dc_objects
1740: WHERE object_id = l_object_id
1741: AND object_user_id = fnd.user_id;
1742:
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;

Line 1752: FROM zpb_dc_objects obj, fnd_user u

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
1753: WHERE obj.template_id = l_template_id
1754: AND obj.object_type = 'W'
1755: AND obj.status NOT IN ('SUBMITTED','FROZEN','APPROVED','SUBMITTED_TO_SHARED')
1756: AND obj.object_user_id = u.user_id

Line 1765: FROM zpb_dc_objects obj, fnd_user u

1761: END LOOP;
1762:
1763: FOR all_rec IN (
1764: SELECT u.user_name as user_name
1765: FROM zpb_dc_objects obj, fnd_user u
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

Line 2033: l_approver_for_msg fnd_user.description%TYPE;

2029: l_dist_method zpb_dc_objects.distribution_method%TYPE;
2030: l_template_name zpb_dc_objects.template_name%TYPE;
2031: l_object_id NUMBER;
2032: l_template_id NUMBER;
2033: l_approver_for_msg fnd_user.description%TYPE;
2034: l_submitter_for_msg fnd_user.description%TYPE;
2035: l_from_name fnd_user.user_name%TYPE;
2036: l_approver fnd_user.user_name%TYPE;
2037: l_submitter fnd_user.user_name%TYPE;

Line 2034: l_submitter_for_msg fnd_user.description%TYPE;

2030: l_template_name zpb_dc_objects.template_name%TYPE;
2031: l_object_id NUMBER;
2032: l_template_id NUMBER;
2033: l_approver_for_msg fnd_user.description%TYPE;
2034: l_submitter_for_msg fnd_user.description%TYPE;
2035: l_from_name fnd_user.user_name%TYPE;
2036: l_approver fnd_user.user_name%TYPE;
2037: l_submitter fnd_user.user_name%TYPE;
2038: l_exp_days NUMBER := 7;

Line 2035: l_from_name fnd_user.user_name%TYPE;

2031: l_object_id NUMBER;
2032: l_template_id NUMBER;
2033: l_approver_for_msg fnd_user.description%TYPE;
2034: l_submitter_for_msg fnd_user.description%TYPE;
2035: l_from_name fnd_user.user_name%TYPE;
2036: l_approver fnd_user.user_name%TYPE;
2037: l_submitter fnd_user.user_name%TYPE;
2038: l_exp_days NUMBER := 7;
2039: l_charDate VARCHAR2(20);

Line 2036: l_approver fnd_user.user_name%TYPE;

2032: l_template_id NUMBER;
2033: l_approver_for_msg fnd_user.description%TYPE;
2034: l_submitter_for_msg fnd_user.description%TYPE;
2035: l_from_name fnd_user.user_name%TYPE;
2036: l_approver fnd_user.user_name%TYPE;
2037: l_submitter fnd_user.user_name%TYPE;
2038: l_exp_days NUMBER := 7;
2039: l_charDate VARCHAR2(20);
2040: l_frozen_rolename VARCHAR2(320);

Line 2037: l_submitter fnd_user.user_name%TYPE;

2033: l_approver_for_msg fnd_user.description%TYPE;
2034: l_submitter_for_msg fnd_user.description%TYPE;
2035: l_from_name fnd_user.user_name%TYPE;
2036: l_approver fnd_user.user_name%TYPE;
2037: l_submitter fnd_user.user_name%TYPE;
2038: l_exp_days NUMBER := 7;
2039: l_charDate VARCHAR2(20);
2040: l_frozen_rolename VARCHAR2(320);
2041: l_appr_rolename VARCHAR2(320);

Line 2054: SELECT fnd.user_name

2050: l_msg_data VARCHAR2(4000);
2051: l_frzn_role_has_users VARCHAR2(1);
2052:
2053: CURSOR approver_csr IS
2054: SELECT fnd.user_name
2055: FROM zpb_dc_objects obj, fnd_user fnd
2056: WHERE obj.object_id = l_object_id
2057: AND obj.approver_user_id = fnd.user_id;
2058:

Line 2055: FROM zpb_dc_objects obj, fnd_user fnd

2051: l_frzn_role_has_users VARCHAR2(1);
2052:
2053: CURSOR approver_csr IS
2054: SELECT fnd.user_name
2055: FROM zpb_dc_objects obj, fnd_user fnd
2056: WHERE obj.object_id = l_object_id
2057: AND obj.approver_user_id = fnd.user_id;
2058:
2059: CURSOR submitter_csr IS

Line 2057: AND obj.approver_user_id = fnd.user_id;

2053: CURSOR approver_csr IS
2054: SELECT fnd.user_name
2055: FROM zpb_dc_objects obj, fnd_user fnd
2056: WHERE obj.object_id = l_object_id
2057: AND obj.approver_user_id = fnd.user_id;
2058:
2059: CURSOR submitter_csr IS
2060: SELECT fnd.user_name
2061: FROM zpb_dc_objects obj, fnd_user fnd

Line 2060: SELECT fnd.user_name

2056: WHERE obj.object_id = l_object_id
2057: AND obj.approver_user_id = fnd.user_id;
2058:
2059: CURSOR submitter_csr IS
2060: SELECT fnd.user_name
2061: FROM zpb_dc_objects obj, fnd_user fnd
2062: WHERE obj.object_id = l_object_id
2063: AND obj.object_user_id = fnd.user_id;
2064:

Line 2061: FROM zpb_dc_objects obj, fnd_user fnd

2057: AND obj.approver_user_id = fnd.user_id;
2058:
2059: CURSOR submitter_csr IS
2060: SELECT fnd.user_name
2061: FROM zpb_dc_objects obj, fnd_user fnd
2062: WHERE obj.object_id = l_object_id
2063: AND obj.object_user_id = fnd.user_id;
2064:
2065: CURSOR approver_for_msg_csr IS

Line 2063: AND obj.object_user_id = fnd.user_id;

2059: CURSOR submitter_csr IS
2060: SELECT fnd.user_name
2061: FROM zpb_dc_objects obj, fnd_user fnd
2062: WHERE obj.object_id = l_object_id
2063: AND obj.object_user_id = fnd.user_id;
2064:
2065: CURSOR approver_for_msg_csr IS
2066: SELECT nvl(fnd.description, fnd.user_name)
2067: FROM zpb_dc_objects obj, fnd_user fnd

Line 2066: SELECT nvl(fnd.description, fnd.user_name)

2062: WHERE obj.object_id = l_object_id
2063: AND obj.object_user_id = fnd.user_id;
2064:
2065: CURSOR approver_for_msg_csr IS
2066: SELECT nvl(fnd.description, fnd.user_name)
2067: FROM zpb_dc_objects obj, fnd_user fnd
2068: WHERE obj.object_id = l_object_id
2069: AND obj.approver_user_id = fnd.user_id;
2070:

Line 2067: FROM zpb_dc_objects obj, fnd_user fnd

2063: AND obj.object_user_id = fnd.user_id;
2064:
2065: CURSOR approver_for_msg_csr IS
2066: SELECT nvl(fnd.description, fnd.user_name)
2067: FROM zpb_dc_objects obj, fnd_user fnd
2068: WHERE obj.object_id = l_object_id
2069: AND obj.approver_user_id = fnd.user_id;
2070:
2071: CURSOR submitter_for_msg_csr IS

Line 2069: AND obj.approver_user_id = fnd.user_id;

2065: CURSOR approver_for_msg_csr IS
2066: SELECT nvl(fnd.description, fnd.user_name)
2067: FROM zpb_dc_objects obj, fnd_user fnd
2068: WHERE obj.object_id = l_object_id
2069: AND obj.approver_user_id = fnd.user_id;
2070:
2071: CURSOR submitter_for_msg_csr IS
2072: SELECT nvl(fnd.description, fnd.user_name)
2073: FROM zpb_dc_objects obj, fnd_user fnd

Line 2072: SELECT nvl(fnd.description, fnd.user_name)

2068: WHERE obj.object_id = l_object_id
2069: AND obj.approver_user_id = fnd.user_id;
2070:
2071: CURSOR submitter_for_msg_csr IS
2072: SELECT nvl(fnd.description, fnd.user_name)
2073: FROM zpb_dc_objects obj, fnd_user fnd
2074: WHERE obj.object_id = l_object_id
2075: AND obj.object_user_id = fnd.user_id;
2076:

Line 2073: FROM zpb_dc_objects obj, fnd_user fnd

2069: AND obj.approver_user_id = fnd.user_id;
2070:
2071: CURSOR submitter_for_msg_csr IS
2072: SELECT nvl(fnd.description, fnd.user_name)
2073: FROM zpb_dc_objects obj, fnd_user fnd
2074: WHERE obj.object_id = l_object_id
2075: AND obj.object_user_id = fnd.user_id;
2076:
2077: BEGIN

Line 2075: AND obj.object_user_id = fnd.user_id;

2071: CURSOR submitter_for_msg_csr IS
2072: SELECT nvl(fnd.description, fnd.user_name)
2073: FROM zpb_dc_objects obj, fnd_user fnd
2074: WHERE obj.object_id = l_object_id
2075: AND obj.object_user_id = fnd.user_id;
2076:
2077: BEGIN
2078: IF (funcmode = 'RUN') THEN
2079: l_object_id := wf_engine.GetItemAttrNumber(

Line 2119: SELECT fnd.user_name

2115: FETCH approver_csr INTO l_approver;
2116: CLOSE approver_csr;
2117:
2118: IF (l_approver IS NULL) THEN
2119: SELECT fnd.user_name
2120: INTO l_approver
2121: FROM zpb_dc_objects obj, fnd_user fnd
2122: WHERE obj.object_id = l_object_id
2123: AND obj.distributor_user_id = fnd.user_id;

Line 2121: FROM zpb_dc_objects obj, fnd_user fnd

2117:
2118: IF (l_approver IS NULL) THEN
2119: SELECT fnd.user_name
2120: INTO l_approver
2121: FROM zpb_dc_objects obj, fnd_user fnd
2122: WHERE obj.object_id = l_object_id
2123: AND obj.distributor_user_id = fnd.user_id;
2124:
2125: IF (l_approver IS NULL) THEN -- -100 --

Line 2123: AND obj.distributor_user_id = fnd.user_id;

2119: SELECT fnd.user_name
2120: INTO l_approver
2121: FROM zpb_dc_objects obj, fnd_user fnd
2122: WHERE obj.object_id = l_object_id
2123: AND obj.distributor_user_id = fnd.user_id;
2124:
2125: IF (l_approver IS NULL) THEN -- -100 --
2126: SELECT fnd.user_name
2127: INTO l_approver

Line 2126: SELECT fnd.user_name

2122: WHERE obj.object_id = l_object_id
2123: AND obj.distributor_user_id = fnd.user_id;
2124:
2125: IF (l_approver IS NULL) THEN -- -100 --
2126: SELECT fnd.user_name
2127: INTO l_approver
2128: FROM zpb_dc_objects obj, fnd_user fnd
2129: WHERE obj.template_id = l_template_id
2130: AND obj.object_type = 'M'

Line 2128: FROM zpb_dc_objects obj, fnd_user fnd

2124:
2125: IF (l_approver IS NULL) THEN -- -100 --
2126: SELECT fnd.user_name
2127: INTO l_approver
2128: FROM zpb_dc_objects obj, fnd_user fnd
2129: WHERE obj.template_id = l_template_id
2130: AND obj.object_type = 'M'
2131: AND obj.object_user_id = fnd.user_id;
2132: END IF;

Line 2131: AND obj.object_user_id = fnd.user_id;

2127: INTO l_approver
2128: FROM zpb_dc_objects obj, fnd_user fnd
2129: WHERE obj.template_id = l_template_id
2130: AND obj.object_type = 'M'
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);

Line 2160: SELECT nvl(fnd.description, fnd.user_name)

2156: FETCH approver_for_msg_csr INTO l_approver_for_msg;
2157: CLOSE approver_for_msg_csr;
2158:
2159: IF (l_approver_for_msg IS NULL) THEN
2160: SELECT nvl(fnd.description, fnd.user_name)
2161: INTO l_approver_for_msg
2162: FROM zpb_dc_objects obj, fnd_user fnd
2163: WHERE obj.object_id = l_object_id
2164: AND obj.distributor_user_id = fnd.user_id;

Line 2162: FROM zpb_dc_objects obj, fnd_user fnd

2158:
2159: IF (l_approver_for_msg IS NULL) THEN
2160: SELECT nvl(fnd.description, fnd.user_name)
2161: INTO l_approver_for_msg
2162: FROM zpb_dc_objects obj, fnd_user fnd
2163: WHERE obj.object_id = l_object_id
2164: AND obj.distributor_user_id = fnd.user_id;
2165:
2166: IF (l_approver_for_msg IS NULL) THEN -- -100 --

Line 2164: AND obj.distributor_user_id = fnd.user_id;

2160: SELECT nvl(fnd.description, fnd.user_name)
2161: INTO l_approver_for_msg
2162: FROM zpb_dc_objects obj, fnd_user fnd
2163: WHERE obj.object_id = l_object_id
2164: AND obj.distributor_user_id = fnd.user_id;
2165:
2166: IF (l_approver_for_msg IS NULL) THEN -- -100 --
2167: SELECT nvl(fnd.description, fnd.user_name)
2168: INTO l_approver_for_msg

Line 2167: SELECT nvl(fnd.description, fnd.user_name)

2163: WHERE obj.object_id = l_object_id
2164: AND obj.distributor_user_id = fnd.user_id;
2165:
2166: IF (l_approver_for_msg IS NULL) THEN -- -100 --
2167: SELECT nvl(fnd.description, fnd.user_name)
2168: INTO l_approver_for_msg
2169: FROM zpb_dc_objects obj, fnd_user fnd
2170: WHERE obj.template_id = l_template_id
2171: AND obj.object_type = 'M'

Line 2169: FROM zpb_dc_objects obj, fnd_user fnd

2165:
2166: IF (l_approver_for_msg IS NULL) THEN -- -100 --
2167: SELECT nvl(fnd.description, fnd.user_name)
2168: INTO l_approver_for_msg
2169: FROM zpb_dc_objects obj, fnd_user fnd
2170: WHERE obj.template_id = l_template_id
2171: AND obj.object_type = 'M'
2172: AND obj.object_user_id = fnd.user_id;
2173: END IF;

Line 2172: AND obj.object_user_id = fnd.user_id;

2168: INTO l_approver_for_msg
2169: FROM zpb_dc_objects obj, fnd_user fnd
2170: WHERE obj.template_id = l_template_id
2171: AND obj.object_type = 'M'
2172: AND obj.object_user_id = fnd.user_id;
2173: END IF;
2174: END IF;
2175:
2176: wf_engine.SetItemAttrText(

Line 2194: SELECT fnd.user_name

2190: avalue => l_submitter_for_msg);
2191:
2192: /* Populate the From field in notification details page
2193: Can not use description here, use user name*/
2194: SELECT fnd.user_name
2195: INTO l_from_name
2196: FROM fnd_user fnd, zpb_dc_objects obj
2197: WHERE obj.object_id = l_object_id
2198: AND obj.object_user_id = fnd.user_id;

Line 2196: FROM fnd_user fnd, zpb_dc_objects obj

2192: /* Populate the From field in notification details page
2193: Can not use description here, use user name*/
2194: SELECT fnd.user_name
2195: INTO l_from_name
2196: FROM fnd_user fnd, zpb_dc_objects obj
2197: WHERE obj.object_id = l_object_id
2198: AND obj.object_user_id = fnd.user_id;
2199:
2200: wf_engine.SetItemAttrText(

Line 2198: AND obj.object_user_id = fnd.user_id;

2194: SELECT fnd.user_name
2195: INTO l_from_name
2196: FROM fnd_user fnd, zpb_dc_objects obj
2197: WHERE obj.object_id = l_object_id
2198: AND obj.object_user_id = fnd.user_id;
2199:
2200: wf_engine.SetItemAttrText(
2201: Itemtype => ItemType,
2202: Itemkey => ItemKey,

Line 2213: FROM zpb_dc_objects obj, fnd_user u

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
2214: WHERE obj.template_id = l_template_id
2215: AND obj.object_type = 'W'
2216: AND obj.status = 'FROZEN'
2217: AND obj.object_user_id = u.user_id)

Line 2297: aname => 'FND_USER_ID');

2293:
2294: l_user_id := wf_engine.GetItemAttrNumber(
2295: Itemtype => ItemType,
2296: Itemkey => ItemKey,
2297: aname => 'FND_USER_ID');
2298:
2299: l_resp_id := wf_engine.GetItemAttrNumber(
2300: Itemtype => ItemType,
2301: Itemkey => ItemKey,

Line 2444: l_submitter fnd_user.user_name%TYPE;

2440: l_return_status VARCHAR2(1);
2441: l_msg_count NUMBER;
2442: l_msg_data VARCHAR2(4000);
2443: --
2444: l_submitter fnd_user.user_name%TYPE;
2445: l_approver_for_msg fnd_user.description%TYPE;
2446: l_template_name zpb_dc_objects.template_name%TYPE;
2447: l_substr_templ_name VARCHAR2(140);
2448: l_template_id NUMBER;

Line 2445: l_approver_for_msg fnd_user.description%TYPE;

2441: l_msg_count NUMBER;
2442: l_msg_data VARCHAR2(4000);
2443: --
2444: l_submitter fnd_user.user_name%TYPE;
2445: l_approver_for_msg fnd_user.description%TYPE;
2446: l_template_name zpb_dc_objects.template_name%TYPE;
2447: l_substr_templ_name VARCHAR2(140);
2448: l_template_id NUMBER;
2449: l_from_name fnd_user.user_name%TYPE;

Line 2449: l_from_name fnd_user.user_name%TYPE;

2445: l_approver_for_msg fnd_user.description%TYPE;
2446: l_template_name zpb_dc_objects.template_name%TYPE;
2447: l_substr_templ_name VARCHAR2(140);
2448: l_template_id NUMBER;
2449: l_from_name fnd_user.user_name%TYPE;
2450: l_sequence NUMBER;
2451: l_approval_type VARCHAR2(30);
2452: l_char_date VARCHAR2(30);
2453: l_exp_days NUMBER := 7;

Line 2491: FROM fnd_user

2487: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
2488:
2489: SELECT nvl(description,user_name)
2490: INTO l_approver_for_msg
2491: FROM fnd_user
2492: WHERE user_id= p_approver_user_id;
2493:
2494: SELECT user_name
2495: INTO l_from_name

Line 2496: FROM fnd_user

2492: WHERE user_id= p_approver_user_id;
2493:
2494: SELECT user_name
2495: INTO l_from_name
2496: FROM fnd_user
2497: WHERE user_id= p_approver_user_id;
2498:
2499: SELECT obj.template_name, fnd.user_name, obj.template_id
2500: INTO l_template_name, l_submitter, l_template_id

Line 2499: SELECT obj.template_name, fnd.user_name, obj.template_id

2495: INTO l_from_name
2496: FROM fnd_user
2497: WHERE user_id= p_approver_user_id;
2498:
2499: SELECT obj.template_name, fnd.user_name, obj.template_id
2500: INTO l_template_name, l_submitter, l_template_id
2501: FROM zpb_dc_objects obj, fnd_user fnd
2502: WHERE obj.object_id = p_object_id
2503: AND obj.object_user_id = fnd.user_id;

Line 2501: FROM zpb_dc_objects obj, fnd_user fnd

2497: WHERE user_id= p_approver_user_id;
2498:
2499: SELECT obj.template_name, fnd.user_name, obj.template_id
2500: INTO l_template_name, l_submitter, l_template_id
2501: FROM zpb_dc_objects obj, fnd_user fnd
2502: WHERE obj.object_id = p_object_id
2503: AND obj.object_user_id = fnd.user_id;
2504:
2505: SELECT ZPB_DC_WF_PROCESSES_S.nextval

Line 2503: AND obj.object_user_id = fnd.user_id;

2499: SELECT obj.template_name, fnd.user_name, obj.template_id
2500: INTO l_template_name, l_submitter, l_template_id
2501: FROM zpb_dc_objects obj, fnd_user fnd
2502: WHERE obj.object_id = p_object_id
2503: AND obj.object_user_id = fnd.user_id;
2504:
2505: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2506: INTO l_sequence
2507: FROM dual;

Line 2556: wf_event.AddParameterToList(p_name=>'FND_USER_ID',

2552: -- set fnd values so workflow process can use this values
2553: -- since they can now be run in deferred mode
2554: -- working:fnd_global.apps_initialize(1005258,57124,210);
2555:
2556: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2557: p_value=> fnd_global.user_id,
2558: p_parameterlist=>l_parameter_list);
2559:
2560: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

Line 2651: l_submitter fnd_user.user_name%TYPE;

2647: l_return_status VARCHAR2(1);
2648: l_msg_count NUMBER;
2649: l_msg_data VARCHAR2(4000);
2650: --
2651: l_submitter fnd_user.user_name%TYPE;
2652: l_approver_for_msg fnd_user.description%TYPE;
2653: l_template_name zpb_dc_objects.template_name%TYPE;
2654: l_substr_templ_name VARCHAR2(140);
2655: l_template_id NUMBER;

Line 2652: l_approver_for_msg fnd_user.description%TYPE;

2648: l_msg_count NUMBER;
2649: l_msg_data VARCHAR2(4000);
2650: --
2651: l_submitter fnd_user.user_name%TYPE;
2652: l_approver_for_msg fnd_user.description%TYPE;
2653: l_template_name zpb_dc_objects.template_name%TYPE;
2654: l_substr_templ_name VARCHAR2(140);
2655: l_template_id NUMBER;
2656: l_from_name fnd_user.user_name%TYPE;

Line 2656: l_from_name fnd_user.user_name%TYPE;

2652: l_approver_for_msg fnd_user.description%TYPE;
2653: l_template_name zpb_dc_objects.template_name%TYPE;
2654: l_substr_templ_name VARCHAR2(140);
2655: l_template_id NUMBER;
2656: l_from_name fnd_user.user_name%TYPE;
2657: l_sequence NUMBER;
2658: l_rejection_type VARCHAR2(30);
2659: l_char_date VARCHAR2(30);
2660: l_exp_days NUMBER := 7;

Line 2701: FROM fnd_user

2697: FROM dual;
2698:
2699: SELECT nvl(description,user_name)
2700: INTO l_approver_for_msg
2701: FROM fnd_user
2702: WHERE user_id= p_approver_user_id;
2703:
2704: SELECT obj.template_name, fnd.user_name, template_id
2705: INTO l_template_name, l_submitter, l_template_id

Line 2704: SELECT obj.template_name, fnd.user_name, template_id

2700: INTO l_approver_for_msg
2701: FROM fnd_user
2702: WHERE user_id= p_approver_user_id;
2703:
2704: SELECT obj.template_name, fnd.user_name, template_id
2705: INTO l_template_name, l_submitter, l_template_id
2706: FROM zpb_dc_objects obj, fnd_user fnd
2707: WHERE obj.object_id = p_object_id
2708: AND obj.object_user_id = fnd.user_id;

Line 2706: FROM zpb_dc_objects obj, fnd_user fnd

2702: WHERE user_id= p_approver_user_id;
2703:
2704: SELECT obj.template_name, fnd.user_name, template_id
2705: INTO l_template_name, l_submitter, l_template_id
2706: FROM zpb_dc_objects obj, fnd_user fnd
2707: WHERE obj.object_id = p_object_id
2708: AND obj.object_user_id = fnd.user_id;
2709:
2710: -- Populate the From field in notification details page

Line 2708: AND obj.object_user_id = fnd.user_id;

2704: SELECT obj.template_name, fnd.user_name, template_id
2705: INTO l_template_name, l_submitter, l_template_id
2706: FROM zpb_dc_objects obj, fnd_user fnd
2707: WHERE obj.object_id = p_object_id
2708: AND obj.object_user_id = fnd.user_id;
2709:
2710: -- Populate the From field in notification details page
2711: SELECT user_name
2712: INTO l_from_name

Line 2713: FROM fnd_user

2709:
2710: -- Populate the From field in notification details page
2711: SELECT user_name
2712: INTO l_from_name
2713: FROM fnd_user
2714: WHERE user_id= p_approver_user_id;
2715:
2716: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2717: INTO l_sequence

Line 2767: wf_event.AddParameterToList(p_name=>'FND_USER_ID',

2763: -- set fnd values so workflow process can use this values
2764: -- since they can now be run in deferred mode
2765: -- working:fnd_global.apps_initialize(1005258,57124,210);
2766:
2767: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2768: p_value=> fnd_global.user_id,
2769: p_parameterlist=>l_parameter_list);
2770:
2771: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

Line 3000: FROM zpb_dc_objects obj , fnd_user usr

2996:
2997: --check if all the worksheet for this template have been submitted
2998: SELECT count(*)
2999: INTO l_ws_status_count
3000: FROM zpb_dc_objects obj , fnd_user usr
3001: WHERE obj.object_user_id = usr.user_id
3002: AND l_template_id = obj.template_id
3003: AND obj.object_type = 'W'
3004: AND obj.status NOT IN ('SUBMITTED_TO_SHARED')