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_DC_OBJECTS

Line 25: l_template_name zpb_dc_objects.template_name%TYPE;

21: l_respapp_id number := 0;
22: l_user_id number := 0;
23: l_resp_id number := 0;
24:
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;

Line 135: l_template_name zpb_dc_objects.template_name%TYPE;

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
138:
139: IF (funcmode = 'RUN') THEN

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 237: FROM zpb_dc_objects

233: /* Get the template id from objects table
234: instead of task parameters table */
235: SELECT template_id
236: INTO l_template_id
237: FROM zpb_dc_objects
238: WHERE ac_instance_id = l_instance_id
239: AND object_type = 'M'
240: AND generate_template_task_id = l_task_id;
241:

Line 250: FROM zpb_dc_objects

246: avalue => l_template_id);
247:
248: SELECT review_complete_flag
249: INTO l_review_complete_flag
250: FROM zpb_dc_objects
251: WHERE template_id = l_template_id
252: AND object_type = 'M';
253:
254: IF l_review_complete_flag = 'Y' THEN

Line 297: l_template_name zpb_dc_objects.template_name%TYPE;

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;
300:
301: l_respapp_id number := 0;

Line 341: FROM zpb_dc_objects

337: AND name = 'DISTRIBUTION_TEMPLATE_ID';
338:
339: SELECT template_id, template_name
340: INTO l_template_id, l_template_name
341: FROM zpb_dc_objects
342: WHERE ac_instance_id = l_instance_id
343: AND ac_template_id = l_ac_template_id
344: AND object_type = 'M';
345:

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 445: l_template_name zpb_dc_objects.template_name%TYPE;

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);
449: l_commit VARCHAR2(1);

Line 518: FROM zpb_dc_objects

514: AND name = 'DISTRIBUTION_TEMPLATE_ID';
515:
516: SELECT object_user_id
517: INTO l_object_user_id
518: FROM zpb_dc_objects
519: WHERE ac_instance_id = l_instance_id
520: AND ac_template_id = l_ac_template_id
521: AND object_type = 'M';
522: ELSE -- Manual--

Line 525: FROM zpb_dc_objects

521: AND object_type = 'M';
522: ELSE -- Manual--
523: SELECT template_id, template_name
524: INTO l_template_id, l_template_name
525: FROM zpb_dc_objects
526: WHERE object_id = l_object_id;
527:
528: SELECT object_user_id
529: INTO l_object_user_id

Line 530: FROM zpb_dc_objects

526: WHERE object_id = l_object_id;
527:
528: SELECT object_user_id
529: INTO l_object_user_id
530: FROM zpb_dc_objects
531: WHERE template_id = l_template_id
532: AND object_type = 'M';
533:
534: -- Get Message from Fnd_Messages

