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.IBC_CITEM_WORKFLOW_PVT dependencies on STANDARD

Line 263: --

259: -- APPROVED or REJECTED)
260: -- p_callback_url_description => Description to appear in notification
261: -- p_language => Content Item's Language
262: -- x_wf_item_key => WF item key
263: --
264: -- --------------------------------------------------------------------
265: PROCEDURE Submit_For_Approval(
266: p_citem_ver_id IN NUMBER
267: ,p_notes_to_approver IN VARCHAR2

Line 282: -- local variable for standards **

278: ,x_msg_count OUT NOCOPY NUMBER
279: ,x_msg_data OUT NOCOPY VARCHAR2
280: ) IS
281:
282: --******** local variable for standards **********
283: l_api_name CONSTANT VARCHAR2(30) := 'Submit_For_Approval';
284: l_api_version CONSTANT NUMBER := 1.0;
285: l_dummy VARCHAR2(2);
286:

Line 376: -- * Standard Begins **

372: AND c.content_item_status <> p_status;
373:
374: BEGIN
375:
376: -- ******* Standard Begins ********
377:
378: -- Standard call to check for call compatibility.
379: IF NOT FND_API.Compatible_API_Call (
380: l_api_version,

Line 378: -- Standard call to check for call compatibility.

374: BEGIN
375:
376: -- ******* Standard Begins ********
377:
378: -- Standard call to check for call compatibility.
379: IF NOT FND_API.Compatible_API_Call (
380: l_api_version,
381: p_api_version,
382: l_api_name,

Line 729: -- Standard call to get message count and if count=1, get the message

725: IF (p_commit = FND_API.g_true) THEN
726: COMMIT;
727: END IF;
728:
729: -- Standard call to get message count and if count=1, get the message
730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
731: p_data => x_msg_data);
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN

Line 792: -- (Standard WF API)

788: -- If it's approved succesfully then 'COMPLETE:Y' will be
789: -- returned and callback URL updated, otherwise
790: -- 'COMPLETE:N' will be returned along with error
791: -- stack assigned to 'ERROR_MESSAGE_STACK' WF Attribute.
792: -- (Standard WF API)
793: -- --------------------------------------------------------------------
794: PROCEDURE Approve_Citem_Version(itemtype IN VARCHAR2,
795: itemkey IN VARCHAR2,
796: actid IN NUMBER,

Line 904: -- (Standard WF API)

900: -- DESCRIPTION: Procedure to be called from WF to process the response
901: -- for approval notification request.
902: -- It focuses more on REJECTED response to set callback
903: -- URL
904: -- (Standard WF API)
905: -- --------------------------------------------------------------------
906: PROCEDURE Process_Approval_Response(itemtype IN VARCHAR2,
907: itemkey IN VARCHAR2,
908: actid IN NUMBER,

Line 1260: --

1256: -- p_item_key => WF item key
1257: -- p_activity => WF Activity
1258: -- p_response => Response to Notification (either Y or N)
1259: -- p_notes_to_submitter => Notes/Comments to Submitter.
1260: --
1261: -- --------------------------------------------------------------------
1262: PROCEDURE Respond_Approval_Notification(
1263: p_item_type IN VARCHAR2
1264: ,p_item_key IN VARCHAR2

Line 1275: -- local variable for standards **

1271: ,x_return_status OUT NOCOPY VARCHAR2
1272: ,x_msg_count OUT NOCOPY NUMBER
1273: ,x_msg_data OUT NOCOPY VARCHAR2
1274: ) IS
1275: --******** local variable for standards **********
1276: l_api_name CONSTANT VARCHAR2(30) := 'Respond_Approval_Notification';
1277: l_api_version CONSTANT NUMBER := 1.0;
1278: l_dummy VARCHAR2(2);
1279: CURSOR c_chk_notification IS

Line 1284: -- * Standard Begins **

1280: SELECT 'X'
1281: FROM ibc_pending_approvals_v
1282: WHERE item_key = p_item_key;
1283: BEGIN
1284: -- ******* Standard Begins ********
1285:
1286: -- Standard call to check for call compatibility.
1287: IF NOT FND_API.Compatible_API_Call (
1288: l_api_version,

Line 1286: -- Standard call to check for call compatibility.

1282: WHERE item_key = p_item_key;
1283: BEGIN
1284: -- ******* Standard Begins ********
1285:
1286: -- Standard call to check for call compatibility.
1287: IF NOT FND_API.Compatible_API_Call (
1288: l_api_version,
1289: p_api_version,
1290: l_api_name,

Line 1348: -- Standard call to get message count and if count=1, get the message

1344: IF (p_commit = FND_API.g_true) THEN
1345: COMMIT;
1346: END IF;
1347:
1348: -- Standard call to get message count and if count=1, get the message
1349: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1350: p_data => x_msg_data);
1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN

Line 1409: --

1405: -- DESCRIPTION: Closes Translation Request from inbox
1406: -- PARAMETERS:
1407: -- p_item_type => WF item type
1408: -- p_item_key => WF item key
1409: --
1410: -- --------------------------------------------------------------------
1411: PROCEDURE Close_Translation_Request(
1412: p_item_type IN VARCHAR2
1413: ,p_item_key IN VARCHAR2

Line 1421: -- local variable for standards **

1417: ,x_return_status OUT NOCOPY VARCHAR2
1418: ,x_msg_count OUT NOCOPY NUMBER
1419: ,x_msg_data OUT NOCOPY VARCHAR2
1420: ) IS
1421: --******** local variable for standards **********
1422: l_api_name CONSTANT VARCHAR2(30) := 'Close_Translation_Request';
1423: l_api_version CONSTANT NUMBER := 1.0;
1424: BEGIN
1425: -- ******* Standard Begins ********

Line 1425: -- * Standard Begins **

1421: --******** local variable for standards **********
1422: l_api_name CONSTANT VARCHAR2(30) := 'Close_Translation_Request';
1423: l_api_version CONSTANT NUMBER := 1.0;
1424: BEGIN
1425: -- ******* Standard Begins ********
1426:
1427: -- Standard call to check for call compatibility.
1428: IF NOT FND_API.Compatible_API_Call (
1429: l_api_version,

Line 1427: -- Standard call to check for call compatibility.

1423: l_api_version CONSTANT NUMBER := 1.0;
1424: BEGIN
1425: -- ******* Standard Begins ********
1426:
1427: -- Standard call to check for call compatibility.
1428: IF NOT FND_API.Compatible_API_Call (
1429: l_api_version,
1430: p_api_version,
1431: l_api_name,

Line 1456: -- Standard call to get message count and if count=1, get the message

1452: IF (p_commit = FND_API.g_true) THEN
1453: COMMIT;
1454: END IF;
1455:
1456: -- Standard call to get message count and if count=1, get the message
1457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1458: p_data => x_msg_data);
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN

Line 1522: --

1518: -- - x_wf_item_keys Table of Workflow Item Keys, these
1519: -- values can be used to respond (Approve
1520: -- or Reject) notifications calling
1521: -- Respond_Approval_Notification
1522: --
1523: -- --------------------------------------------------------------------
1524: PROCEDURE Get_Pending_Approvals(
1525: x_citem_version_ids OUT NOCOPY jtf_number_table
1526: ,x_wf_item_keys OUT NOCOPY jtf_varchar2_table_100

Line 1544: -- local variable for standards **

1540: SELECT *
1541: FROM IBC_PENDING_APPROVALS_V
1542: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
1543:
1544: --******** local variable for standards **********
1545: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Approvals';
1546: l_api_version CONSTANT NUMBER := 1.0;
1547:
1548: TYPE t_citem_version_id_tbl IS TABLE OF NUMBER

Line 1556: -- * Standard Begins **

1552: l_citem_version_id_tbl t_citem_version_id_tbl;
1553: l_wf_item_key_tbl t_wf_item_key_tbl;
1554:
1555: BEGIN
1556: -- ******* Standard Begins ********
1557:
1558: -- Standard call to check for call compatibility.
1559: IF NOT FND_API.Compatible_API_Call (
1560: l_api_version,

Line 1558: -- Standard call to check for call compatibility.

1554:
1555: BEGIN
1556: -- ******* Standard Begins ********
1557:
1558: -- Standard call to check for call compatibility.
1559: IF NOT FND_API.Compatible_API_Call (
1560: l_api_version,
1561: p_api_version,
1562: l_api_name,

Line 1594: -- Standard call to get message count and if count=1, get the message

1590: x_wf_item_keys(I) := l_wf_item_key_tbl(I);
1591: END LOOP;
1592: END IF;
1593:
1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN

Line 1658: --

1654: -- - x_citem_version_ids Table of content item version ids
1655: -- - x_wf_item_keys Table of Workflow Item Keys, these
1656: -- values can be used to close notifications
1657: -- calling close_fyi_notification
1658: --
1659: -- --------------------------------------------------------------------
1660: PROCEDURE Get_Pending_Translations(
1661: x_citem_version_ids OUT NOCOPY jtf_number_table
1662: ,x_wf_item_keys OUT NOCOPY jtf_varchar2_table_100

Line 1680: -- local variable for standards **

1676: SELECT *
1677: FROM IBC_PENDING_TRANSLATIONS_V
1678: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
1679:
1680: --******** local variable for standards **********
1681: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Translations';
1682: l_api_version CONSTANT NUMBER := 1.0;
1683:
1684: TYPE t_citem_version_id_tbl IS TABLE OF NUMBER

Line 1692: -- * Standard Begins **

1688: l_citem_version_id_tbl t_citem_version_id_tbl;
1689: l_wf_item_key_tbl t_wf_item_key_tbl;
1690:
1691: BEGIN
1692: -- ******* Standard Begins ********
1693:
1694: -- Standard call to check for call compatibility.
1695: IF NOT FND_API.Compatible_API_Call (
1696: l_api_version,

Line 1694: -- Standard call to check for call compatibility.

1690:
1691: BEGIN
1692: -- ******* Standard Begins ********
1693:
1694: -- Standard call to check for call compatibility.
1695: IF NOT FND_API.Compatible_API_Call (
1696: l_api_version,
1697: p_api_version,
1698: l_api_name,

Line 1730: -- Standard call to get message count and if count=1, get the message

1726: x_wf_item_keys(I) := l_wf_item_key_tbl(I);
1727: END LOOP;
1728: END IF;
1729:
1730: -- Standard call to get message count and if count=1, get the message
1731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1732: p_data => x_msg_data);
1733: EXCEPTION
1734: WHEN FND_API.G_EXC_ERROR THEN

Line 1806: --

1802: -- APPROVED or REJECTED)
1803: -- p_callback_url_description => Description to appear in notification
1804: -- p_language => Content Item's Language
1805: -- x_wf_item_key => WF item key
1806: --
1807: -- --------------------------------------------------------------------
1808: PROCEDURE Submit_For_Trans_Approval(
1809: p_citem_ver_id IN NUMBER
1810: ,p_notes_to_approver IN VARCHAR2

Line 1825: -- local variable for standards **

1821: ,x_msg_count OUT NOCOPY NUMBER
1822: ,x_msg_data OUT NOCOPY VARCHAR2
1823: ) IS
1824:
1825: --******** local variable for standards **********
1826: l_api_name CONSTANT VARCHAR2(30) := 'Submit_For_Trans_Approval';
1827: l_api_version CONSTANT NUMBER := 1.0;
1828: l_dummy VARCHAR2(2);
1829:

Line 1923: -- * Standard Begins **

1919: l_language_description VARCHAR2(255);
1920:
1921: BEGIN
1922:
1923: -- ******* Standard Begins ********
1924:
1925: -- Standard call to check for call compatibility.
1926: IF NOT FND_API.Compatible_API_Call (
1927: l_api_version,

Line 1925: -- Standard call to check for call compatibility.

1921: BEGIN
1922:
1923: -- ******* Standard Begins ********
1924:
1925: -- Standard call to check for call compatibility.
1926: IF NOT FND_API.Compatible_API_Call (
1927: l_api_version,
1928: p_api_version,
1929: l_api_name,

Line 2306: -- Standard call to get message count and if count=1, get the message

2302: IF (p_commit = FND_API.g_true) THEN
2303: COMMIT;
2304: END IF;
2305:
2306: -- Standard call to get message count and if count=1, get the message
2307: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2308: p_data => x_msg_data);
2309: EXCEPTION
2310: WHEN FND_API.G_EXC_ERROR THEN

Line 2371: -- (Standard WF API)

2367: -- DESCRIPTION: Procedure to be called from WF to process the response
2368: -- for translation approval(TA) notification request.
2369: -- It focuses more on REJECTED response to set callback
2370: -- URL
2371: -- (Standard WF API)
2372: -- --------------------------------------------------------------------
2373: PROCEDURE Process_TA_Response(itemtype IN VARCHAR2
2374: ,itemkey IN VARCHAR2
2375: ,actid IN NUMBER

Line 2513: -- (Standard WF API)

2509: -- If it's approved succesfully then 'COMPLETE:Y' will be
2510: -- returned and callback URL updated, otherwise
2511: -- 'COMPLETE:N' will be returned along with error
2512: -- stack assigned to 'ERROR_MESSAGE_STACK' WF Attribute.
2513: -- (Standard WF API)
2514: -- --------------------------------------------------------------------
2515: PROCEDURE Approve_Translation(itemtype IN VARCHAR2
2516: ,itemkey IN VARCHAR2
2517: ,actid IN NUMBER