DBA Data[Home] [Help]

APPS.CN_RT_QUOTA_ASGN_PVT dependencies on STANDARD

Line 305: -- Standard Start of API savepoint

301: p_last_update_date DATE;
302: p_last_updated_by NUMBER;
303: p_object_version_number NUMBER;
304: BEGIN
305: -- Standard Start of API savepoint
306: SAVEPOINT create_rt_quota_asgn;
307:
308: -- Standard call to check for call compatibility.
309: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

304: BEGIN
305: -- Standard Start of API savepoint
306: SAVEPOINT create_rt_quota_asgn;
307:
308: -- Standard call to check for call compatibility.
309: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
310: THEN
311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;

Line 405: -- Standard check of p_commit.

401:
402:
403:
404: -- End of API body.
405: -- Standard check of p_commit.
406: IF fnd_api.to_boolean (p_commit)
407: THEN
408: COMMIT WORK;
409: END IF;

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

407: THEN
408: COMMIT WORK;
409: END IF;
410:
411: -- Standard call to get message count and if count is 1, get message info.
412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
413: EXCEPTION
414: WHEN fnd_api.g_exc_error
415: THEN

Line 517: -- Standard Start of API savepoint

513: p_last_update_date DATE;
514: p_last_updated_by NUMBER;
515: p_object_version_number NUMBER;
516: BEGIN
517: -- Standard Start of API savepoint
518: SAVEPOINT update_rt_quota_asgn;
519:
520: -- Standard call to check for call compatibility.
521: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

516: BEGIN
517: -- Standard Start of API savepoint
518: SAVEPOINT update_rt_quota_asgn;
519:
520: -- Standard call to check for call compatibility.
521: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
522: THEN
523: RAISE fnd_api.g_exc_unexpected_error;
524: END IF;

Line 678: -- Standard check of p_commit.

674: END IF;
675:
676:
677: -- End of API body.
678: -- Standard check of p_commit.
679: IF fnd_api.to_boolean (p_commit)
680: THEN
681: COMMIT WORK;
682: END IF;

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

680: THEN
681: COMMIT WORK;
682: END IF;
683:
684: -- Standard call to get message count and if count is 1, get message info.
685: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
686: EXCEPTION
687: WHEN fnd_api.g_exc_error
688: THEN

Line 784: -- Standard Start of API savepoint

780: WHERE rt_quota_asgn_id = l_rt_quota_asgn_id;
781:
782: l_rt_quota_asgn rt_quota_asgns_cr%ROWTYPE;*/
783: BEGIN
784: -- Standard Start of API savepoint
785: SAVEPOINT delete_rt_quota_asgn;
786:
787: -- Standard call to check for call compatibility.
788: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

783: BEGIN
784: -- Standard Start of API savepoint
785: SAVEPOINT delete_rt_quota_asgn;
786:
787: -- Standard call to check for call compatibility.
788: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
789: THEN
790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;

Line 934: -- Standard check of p_commit.

930: END IF;
931:
932:
933: -- End of API body.
934: -- Standard check of p_commit.
935: IF fnd_api.to_boolean (p_commit)
936: THEN
937: COMMIT WORK;
938: END IF;

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

936: THEN
937: COMMIT WORK;
938: END IF;
939:
940: -- Standard call to get message count and if count is 1, get message info.
941: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
942: EXCEPTION
943: WHEN fnd_api.g_exc_error
944: THEN

Line 1040: -- Standard Start of API savepoint

1036: WHERE quota_id = l_quota_id AND calc_formula_id = l_calc_formula_id;
1037:
1038: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;
1039: BEGIN
1040: -- Standard Start of API savepoint
1041: SAVEPOINT get_formula_rate_tables;
1042:
1043: -- Standard call to check for call compatibility.
1044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1039: BEGIN
1040: -- Standard Start of API savepoint
1041: SAVEPOINT get_formula_rate_tables;
1042:
1043: -- Standard call to check for call compatibility.
1044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1045: THEN
1046: RAISE fnd_api.g_exc_unexpected_error;
1047: END IF;

Line 1113: -- Standard check of p_commit.

1109: x_rate_tables := l_rate_tables;
1110: x_calc_formulas := l_calc_formulas;
1111:
1112: -- End of API body.
1113: -- Standard check of p_commit.
1114: IF fnd_api.to_boolean (p_commit)
1115: THEN
1116: COMMIT WORK;
1117: END IF;

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

1115: THEN
1116: COMMIT WORK;
1117: END IF;
1118:
1119: -- Standard call to get message count and if count is 1, get message info.
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1121: EXCEPTION
1122: WHEN fnd_api.g_exc_error
1123: THEN

Line 1188: -- Standard Start of API savepoint

1184: l_formula_type CN_QUOTAS.QUOTA_TYPE_CODE%TYPE ;
1185: l_formula_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1186: l_rate_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
1187: BEGIN
1188: -- Standard Start of API savepoint
1189: SAVEPOINT check_rt_quota_asgn;
1190:
1191: -- Standard call to check for call compatibility.
1192: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1187: BEGIN
1188: -- Standard Start of API savepoint
1189: SAVEPOINT check_rt_quota_asgn;
1190:
1191: -- Standard call to check for call compatibility.
1192: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1193: THEN
1194: RAISE fnd_api.g_exc_unexpected_error;
1195: END IF;

Line 1382: -- Standard check of p_commit.

1378: END IF;
1379: END IF;
1380:
1381: -- End of API body.
1382: -- Standard check of p_commit.
1383: IF fnd_api.to_boolean (p_commit)
1384: THEN
1385: COMMIT WORK;
1386: END IF;

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

1384: THEN
1385: COMMIT WORK;
1386: END IF;
1387:
1388: -- Standard call to get message count and if count is 1, get message info.
1389: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1390: EXCEPTION
1391: WHEN fnd_api.g_exc_error
1392: THEN