Line 564: ZPB_DC_OBJECTS_PVT.Set_Ws_Recipient(

560: aname => '#FROM_ROLE',
561: avalue => l_from_name);
562:
563: -- Find out distribution recipients
564: ZPB_DC_OBJECTS_PVT.Set_Ws_Recipient(
565: p_api_version => l_api_version,
566: p_init_msg_list => l_init_msg_list,
567: p_commit => l_commit,
568: p_validation_level => l_validation_level,

Line 638: l_template_name zpb_dc_objects.template_name%TYPE;

634: l_api_version CONSTANT NUMBER := 1.0 ;
635: l_return_status VARCHAR2(1);
636: --
637: l_deadline_date DATE;
638: l_template_name zpb_dc_objects.template_name%TYPE;
639: l_substr_templ_name VARCHAR2(140);
640: l_sequence NUMBER;
641: l_distribute_type VARCHAR2(30);
642: l_char_date VARCHAR2(30);

Line 677: FROM zpb_dc_objects

673: FROM dual;
674:
675: SELECT template_name
676: INTO l_template_name
677: FROM zpb_dc_objects
678: WHERE object_id = p_object_id;
679:
680: l_substr_templ_name := substr(l_template_name,1,140);
681: l_distribute_type := 'Distribute Template';

Line 804: l_approver_type zpb_dc_objects.approver_type%TYPE;

800: IS
801: l_object_id number;
802: l_recipient_type varchar2(30);
803: l_dist_list_id number;
804: l_approver_type zpb_dc_objects.approver_type%TYPE;
805: l_deadline_date_text varchar2(30);
806: l_overwrite_cust varchar2(30);
807: l_overwrite_data varchar2(30);
808: l_req_id number;

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 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 999: zpb_dc_objects obj

995:
996: FOR template_id_rec IN (
997: SELECT obj.template_id
998: FROM zpb_task_parameters param,
999: zpb_dc_objects obj
1000: WHERE param.task_id = l_task_id
1001: AND param.name = 'SUBMISSION_TEMPLATE_ID'
1002: AND to_number(param.value) = obj.ac_template_id
1003: AND obj.status <> 'SUBMITTED_TO_SHARED'

Line 1039: FROM zpb_dc_objects

1035: AND name = 'SUBMISSION_TEMPLATE_ID';
1036:
1037: SELECT object_user_id
1038: INTO l_object_user_id
1039: FROM zpb_dc_objects
1040: WHERE ac_instance_id = l_instance_id
1041: AND ac_template_id = l_ac_template_id
1042: AND object_type = 'M';
1043:

Line 1086: l_distribution_method zpb_dc_objects.distribution_method%TYPE;

1082: l_template_id NUMBER ;
1083: l_ws_count NUMBER ;
1084: l_ws_status_count NUMBER ;
1085: l_loop_visited_counter NUMBER ;
1086: l_distribution_method zpb_dc_objects.distribution_method%TYPE;
1087: l_approval_required_flag zpb_dc_objects.approval_required_flag%TYPE;
1088: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
1089:
1090: BEGIN

Line 1087: l_approval_required_flag zpb_dc_objects.approval_required_flag%TYPE;

1083: l_ws_count NUMBER ;
1084: l_ws_status_count NUMBER ;
1085: l_loop_visited_counter NUMBER ;
1086: l_distribution_method zpb_dc_objects.distribution_method%TYPE;
1087: l_approval_required_flag zpb_dc_objects.approval_required_flag%TYPE;
1088: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
1089:
1090: BEGIN
1091: l_template_id := 0;

Line 1088: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;

1084: l_ws_status_count NUMBER ;
1085: l_loop_visited_counter NUMBER ;
1086: l_distribution_method zpb_dc_objects.distribution_method%TYPE;
1087: l_approval_required_flag zpb_dc_objects.approval_required_flag%TYPE;
1088: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
1089:
1090: BEGIN
1091: l_template_id := 0;
1092: l_ws_count := 0;

Line 1128: FROM zpb_dc_objects

1124: --------------------------------------
1125: -- Check whether distribution happened --
1126: SELECT count(*)
1127: INTO l_ws_count
1128: FROM zpb_dc_objects
1129: WHERE template_id = l_template_id
1130: AND object_type = 'W';
1131: FND_FILE.Put_Line ( FND_FILE.LOG, 'manage_submission - l_ws_count=' || l_ws_count ) ;
1132:

Line 1138: FROM zpb_dc_objects

1134: FOR worksheet_rec IN (
1135: SELECT distribution_method,
1136: approval_required_flag,
1137: multiple_submissions_flag
1138: FROM zpb_dc_objects
1139: WHERE template_id = l_template_id
1140: AND object_type = 'M' )
1141: LOOP
1142: l_distribution_method := worksheet_rec.distribution_method;

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 1223: ZPB_DC_OBJECTS_PVT.Set_Template_Recipient(

1219: Itemtype => ItemType,
1220: Itemkey => ItemKey,
1221: aname => 'DC_TEMPLATE_ID');
1222:
1223: ZPB_DC_OBJECTS_PVT.Set_Template_Recipient(
1224: p_api_version => l_api_version,
1225: p_init_msg_list => l_init_msg_list,
1226: p_commit => l_commit,
1227: p_validation_level => l_validation_level,

Line 1279: UPDATE zpb_dc_objects

1275: Itemtype => ItemType,
1276: Itemkey => ItemKey,
1277: aname => 'DC_TEMPLATE_ID');
1278:
1279: UPDATE zpb_dc_objects
1280: SET status = 'SUBMITTED_TO_SHARED',
1281: freeze_flag = 'Y',
1282: LAST_UPDATED_BY = fnd_global.USER_ID,
1283: LAST_UPDATE_DATE = SYSDATE,

Line 1339: zpb_dc_objects obj

1335:
1336: SELECT count(*)
1337: INTO l_count
1338: FROM zpb_task_parameters param,
1339: zpb_dc_objects obj
1340: WHERE param.task_id = l_task_id
1341: AND param.name = 'SUBMISSION_TEMPLATE_ID'
1342: AND to_number(param.value) = obj.ac_template_id
1343: AND obj.status <> 'SUBMITTED_TO_SHARED'

Line 1392: l_template_name zpb_dc_objects.template_name%TYPE;

1388: l_template_id NUMBER;
1389: l_distributor_id NUMBER;
1390: l_bpo_id NUMBER;
1391: l_approver_id NUMBER;
1392: l_template_name zpb_dc_objects.template_name%TYPE;
1393: l_substr_templ_name VARCHAR2(140);
1394: l_object_type zpb_dc_objects.object_type%TYPE;
1395: l_distribution_method zpb_dc_objects.distribution_method%TYPE;
1396: l_object_user_id NUMBER;

Line 1394: l_object_type zpb_dc_objects.object_type%TYPE;

1390: l_bpo_id NUMBER;
1391: l_approver_id NUMBER;
1392: l_template_name zpb_dc_objects.template_name%TYPE;
1393: l_substr_templ_name VARCHAR2(140);
1394: l_object_type zpb_dc_objects.object_type%TYPE;
1395: l_distribution_method zpb_dc_objects.distribution_method%TYPE;
1396: l_object_user_id NUMBER;
1397: l_char_date VARCHAR2(30);
1398: l_sequence NUMBER;

Line 1395: l_distribution_method zpb_dc_objects.distribution_method%TYPE;

1391: l_approver_id NUMBER;
1392: l_template_name zpb_dc_objects.template_name%TYPE;
1393: l_substr_templ_name VARCHAR2(140);
1394: l_object_type zpb_dc_objects.object_type%TYPE;
1395: l_distribution_method zpb_dc_objects.distribution_method%TYPE;
1396: l_object_user_id NUMBER;
1397: l_char_date VARCHAR2(30);
1398: l_sequence NUMBER;
1399: l_submit_type VARCHAR2(30);

Line 1446: FROM zpb_dc_objects

1442: l_distributor_id,
1443: l_distribution_method,
1444: l_multiple_submissions_flag,
1445: l_approval_required_flag
1446: FROM zpb_dc_objects
1447: WHERE object_id = p_object_id;
1448:
1449: SELECT object_user_id
1450: INTO l_bpo_id

Line 1451: FROM zpb_dc_objects

1447: WHERE object_id = p_object_id;
1448:
1449: SELECT object_user_id
1450: INTO l_bpo_id
1451: FROM zpb_dc_objects
1452: WHERE template_id = l_template_id
1453: AND object_type = 'M';
1454:
1455: -- Set the approver user id

Line 1468: UPDATE zpb_dc_objects

1464: END IF;
1465:
1466: -- Set the status to SUBMITTTED to prevent updating
1467: IF (l_object_type = 'E') THEN
1468: UPDATE zpb_dc_objects
1469: SET status = 'SUBMITTED',
1470: submission_date = sysdate,
1471: submitted_by = l_object_user_id,
1472: LAST_UPDATED_BY = fnd_global.USER_ID,

Line 1481: UPDATE zpb_dc_objects

1477: ELSE
1478: IF(l_distribution_method = 'DIRECT_DISTRIBUTION' AND l_multiple_submissions_flag = 'Y'
1479: AND l_approval_required_flag <> 'Y')
1480: THEN
1481: UPDATE zpb_dc_objects
1482: SET status = 'SUBMITTED',
1483: submission_date = sysdate,
1484: submitted_by = l_object_user_id,
1485: approver_user_id = l_approver_id,

Line 1493: UPDATE zpb_dc_objects

1489: LAST_UPDATE_DATE = SYSDATE,
1490: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1491: WHERE object_id = p_object_id;
1492: ELSE
1493: UPDATE zpb_dc_objects
1494: SET status = 'SUBMITTED',
1495: freeze_flag = 'Y',
1496: submission_date = sysdate,
1497: submitted_by = l_object_user_id,

Line 1622: l_distribution_method zpb_dc_objects.distribution_method%TYPE;

1618: )
1619: IS
1620: l_object_type VARCHAR2(10);
1621: l_object_id NUMBER;
1622: l_distribution_method zpb_dc_objects.distribution_method%TYPE;
1623: l_approval_required VARCHAR2(1);
1624: BEGIN
1625:
1626: IF (funcmode = 'RUN') THEN

Line 1640: FROM zpb_dc_objects

1636: aname => 'DC_OBJECT_ID');
1637:
1638: SELECT distribution_method, approval_required_flag
1639: INTO l_distribution_method, l_approval_required
1640: FROM zpb_dc_objects
1641: WHERE object_id = l_object_id;
1642:
1643: IF (l_object_type = 'E') THEN -- submit template --
1644: IF (l_distribution_method = 'DIRECT_DISTRIBUTION' AND

Line 1724: FROM zpb_dc_objects

1720: aname => 'DC_OBJECT_ID');
1721: -- Get the template name
1722: SELECT template_name
1723: INTO l_template_name
1724: FROM zpb_dc_objects
1725: WHERE template_id = l_template_id
1726: AND object_type = 'M';
1727:
1728:

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 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 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 1774: UPDATE zpb_dc_objects

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
1775: SET status = 'SUBMITTED_TO_SHARED',
1776: submission_date = sysdate,
1777: submitted_by = l_object_user_id
1778: WHERE template_id = l_template_id

