DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGN_PVT dependencies on STANDARD

Line 60: -- Standard Start of API savepoint

56: FROM cn_quota_assigns
57: WHERE quota_assign_id = p_quota_assign.quota_assign_id;
58:
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT create_quota_assign;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT fnd_api.compatible_api_call (l_api_version,

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

59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT create_quota_assign;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT fnd_api.compatible_api_call (l_api_version,
65: p_api_version,
66: l_api_name,
67: g_pkg_name

Line 260: -- Standard check of p_commit.

256: FETCH objversion_cur INTO p_quota_assign.OBJECT_VERSION_NUMBER;
257: CLOSE objversion_cur;
258:
259: -- End of API body.
260: -- Standard check of p_commit.
261: IF fnd_api.to_boolean (p_commit)
262: THEN
263: COMMIT WORK;
264: END IF;

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

262: THEN
263: COMMIT WORK;
264: END IF;
265:
266: -- Standard call to get message count and if count is 1, get message info.
267: fnd_msg_pub.count_and_get (p_count => x_msg_count,
268: p_data => x_msg_data,
269: p_encoded => fnd_api.g_false
270: );

Line 369: -- Standard Start of API savepoint

365: l_consolidated_note VARCHAR2(2000);
366: old_seq CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE;
367:
368: BEGIN
369: -- Standard Start of API savepoint
370: SAVEPOINT update_quota_assign;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT fnd_api.compatible_api_call (l_api_version,

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

368: BEGIN
369: -- Standard Start of API savepoint
370: SAVEPOINT update_quota_assign;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT fnd_api.compatible_api_call (l_api_version,
374: p_api_version,
375: l_api_name,
376: g_pkg_name

Line 652: -- Standard check of p_commit.

648: );
649: END IF;
650:
651: -- End of API body.
652: -- Standard check of p_commit.
653: OPEN objversion_cur;
654: FETCH objversion_cur into p_quota_assign.OBJECT_VERSION_NUMBER;
655: CLOSE objversion_cur;
656:

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

658: THEN
659: COMMIT WORK;
660: END IF;
661:
662: -- Standard call to get message count and if count is 1, get message info.
663: fnd_msg_pub.count_and_get (p_count => x_msg_count,
664: p_data => x_msg_data,
665: p_encoded => fnd_api.g_false
666: );

Line 745: -- Standard Start of API savepoint

741: l_note_id NUMBER;
742: l_cp_name cn_comp_plans.NAME%TYPE;
743: l_pe_name cn_quotas.NAME%TYPE;
744: BEGIN
745: -- Standard Start of API savepoint
746: SAVEPOINT delete_quota_assign;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT fnd_api.compatible_api_call (l_api_version,

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

744: BEGIN
745: -- Standard Start of API savepoint
746: SAVEPOINT delete_quota_assign;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT fnd_api.compatible_api_call (l_api_version,
750: p_api_version,
751: l_api_name,
752: g_pkg_name

Line 832: -- Standard check of p_commit.

828: );
829: END IF;
830:
831: -- End of API body.
832: -- Standard check of p_commit.
833: IF fnd_api.to_boolean (p_commit)
834: THEN
835: COMMIT WORK;
836: END IF;

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

834: THEN
835: COMMIT WORK;
836: END IF;
837:
838: -- Standard call to get message count and if count is 1, get message info.
839: fnd_msg_pub.count_and_get (p_count => x_msg_count,
840: p_data => x_msg_data,
841: p_encoded => fnd_api.g_false
842: );

Line 926: -- Standard Start of API savepoint

922: WHERE qa.comp_plan_id = p_comp_plan_id
923: AND qa.quota_id = q.quota_id
924: ORDER BY quota_sequence;
925: BEGIN
926: -- Standard Start of API savepoint
927: SAVEPOINT get_quota_assign;
928:
929: -- Standard call to check for call compatibility.
930: IF NOT fnd_api.compatible_api_call (l_api_version,

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

925: BEGIN
926: -- Standard Start of API savepoint
927: SAVEPOINT get_quota_assign;
928:
929: -- Standard call to check for call compatibility.
930: IF NOT fnd_api.compatible_api_call (l_api_version,
931: p_api_version,
932: l_api_name,
933: g_pkg_name

Line 971: -- Standard check of p_commit.

967: x_quota_assign (l_counter).org_id := l_quota_assign.org_id;
968: END LOOP;
969:
970: -- End of API body.
971: -- Standard check of p_commit.
972: IF fnd_api.to_boolean (p_commit)
973: THEN
974: COMMIT WORK;
975: END IF;

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

973: THEN
974: COMMIT WORK;
975: END IF;
976:
977: -- Standard call to get message count and if count is 1, get message info.
978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data,
980: p_encoded => fnd_api.g_false
981: );