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

Line 357: -- Standard Start of API savepoint

353: SELECT 1
354: FROM cn_calc_sql_exps
355: WHERE NAME = p_name AND org_id = p_org_id;
356: BEGIN
357: -- Standard Start of API savepoint
358: SAVEPOINT create_expression;
359:
360: -- Standard call to check for call compatibility.
361: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

356: BEGIN
357: -- Standard Start of API savepoint
358: SAVEPOINT create_expression;
359:
360: -- Standard call to check for call compatibility.
361: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
362: RAISE fnd_api.g_exc_unexpected_error;
363: END IF;
364:

Line 523: -- Standard check of p_commit.

519: END LOOP;
520:
521: -- End of API body.
522:
523: -- Standard check of p_commit.
524: IF fnd_api.to_boolean(p_commit) THEN
525: COMMIT WORK;
526: END IF;
527:

Line 528: -- Standard call to get message count and if count is 1, get message info.

524: IF fnd_api.to_boolean(p_commit) THEN
525: COMMIT WORK;
526: END IF;
527:
528: -- Standard call to get message count and if count is 1, get message info.
529: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
530: , p_encoded => fnd_api.g_false);
531: EXCEPTION
532: WHEN fnd_api.g_exc_error THEN

Line 665: -- Standard Start of API savepoint

661: SELECT 1
662: FROM cn_calc_sql_exps
663: WHERE NAME = p_name AND org_id = p_org_id AND calc_sql_exp_id <> p_calc_sql_exp_id;
664: BEGIN
665: -- Standard Start of API savepoint
666: SAVEPOINT update_expression;
667:
668: -- Standard call to check for call compatibility.
669: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

664: BEGIN
665: -- Standard Start of API savepoint
666: SAVEPOINT update_expression;
667:
668: -- Standard call to check for call compatibility.
669: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
670: RAISE fnd_api.g_exc_unexpected_error;
671: END IF;
672:

Line 876: -- Standard check of p_commit.

872: END IF;
873:
874: -- End of API body.
875:
876: -- Standard check of p_commit.
877: IF fnd_api.to_boolean(p_commit) THEN
878: COMMIT WORK;
879: END IF;
880:

Line 881: -- Standard call to get message count and if count is 1, get message info.

877: IF fnd_api.to_boolean(p_commit) THEN
878: COMMIT WORK;
879: END IF;
880:
881: -- Standard call to get message count and if count is 1, get message info.
882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
883: , p_encoded => fnd_api.g_false);
884: EXCEPTION
885: WHEN fnd_api.g_exc_error THEN

Line 968: -- Standard Start of API savepoint

964: OR (EXISTS(SELECT 1
965: FROM cn_rate_dim_tiers
966: WHERE min_exp_id = p_calc_sql_exp_id OR max_exp_id = p_calc_sql_exp_id));
967: BEGIN
968: -- Standard Start of API savepoint
969: SAVEPOINT delete_expression;
970:
971: -- Standard call to check for call compatibility.
972: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

967: BEGIN
968: -- Standard Start of API savepoint
969: SAVEPOINT delete_expression;
970:
971: -- Standard call to check for call compatibility.
972: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
973: RAISE fnd_api.g_exc_unexpected_error;
974: END IF;
975:

Line 1007: -- Standard check of p_commit.

1003: WHERE calc_sql_exp_id = e.parent_id);
1004:
1005: -- End of API body.
1006:
1007: -- Standard check of p_commit.
1008: IF fnd_api.to_boolean(p_commit) THEN
1009: COMMIT WORK;
1010: END IF;
1011:

Line 1012: -- Standard call to get message count and if count is 1, get message info.

1008: IF fnd_api.to_boolean(p_commit) THEN
1009: COMMIT WORK;
1010: END IF;
1011:
1012: -- Standard call to get message count and if count is 1, get message info.
1013: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1014: , p_encoded => fnd_api.g_false);
1015: EXCEPTION
1016: WHEN fnd_api.g_exc_error THEN

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

1102: WHERE calc_sql_exp_id = p_calc_sql_exp_id
1103: OR f_calc_sql_exp_id = p_calc_sql_exp_id));
1104:
1105: BEGIN
1106: -- Standard call to check for call compatibility.
1107: IF NOT FND_API.Compatible_API_Call
1108: (l_api_version ,
1109: p_api_version ,
1110: l_api_name ,

Line 1130: -- Standard check of p_commit.

1126: END LOOP;
1127:
1128: -- End of API body.
1129:
1130: -- Standard check of p_commit.
1131: IF FND_API.To_Boolean( p_commit ) THEN
1132: COMMIT WORK;
1133: END IF;
1134: -- Standard call to get message count and if count is 1, get message info.

Line 1134: -- Standard call to get message count and if count is 1, get message info.

1130: -- Standard check of p_commit.
1131: IF FND_API.To_Boolean( p_commit ) THEN
1132: COMMIT WORK;
1133: END IF;
1134: -- Standard call to get message count and if count is 1, get message info.
1135: FND_MSG_PUB.count_and_get
1136: (p_count => x_msg_count ,
1137: p_data => x_msg_data ,
1138: p_encoded => FND_API.G_FALSE );

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

1602: ) IS
1603: l_api_name CONSTANT VARCHAR2(30) := 'get_dependent_plan_elts';
1604: l_api_version CONSTANT NUMBER := 1.0;
1605: BEGIN
1606: -- Standard call to check for call compatibility.
1607: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1608: RAISE fnd_api.g_exc_unexpected_error;
1609: END IF;
1610:

Line 1621: -- Standard check of p_commit.

1617: x_return_status := fnd_api.g_ret_sts_success;
1618: -- API body
1619: dfs(p_node_type, p_node_id, p_node_type, p_node_id, 0, x_plan_elt_id_tbl);
1620:
1621: -- Standard check of p_commit.
1622: IF fnd_api.to_boolean(p_commit) THEN
1623: COMMIT WORK;
1624: END IF;
1625:

Line 1626: -- Standard call to get message count and if count is 1, get message info.

1622: IF fnd_api.to_boolean(p_commit) THEN
1623: COMMIT WORK;
1624: END IF;
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1627: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1628: , p_encoded => fnd_api.g_false);
1629: EXCEPTION
1630: WHEN fnd_api.g_exc_error THEN

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

1754: ) IS
1755: l_api_name CONSTANT VARCHAR2(30) := 'get_parent_plan_elts';
1756: l_api_version CONSTANT NUMBER := 1.0;
1757: BEGIN
1758: -- Standard call to check for call compatibility.
1759: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1760: RAISE fnd_api.g_exc_unexpected_error;
1761: END IF;
1762:

Line 1773: -- Standard check of p_commit.

1769: x_return_status := fnd_api.g_ret_sts_success;
1770: -- API body
1771: dfs2(p_node_type, p_node_id, p_node_type, p_node_id, 0, x_plan_elt_id_tbl);
1772:
1773: -- Standard check of p_commit.
1774: IF fnd_api.to_boolean(p_commit) THEN
1775: COMMIT WORK;
1776: END IF;
1777:

Line 1778: -- Standard call to get message count and if count is 1, get message info.

1774: IF fnd_api.to_boolean(p_commit) THEN
1775: COMMIT WORK;
1776: END IF;
1777:
1778: -- Standard call to get message count and if count is 1, get message info.
1779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1780: , p_encoded => fnd_api.g_false);
1781: EXCEPTION
1782: WHEN fnd_api.g_exc_error THEN

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

1904: SELECT object_name
1905: FROM user_objects
1906: WHERE object_type = 'FUNCTION' AND status = 'VALID';
1907: BEGIN
1908: -- Standard call to check for call compatibility.
1909: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1910: RAISE fnd_api.g_exc_unexpected_error;
1911: END IF;
1912:

Line 2113: -- Standard check of p_commit.

2109:
2110: x_sql_from := REPLACE(SUBSTR(x_piped_sql_from, 1, LENGTH(x_piped_sql_from) - 1), '|'
2111: , ', '); -- trim last comma
2112:
2113: -- Standard check of p_commit.
2114: IF fnd_api.to_boolean(p_commit) THEN
2115: COMMIT WORK;
2116: END IF;
2117:

Line 2118: -- Standard call to get message count and if count is 1, get message info.

2114: IF fnd_api.to_boolean(p_commit) THEN
2115: COMMIT WORK;
2116: END IF;
2117:
2118: -- Standard call to get message count and if count is 1, get message info.
2119: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2120: , p_encoded => fnd_api.g_false);
2121: EXCEPTION
2122: WHEN fnd_api.g_exc_error THEN

Line 2755: -- Standard Start of API savepoint

2751: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2752: l_suffix VARCHAR2(10) := NULL;
2753: l_prefix VARCHAR2(10) := NULL;
2754: BEGIN
2755: -- Standard Start of API savepoint
2756: SAVEPOINT create_expression;
2757:
2758: -- Standard call to check for call compatibility.
2759: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

2754: BEGIN
2755: -- Standard Start of API savepoint
2756: SAVEPOINT create_expression;
2757:
2758: -- Standard call to check for call compatibility.
2759: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2760: RAISE fnd_api.g_exc_unexpected_error;
2761: END IF;
2762:

Line 2832: -- Standard check of p_commit.

2828: , x_msg_data => x_msg_data
2829: , x_object_version_number => x_object_version_number
2830: );
2831:
2832: -- Standard check of p_commit.
2833: IF fnd_api.to_boolean(p_commit) THEN
2834: COMMIT WORK;
2835: END IF;
2836:

Line 2837: -- Standard call to get message count and if count is 1, get message info.

2833: IF fnd_api.to_boolean(p_commit) THEN
2834: COMMIT WORK;
2835: END IF;
2836:
2837: -- Standard call to get message count and if count is 1, get message info.
2838: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2839: , p_encoded => fnd_api.g_false);
2840: EXCEPTION
2841: WHEN fnd_api.g_exc_error THEN