APPS.AMS_PS_POSTING_PVT dependencies on AMS_IBA_PS_POSTINGS_B

Line 37: SELECT AMS_IBA_PS_POSTINGS_B_s.NEXTVAL

33: l_dummy NUMBER;
34: l_tempchar VARCHAR2(1);
35:
36: CURSOR c_id IS
37: SELECT AMS_IBA_PS_POSTINGS_B_s.NEXTVAL
38: FROM dual;
39:
40: CURSOR c_id_exists (l_id IN NUMBER) IS
41: SELECT 1

Line 42: FROM AMS_IBA_PS_POSTINGS_B

38: FROM dual;
39:
40: CURSOR c_id_exists (l_id IN NUMBER) IS
41: SELECT 1
42: FROM AMS_IBA_PS_POSTINGS_B
43: WHERE POSTING_ID = l_id;
44:
45: BEGIN
46: -- Standard Start of API savepoint

Line 148: -- Invoke table handler(AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row)

144: RAISE FND_API.g_exc_error;
145: END IF;
146:
147:
148: -- Invoke table handler(AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row)
149: AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row(
150: p_created_by => FND_GLOBAL.user_id,
151: p_creation_date => SYSDATE,
152: p_last_updated_by => FND_GLOBAL.user_id,

Line 149: AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row(

145: END IF;
146:
147:
148: -- Invoke table handler(AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row)
149: AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row(
150: p_created_by => FND_GLOBAL.user_id,
151: p_creation_date => SYSDATE,
152: p_last_updated_by => FND_GLOBAL.user_id,
153: p_last_update_date => SYSDATE,

Line 268: FROM AMS_IBA_PS_POSTINGS_B

264: l_tempchar VARCHAR2(1);
265:
266: CURSOR c_object_version(post_id IN NUMBER) IS
267: SELECT object_version_number
268: FROM AMS_IBA_PS_POSTINGS_B
269: WHERE posting_id = post_id;
270:
271: BEGIN
272: -- Standard Start of API savepoint

Line 363: Update AMS_IBA_PS_POSTINGS_B

359: IF (AMS_DEBUG_HIGH_ON) THEN
360: AMS_UTILITY_PVT.debug_message('Private API: Updating B and TL Tables');
361: END IF;
362:
363: Update AMS_IBA_PS_POSTINGS_B
364: SET
365: last_updated_by = FND_GLOBAL.user_id,
366: last_update_date = SYSDATE,
367: last_update_login = FND_GLOBAL.conc_login_id,

Line 535: FROM AMS_IBA_PS_POSTINGS_B

531: where posting_id = post_id;
532:
533: CURSOR c_object_version_number(post_id IN NUMBER) IS
534: SELECT object_version_number
535: FROM AMS_IBA_PS_POSTINGS_B
536: where posting_id = post_id;
537:
538: CURSOR c_rulegroup_id(post_id IN NUMBER) IS
539: SELECT rulegroup_id

Line 585: DELETE FROM AMS_IBA_PS_POSTINGS_B

581: CLOSE c_object_version_number;
582:
583: IF l_is_used_count = 0 THEN -- IS NOT USED
584: IF l_object_version_number = p_object_version_number THEN -- VERSIONS MATCH
585: DELETE FROM AMS_IBA_PS_POSTINGS_B
586: WHERE posting_id = p_posting_id;
587:
588: IF (SQL%NOTFOUND) THEN
589: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 723: FROM AMS_IBA_PS_POSTINGS_B

719: l_POSTING_ID NUMBER;
720:
721: CURSOR c_Ps_Posting IS
722: SELECT POSTING_ID
723: FROM AMS_IBA_PS_POSTINGS_B
724: WHERE POSTING_ID = p_POSTING_ID
725: AND object_version_number = p_object_version
726: FOR UPDATE NOWAIT;
727:

Line 835: FROM ams_iba_ps_postings_b

831: l_return_status VARCHAR2(1);
832:
833: CURSOR c_complete IS
834: SELECT *
835: FROM ams_iba_ps_postings_b
836: WHERE posting_id = p_ps_posting_rec.posting_id;
837: l_ps_posting_rec c_complete%ROWTYPE;
838: BEGIN
839: x_complete_rec := p_ps_posting_rec;