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 351: -- Standard Start of API savepoint

347: SELECT 1
348: FROM cn_calc_sql_exps
349: WHERE NAME = p_name AND org_id = p_org_id;
350: BEGIN
351: -- Standard Start of API savepoint
352: SAVEPOINT create_expression;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

350: BEGIN
351: -- Standard Start of API savepoint
352: SAVEPOINT create_expression;
353:
354: -- Standard call to check for call compatibility.
355: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
356: RAISE fnd_api.g_exc_unexpected_error;
357: END IF;
358:

Line 516: -- Standard check of p_commit.

512: END LOOP;
513:
514: -- End of API body.
515:
516: -- Standard check of p_commit.
517: IF fnd_api.to_boolean(p_commit) THEN
518: COMMIT WORK;
519: END IF;
520:

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

517: IF fnd_api.to_boolean(p_commit) THEN
518: COMMIT WORK;
519: END IF;
520:
521: -- Standard call to get message count and if count is 1, get message info.
522: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
523: , p_encoded => fnd_api.g_false);
524: EXCEPTION
525: WHEN fnd_api.g_exc_error THEN

Line 658: -- Standard Start of API savepoint

654: SELECT 1
655: FROM cn_calc_sql_exps
656: WHERE NAME = p_name AND org_id = p_org_id AND calc_sql_exp_id <> p_calc_sql_exp_id;
657: BEGIN
658: -- Standard Start of API savepoint
659: SAVEPOINT update_expression;
660:
661: -- Standard call to check for call compatibility.
662: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

657: BEGIN
658: -- Standard Start of API savepoint
659: SAVEPOINT update_expression;
660:
661: -- Standard call to check for call compatibility.
662: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
663: RAISE fnd_api.g_exc_unexpected_error;
664: END IF;
665:

Line 868: -- Standard check of p_commit.

864: END IF;
865:
866: -- End of API body.
867:
868: -- Standard check of p_commit.
869: IF fnd_api.to_boolean(p_commit) THEN
870: COMMIT WORK;
871: END IF;
872:

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

869: IF fnd_api.to_boolean(p_commit) THEN
870: COMMIT WORK;
871: END IF;
872:
873: -- Standard call to get message count and if count is 1, get message info.
874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
875: , p_encoded => fnd_api.g_false);
876: EXCEPTION
877: WHEN fnd_api.g_exc_error THEN

Line 960: -- Standard Start of API savepoint

956: OR (EXISTS(SELECT 1
957: FROM cn_rate_dim_tiers
958: WHERE min_exp_id = p_calc_sql_exp_id OR max_exp_id = p_calc_sql_exp_id));
959: BEGIN
960: -- Standard Start of API savepoint
961: SAVEPOINT delete_expression;
962:
963: -- Standard call to check for call compatibility.
964: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

959: BEGIN
960: -- Standard Start of API savepoint
961: SAVEPOINT delete_expression;
962:
963: -- Standard call to check for call compatibility.
964: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
965: RAISE fnd_api.g_exc_unexpected_error;
966: END IF;
967:

Line 999: -- Standard check of p_commit.

995: WHERE calc_sql_exp_id = e.parent_id);
996:
997: -- End of API body.
998:
999: -- Standard check of p_commit.
1000: IF fnd_api.to_boolean(p_commit) THEN
1001: COMMIT WORK;
1002: END IF;
1003:

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

1000: IF fnd_api.to_boolean(p_commit) THEN
1001: COMMIT WORK;
1002: END IF;
1003:
1004: -- Standard call to get message count and if count is 1, get message info.
1005: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1006: , p_encoded => fnd_api.g_false);
1007: EXCEPTION
1008: WHEN fnd_api.g_exc_error THEN

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

1094: WHERE calc_sql_exp_id = p_calc_sql_exp_id
1095: OR f_calc_sql_exp_id = p_calc_sql_exp_id));
1096:
1097: BEGIN
1098: -- Standard call to check for call compatibility.
1099: IF NOT FND_API.Compatible_API_Call
1100: (l_api_version ,
1101: p_api_version ,
1102: l_api_name ,

Line 1122: -- Standard check of p_commit.

1118: END LOOP;
1119:
1120: -- End of API body.
1121:
1122: -- Standard check of p_commit.
1123: IF FND_API.To_Boolean( p_commit ) THEN
1124: COMMIT WORK;
1125: END IF;
1126: -- Standard call to get message count and if count is 1, get message info.

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

1122: -- Standard check of p_commit.
1123: IF FND_API.To_Boolean( p_commit ) THEN
1124: COMMIT WORK;
1125: END IF;
1126: -- Standard call to get message count and if count is 1, get message info.
1127: FND_MSG_PUB.count_and_get
1128: (p_count => x_msg_count ,
1129: p_data => x_msg_data ,
1130: p_encoded => FND_API.G_FALSE );

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

1595: ) IS
1596: l_api_name CONSTANT VARCHAR2(30) := 'get_dependent_plan_elts';
1597: l_api_version CONSTANT NUMBER := 1.0;
1598: BEGIN
1599: -- Standard call to check for call compatibility.
1600: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1601: RAISE fnd_api.g_exc_unexpected_error;
1602: END IF;
1603:

Line 1614: -- Standard check of p_commit.

1610: x_return_status := fnd_api.g_ret_sts_success;
1611: -- API body
1612: dfs(p_node_type, p_node_id, p_node_type, p_node_id, 0, x_plan_elt_id_tbl);
1613:
1614: -- Standard check of p_commit.
1615: IF fnd_api.to_boolean(p_commit) THEN
1616: COMMIT WORK;
1617: END IF;
1618:

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

1615: IF fnd_api.to_boolean(p_commit) THEN
1616: COMMIT WORK;
1617: END IF;
1618:
1619: -- Standard call to get message count and if count is 1, get message info.
1620: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1621: , p_encoded => fnd_api.g_false);
1622: EXCEPTION
1623: WHEN fnd_api.g_exc_error THEN

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

1735: ) IS
1736: l_api_name CONSTANT VARCHAR2(30) := 'get_parent_plan_elts';
1737: l_api_version CONSTANT NUMBER := 1.0;
1738: BEGIN
1739: -- Standard call to check for call compatibility.
1740: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;
1743:

Line 1754: -- Standard check of p_commit.

1750: x_return_status := fnd_api.g_ret_sts_success;
1751: -- API body
1752: dfs2(p_node_type, p_node_id, p_node_type, p_node_id, 0, x_plan_elt_id_tbl);
1753:
1754: -- Standard check of p_commit.
1755: IF fnd_api.to_boolean(p_commit) THEN
1756: COMMIT WORK;
1757: END IF;
1758:

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

1755: IF fnd_api.to_boolean(p_commit) THEN
1756: COMMIT WORK;
1757: END IF;
1758:
1759: -- Standard call to get message count and if count is 1, get message info.
1760: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
1761: , p_encoded => fnd_api.g_false);
1762: EXCEPTION
1763: WHEN fnd_api.g_exc_error THEN

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

1885: SELECT object_name
1886: FROM user_objects
1887: WHERE object_type = 'FUNCTION' AND status = 'VALID';
1888: BEGIN
1889: -- Standard call to check for call compatibility.
1890: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;
1893:

Line 2094: -- Standard check of p_commit.

2090:
2091: x_sql_from := REPLACE(SUBSTR(x_piped_sql_from, 1, LENGTH(x_piped_sql_from) - 1), '|'
2092: , ', '); -- trim last comma
2093:
2094: -- Standard check of p_commit.
2095: IF fnd_api.to_boolean(p_commit) THEN
2096: COMMIT WORK;
2097: END IF;
2098:

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

2095: IF fnd_api.to_boolean(p_commit) THEN
2096: COMMIT WORK;
2097: END IF;
2098:
2099: -- Standard call to get message count and if count is 1, get message info.
2100: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2101: , p_encoded => fnd_api.g_false);
2102: EXCEPTION
2103: WHEN fnd_api.g_exc_error THEN

Line 2737: -- Standard Start of API savepoint

2733: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2734: l_suffix VARCHAR2(10) := NULL;
2735: l_prefix VARCHAR2(10) := NULL;
2736: BEGIN
2737: -- Standard Start of API savepoint
2738: SAVEPOINT create_expression;
2739:
2740: -- Standard call to check for call compatibility.
2741: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

2736: BEGIN
2737: -- Standard Start of API savepoint
2738: SAVEPOINT create_expression;
2739:
2740: -- Standard call to check for call compatibility.
2741: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2742: RAISE fnd_api.g_exc_unexpected_error;
2743: END IF;
2744:

Line 2814: -- Standard check of p_commit.

2810: , x_msg_data => x_msg_data
2811: , x_object_version_number => x_object_version_number
2812: );
2813:
2814: -- Standard check of p_commit.
2815: IF fnd_api.to_boolean(p_commit) THEN
2816: COMMIT WORK;
2817: END IF;
2818:

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

2815: IF fnd_api.to_boolean(p_commit) THEN
2816: COMMIT WORK;
2817: END IF;
2818:
2819: -- Standard call to get message count and if count is 1, get message info.
2820: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2821: , p_encoded => fnd_api.g_false);
2822: EXCEPTION
2823: WHEN fnd_api.g_exc_error THEN