Line 1783: UPDATE zpb_dc_objects

1779: AND object_type in ('M','E','C');
1780:
1781: /* Set the status to Frozen if status DISTRIBUTION_PENDING,
1782: DISTRIBUTED, REJECTED */
1783: UPDATE zpb_dc_objects
1784: SET status = 'FROZEN'
1785: WHERE template_id = l_template_id
1786: AND OBJECT_TYPE = 'W'
1787: AND status not in ('SUBMITTED','FROZEN','APPROVED','SUBMITTED_TO_SHARED');

Line 1790: UPDATE zpb_dc_objects

1786: AND OBJECT_TYPE = 'W'
1787: AND status not in ('SUBMITTED','FROZEN','APPROVED','SUBMITTED_TO_SHARED');
1788:
1789: -- Set the freeze/app mea flag all records
1790: UPDATE zpb_dc_objects
1791: SET freeze_flag = 'Y',
1792: LAST_UPDATED_BY = fnd_global.USER_ID,
1793: LAST_UPDATE_DATE = SYSDATE,
1794: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1866: l_distribution_method zpb_dc_objects.distribution_method%TYPE;

1862: )
1863: IS
1864: l_object_id NUMBER;
1865: l_template_id NUMBER;
1866: l_distribution_method zpb_dc_objects.distribution_method%TYPE;
1867:
1868: l_api_version NUMBER;
1869: l_init_msg_list VARCHAR2(1);
1870: l_commit VARCHAR2(1);

