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.AMS_CATEGORY_PVT dependencies on AMS_CATEGORIES_B

Line 91: SELECT ams_categories_b_s.NEXTVAL

87: l_category_rec category_rec_type := p_category_rec;
88: l_count NUMBER;
89:
90: CURSOR C_category_seq IS
91: SELECT ams_categories_b_s.NEXTVAL
92: FROM dual;
93:
94: CURSOR C_category_count(my_category_id VARCHAR2) IS
95: SELECT COUNT(*)

Line 96: FROM AMS_CATEGORIES_B

92: FROM dual;
93:
94: CURSOR C_category_count(my_category_id VARCHAR2) IS
95: SELECT COUNT(*)
96: FROM AMS_CATEGORIES_B
97: WHERE category_id = my_category_id;
98:
99: CURSOR c_findParentofParent ( l_parent_parent_id IN NUMBER ) IS
100: SELECT parent_category_id

Line 101: FROM AMS_CATEGORIES_B

97: WHERE category_id = my_category_id;
98:
99: CURSOR c_findParentofParent ( l_parent_parent_id IN NUMBER ) IS
100: SELECT parent_category_id
101: FROM AMS_CATEGORIES_B
102: WHERE category_id = l_parent_parent_id;
103:
104: l_parent_id NUMBER;
105:

Line 206: INSERT INTO AMS_CATEGORIES_B (

202: ------------- code added by abhola END ------------------------------------------
203: --
204: -- Insert into the base table.
205: --
206: INSERT INTO AMS_CATEGORIES_B (
207: CATEGORY_ID,
208: CREATION_DATE,
209: CREATED_BY,
210: LAST_UPDATE_DATE,

Line 404: FROM AMS_CATEGORIES_B

400:
401:
402: CURSOR c_findParentofParent ( l_parent_parent_id IN NUMBER ) IS
403: SELECT parent_category_id
404: FROM AMS_CATEGORIES_B
405: WHERE category_id = l_parent_parent_id;
406:
407: l_parent_id NUMBER;
408:

Line 491: UPDATE AMS_CATEGORIES_B

487: -- and created_by = 0 or 1 -- Bug 4064984
488: -- user cannot modify or delete seeded category
489: -- exception: enabled_flag can be modified
490: IF (l_category_rec.created_by IN (0,1) AND l_category_rec.category_id < 10000) THEN
491: UPDATE AMS_CATEGORIES_B
492: SET
493: LAST_UPDATE_DATE = SYSDATE,
494: LAST_UPDATED_BY = FND_GLOBAL.user_id,
495: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

Line 529: UPDATE AMS_CATEGORIES_B

525: END IF;
526:
527: ELSE -- l_category_rec.l_category_id >= 10000 or non-seeded with seq < 10000
528:
529: UPDATE AMS_CATEGORIES_B
530: SET
531: LAST_UPDATE_DATE = SYSDATE,
532: LAST_UPDATED_BY = FND_GLOBAL.user_id,
533: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

Line 754: delete from AMS_CATEGORIES_B

750: END IF;
751: RAISE FND_API.g_exc_error;
752: END IF;
753:
754: delete from AMS_CATEGORIES_B
755: where category_id = l_category_id
756: and object_version_number = p_object_version;
757:
758: IF (SQL%NOTFOUND) THEN

Line 878: CURSOR C_ams_categories_b IS

874:
875: -- Status Local Variables
876: l_return_status VARCHAR2(1); -- Return value from procedures
877:
878: CURSOR C_ams_categories_b IS
879: SELECT ARC_CATEGORY_CREATED_FOR,
880: PARENT_CATEGORY_ID
881: FROM AMS_CATEGORIES_B
882: WHERE category_id = p_category_id

Line 881: FROM AMS_CATEGORIES_B

877:
878: CURSOR C_ams_categories_b IS
879: SELECT ARC_CATEGORY_CREATED_FOR,
880: PARENT_CATEGORY_ID
881: FROM AMS_CATEGORIES_B
882: WHERE category_id = p_category_id
883: and object_version_number = p_object_version
884: FOR UPDATE of category_id NOWAIT;
885: Recinfo C_ams_categories_b%ROWTYPE;

Line 885: Recinfo C_ams_categories_b%ROWTYPE;

881: FROM AMS_CATEGORIES_B
882: WHERE category_id = p_category_id
883: and object_version_number = p_object_version
884: FOR UPDATE of category_id NOWAIT;
885: Recinfo C_ams_categories_b%ROWTYPE;
886:
887: CURSOR C_ams_categories_tl IS
888: SELECT CATEGORY_NAME,
889: DESCRIPTION,

Line 925: OPEN C_ams_categories_b;

921: AMS_Utility_PVT.debug_message(l_full_name||': lock');
922: END IF;
923:
924: -- Perform the database operation
925: OPEN C_ams_categories_b;
926: FETCH C_ams_categories_b INTO Recinfo;
927: IF (C_ams_categories_b%NOTFOUND) THEN
928: CLOSE C_ams_categories_b;
929: -- Error, check the msg level and added an error message to the

Line 926: FETCH C_ams_categories_b INTO Recinfo;

922: END IF;
923:
924: -- Perform the database operation
925: OPEN C_ams_categories_b;
926: FETCH C_ams_categories_b INTO Recinfo;
927: IF (C_ams_categories_b%NOTFOUND) THEN
928: CLOSE C_ams_categories_b;
929: -- Error, check the msg level and added an error message to the
930: -- API message list

Line 927: IF (C_ams_categories_b%NOTFOUND) THEN

923:
924: -- Perform the database operation
925: OPEN C_ams_categories_b;
926: FETCH C_ams_categories_b INTO Recinfo;
927: IF (C_ams_categories_b%NOTFOUND) THEN
928: CLOSE C_ams_categories_b;
929: -- Error, check the msg level and added an error message to the
930: -- API message list
931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 928: CLOSE C_ams_categories_b;

924: -- Perform the database operation
925: OPEN C_ams_categories_b;
926: FETCH C_ams_categories_b INTO Recinfo;
927: IF (C_ams_categories_b%NOTFOUND) THEN
928: CLOSE C_ams_categories_b;
929: -- Error, check the msg level and added an error message to the
930: -- API message list
931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
932: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

Line 939: CLOSE C_ams_categories_b;

935:
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;
938:
939: CLOSE C_ams_categories_b;
940:
941: open C_ams_categories_tl ;
942: close C_ams_categories_tl;
943:

Line 1273: l_table_name := 'AMS_CATEGORIES_B';

1269:
1270: IF p_category_rec.PARENT_CATEGORY_ID <> FND_API.g_miss_num AND
1271: p_category_rec.PARENT_CATEGORY_ID is NOT NULL THEN
1272:
1273: l_table_name := 'AMS_CATEGORIES_B';
1274: l_pk_name := 'CATEGORY_ID';
1275: l_pk_value := p_category_rec.PARENT_CATEGORY_ID;
1276:
1277: IF AMS_Utility_PVT.Check_FK_Exists (

Line 1356: from AMS_CATEGORIES_B

1352: --l_category_rec category_rec_type := p_category_rec;
1353:
1354: cursor get_parent_det (l_parent_cat_id IN NUMBER ) is
1355: select ARC_CATEGORY_CREATED_FOR
1356: from AMS_CATEGORIES_B
1357: where category_id = l_parent_cat_id;
1358:
1359: l_parent_cr_for varchar2(30);
1360:

Line 1364: FROM ams_categories_b

1360:
1361: CURSOR get_enabled_child (l_parent_cat_id IN NUMBER)
1362: IS
1363: SELECT COUNT(*)
1364: FROM ams_categories_b
1365: WHERE parent_category_id = l_parent_cat_id
1366: AND enabled_flag = 'Y';
1367:
1368:

Line 1560: AMS_CATEGORIES_B b

1556: l_item_name VARCHAR2(30); -- Return value from procedures
1557: l_dummy NUMBER;
1558: cursor c_ctg_name_crt(ctg_name_in IN VARCHAR2, ctg_id_in IN NUMBER,ctg_arc_in IN VARCHAR2) IS
1559: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_CATEGORIES_TL t,
1560: AMS_CATEGORIES_B b
1561: where t.category_name = ctg_name_in
1562: and b.arc_category_created_for = ctg_arc_in
1563: and language = userenv('LANG')
1564: and t.category_id = b.category_id

Line 1570: AMS_CATEGORIES_B b

1566: --and b.category_id = ctg_id_in
1567: );
1568: cursor c_ctg_name_updt(ctg_name_in IN VARCHAR2, ctg_id_in IN NUMBER,ctg_arc_in IN VARCHAR2) IS
1569: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_CATEGORIES_TL t,
1570: AMS_CATEGORIES_B b
1571: where t.category_name = ctg_name_in
1572: and b.arc_category_created_for = ctg_arc_in
1573: and language = userenv('LANG')
1574: and t.category_id = b.category_id

Line 1720: ( p_table_name => 'AMS_CATEGORIES_B'

1716: x_return_status := FND_API.G_RET_STS_SUCCESS;
1717: l_pk_value := l_category_id;
1718:
1719: IF AMS_Utility_PVT.Check_FK_Exists
1720: ( p_table_name => 'AMS_CATEGORIES_B'
1721: ,p_pk_name => 'PARENT_CATEGORY_ID'
1722: ,p_pk_value => l_pk_value
1723: ) = FND_API.G_TRUE
1724: THEN

Line 2234: select * from AMS_CATEGORIES_B WHERE CATEGORY_ID = my_category_id;

2230: l_Category_validate_row_rec category_rec_type;
2231:
2232:
2233: cursor C(my_category_id NUMBER) is
2234: select * from AMS_CATEGORIES_B WHERE CATEGORY_ID = my_category_id;
2235: BEGIN
2236:
2237: -- turned on debug mode
2238: IF AMS_Category_PVT.g_debug = TRUE