Line 1886: FROM zpb_dc_objects

1882: CURSOR worksheet_csr IS
1883: SELECT object_user_id
1884: FROM
1885: (SELECT distributor_user_id, object_user_id
1886: FROM zpb_dc_objects
1887: WHERE template_id = l_template_id
1888: AND object_type = 'W'
1889: )
1890: START with distributor_user_id = l_object_user_id

Line 1920: FROM zpb_dc_objects

1916: object_user_id
1917: INTO l_distribution_method,
1918: l_distributor_id,
1919: l_object_user_id
1920: FROM zpb_dc_objects
1921: WHERE object_id = l_object_id;
1922:
1923: IF (l_distribution_method = 'CASCADE_DISTRIBUTION') THEN
1924:

Line 1931: UPDATE zpb_dc_objects

1927: FETCH worksheet_csr INTO l_freeze_user_id;
1928: EXIT WHEN worksheet_csr%NOTFOUND;
1929:
1930: IF (l_freeze_user_id <> l_object_user_id) THEN
1931: UPDATE zpb_dc_objects
1932: SET status = 'FROZEN',
1933: freeze_flag = 'Y',
1934: LAST_UPDATED_BY = fnd_global.USER_ID,
1935: LAST_UPDATE_DATE = SYSDATE,

Line 1976: l_approver_type zpb_dc_objects.approver_type%TYPE;

1972: funcmode IN varchar2,
1973: resultout OUT nocopy varchar2
1974: )
1975: IS
1976: l_approver_type zpb_dc_objects.approver_type%TYPE;
1977: l_object_id number;
1978: BEGIN
1979:
1980: IF (funcmode = 'RUN') THEN

Line 1988: FROM zpb_dc_objects

1984: aname => 'DC_OBJECT_ID');
1985:
1986: SELECT approver_type
1987: INTO l_approver_type
1988: FROM zpb_dc_objects
1989: WHERE object_id = l_object_id;
1990:
1991: wf_engine.SetItemAttrText(
1992: Itemtype => ItemType,

Line 2028: l_approver_type zpb_dc_objects.approver_type%TYPE;

2024: funcmode IN varchar2,
2025: resultout OUT nocopy varchar2
2026: )
2027: IS
2028: l_approver_type zpb_dc_objects.approver_type%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;

Line 2029: l_dist_method zpb_dc_objects.distribution_method%TYPE;

2025: resultout OUT nocopy varchar2
2026: )
2027: IS
2028: l_approver_type zpb_dc_objects.approver_type%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;

Line 2030: l_template_name zpb_dc_objects.template_name%TYPE;

2026: )
2027: IS
2028: l_approver_type zpb_dc_objects.approver_type%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;

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 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 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 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 2097: FROM zpb_dc_objects

2093: aname => 'DC_APPROVER_TYPE');
2094:
2095: SELECT template_name
2096: INTO l_template_name
2097: FROM zpb_dc_objects
2098: WHERE object_id = l_object_id;
2099:
2100: wf_engine.SetItemAttrText(
2101: Itemtype => ItemType,

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 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 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 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 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 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 2270: l_template_name zpb_dc_objects.template_name%TYPE;

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 ;
2274: l_respapp_id NUMBER ;

Line 2311: FROM zpb_dc_objects

2307: aname => 'FND_APPLICATION_ID');
2308:
2309: SELECT object_user_id, template_name
2310: INTO l_object_user_id, l_template_name
2311: FROM zpb_dc_objects
2312: WHERE object_id = l_object_id;
2313:
2314: -- set EPBPerformer to owner name for issue notifications
2315: wf_engine.SetItemAttrText(

Line 2446: l_template_name zpb_dc_objects.template_name%TYPE;

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;
2450: l_sequence NUMBER;

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 2579: ZPB_DC_OBJECTS_PVT.Populate_Approvers(

2575: l_parameter_list.delete;
2576:
2577: COMMIT;
2578:
2579: ZPB_DC_OBJECTS_PVT.Populate_Approvers(
2580: p_api_version => l_api_version,
2581: p_init_msg_list => l_init_msg_list,
2582: p_commit => l_commit,
2583: p_validation_level => l_validation_level,

Line 2653: l_template_name zpb_dc_objects.template_name%TYPE;

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;
2657: l_sequence NUMBER;

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 2790: ZPB_DC_OBJECTS_PVT.Populate_Approvers(

2786: l_parameter_list.delete;
2787:
2788: COMMIT;
2789:
2790: ZPB_DC_OBJECTS_PVT.Populate_Approvers(
2791: p_api_version => l_api_version,
2792: p_init_msg_list => l_init_msg_list,
2793: p_commit => l_commit,
2794: p_validation_level => l_validation_level,

Line 2863: FROM zpb_dc_objects

2859: --If multiple submission are allowed - only update status
2860: --else update status and freeze flag
2861: SELECT multiple_submissions_flag
2862: INTO l_multiple_submissions_flag
2863: FROM zpb_dc_objects
2864: WHERE object_id = l_object_id;
2865:
2866: IF(l_multiple_submissions_flag <>'Y')
2867: THEN

Line 2868: UPDATE zpb_dc_objects

2864: WHERE object_id = l_object_id;
2865:
2866: IF(l_multiple_submissions_flag <>'Y')
2867: THEN
2868: UPDATE zpb_dc_objects
2869: SET status = 'SUBMITTED_TO_SHARED',
2870: freeze_flag = 'Y',
2871: LAST_UPDATED_BY = fnd_global.USER_ID,
2872: LAST_UPDATE_DATE = SYSDATE,

Line 2876: UPDATE zpb_dc_objects

2872: LAST_UPDATE_DATE = SYSDATE,
2873: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2874: WHERE object_id = l_object_id;
2875: ELSE
2876: UPDATE zpb_dc_objects
2877: SET status = 'SUBMITTED_TO_SHARED',
2878: LAST_UPDATED_BY = fnd_global.USER_ID,
2879: LAST_UPDATE_DATE = SYSDATE,
2880: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 2935: FROM zpb_dc_objects obj,zpb_analysis_cycle_tasks task,zpb_task_parameters param

2931: -- Find the item key manage submission task that is managing the submissions
2932: -- of this template
2933: SELECT task.item_key
2934: INTO l_item_key
2935: FROM zpb_dc_objects obj,zpb_analysis_cycle_tasks task,zpb_task_parameters param
2936: WHERE obj.object_id = l_object_id
2937: AND task.analysis_cycle_id = obj.ac_instance_id
2938: AND task.task_id = param.task_id
2939: AND param.name = 'SUBMISSION_TEMPLATE_ID'

Line 2994: FROM zpb_dc_objects

2990: aname => 'DC_OBJECT_ID');
2991: -- get the template_id
2992: SELECT template_id
2993: INTO l_template_id
2994: FROM zpb_dc_objects
2995: WHERE object_id = l_object_id;
2996:
2997: --check if all the worksheet for this template have been submitted
2998: SELECT count(*)

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')

Line 3010: FROM zpb_dc_objects

3006:
3007: --Find if multiple submissions are allowed
3008: SELECT multiple_submissions_flag
3009: INTO l_multiple_submissions_flag
3010: FROM zpb_dc_objects
3011: WHERE object_id = l_object_id;
3012:
3013: --if all the worksheet are not submitted to shared or multiple submission are allowed
3014: -- take the No transition.