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_ACTCATEGORY_PVT dependencies on AMS_ACT_CATEGORIES

Line 57: SELECT ams_act_categories_s.NEXTVAL

53:
54: l_act_category_id NUMBER;
55:
56: CURSOR C_act_category_id IS
57: SELECT ams_act_categories_s.NEXTVAL
58: FROM dual;
59:
60: BEGIN
61:

Line 116: INSERT INTO AMS_ACT_CATEGORIES

112: FETCH c_act_category_id INTO l_act_category_rec.activity_category_id;
113: CLOSE c_act_category_id;
114:
115:
116: INSERT INTO AMS_ACT_CATEGORIES
117: (activity_category_id,
118:
119: -- standard who columns
120: last_update_date,

Line 331: update AMS_ACT_CATEGORIES

327: THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: update AMS_ACT_CATEGORIES
332: set
333: last_update_date = sysdate
334: ,last_updated_by = FND_GLOBAL.User_Id
335: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 497: DELETE FROM AMS_ACT_CATEGORIES

493:
494: -- Perform the database operation
495:
496: -- Delete header data
497: DELETE FROM AMS_ACT_CATEGORIES
498: WHERE activity_category_id = l_act_category_id
499: and object_version_number = p_object_version;
500:
501: IF SQL%NOTFOUND THEN

Line 609: FROM AMS_ACT_CATEGORIES

605: l_act_category_id NUMBER;
606:
607: CURSOR c_act_category IS
608: SELECT activity_category_id
609: FROM AMS_ACT_CATEGORIES
610: WHERE activity_category_id = p_act_category_id
611: and object_version_number = p_object_version
612: FOR UPDATE of activity_category_id NOWAIT;
613:

Line 760: SELECT 1 from dual WHERE EXISTS(select 1 FROM AMS_ACT_CATEGORIES

756:
757: CURSOR c_act_ctg_id_exists(ctg_id_in IN NUMBER,
758: arc_used_by in VARCHAR2,
759: arc_used_id_in in NUMBER) IS
760: SELECT 1 from dual WHERE EXISTS(select 1 FROM AMS_ACT_CATEGORIES
761: WHERE category_id = ctg_id_in
762: and ARC_ACT_CATEGORY_USED_BY = arc_used_by
763: and ACT_CATEGORY_USED_BY_ID = arc_used_id_in);
764:

Line 923: SELECT 1 from dual WHERE EXISTS(select 1 FROM AMS_ACT_CATEGORIES

919: CURSOR c_act_ctg_id_exists(ctg_id_in IN NUMBER,
920: obj_ver_in IN NUMBER,
921: arc_used_by in VARCHAR2,
922: arc_used_id_in in NUMBER) IS
923: SELECT 1 from dual WHERE EXISTS(select 1 FROM AMS_ACT_CATEGORIES
924: WHERE category_id = ctg_id_in
925: and object_version_number = obj_ver_in
926: and ARC_ACT_CATEGORY_USED_BY = arc_used_by
927: and ACT_CATEGORY_USED_BY_ID = arc_used_id_in);

Line 991: 'ams_act_categories',

987: IF p_validation_mode = JTF_PLSQL_API.g_create
988: AND p_act_category_rec.activity_category_id IS NOT NULL
989: THEN
990: IF AMS_Utility_PVT.check_uniqueness(
991: 'ams_act_categories',
992: 'activity_category_id = ' || p_act_category_rec.activity_category_id
993: ) = FND_API.g_false
994: THEN
995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1013: l_table_name := 'AMS_ACT_CATEGORIES';

1009: on 04/10/2001
1010: -- Check FK parameter: ACT_CATEGORY_USED_BY_ID #1
1011: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID <> FND_API.g_miss_num
1012: THEN
1013: l_table_name := 'AMS_ACT_CATEGORIES';
1014: l_pk_name := 'ACT_CATEGORY_USED_BY_ID';
1015: l_pk_value := p_act_category_rec.ACT_CATEGORY_USED_BY_ID;
1016:
1017: IF AMS_Utility_PVT.Check_FK_Exists (

Line 1038: l_table_name := 'AMS_ACT_CATEGORIES';

1034:
1035: -- Check FK parameter: ACT_CATEGORY_USED_BY_ID #3
1036: IF p_act_category_rec.ACT_CATEGORY_USED_BY_ID <> FND_API.g_miss_num
1037: THEN
1038: l_table_name := 'AMS_ACT_CATEGORIES';
1039: l_pk_name := 'ACT_CATEGORY_USED_BY_ID';
1040: l_pk_value := p_act_category_rec.ACT_CATEGORY_USED_BY_ID;
1041:
1042: IF AMS_Utility_PVT.Check_FK_Exists (

Line 1212: FROM ams_act_categories

1208: ) IS
1209:
1210: CURSOR c_cat IS
1211: SELECT *
1212: FROM ams_act_categories
1213: WHERE activity_category_id = p_act_category_rec.activity_category_id;
1214:
1215: l_act_category_rec c_cat%ROWTYPE;
1216:

Line 1569: l_act_category_id AMS_ACT_CATEGORIES.ACTIVITY_CATEGORY_ID%TYPE;

1565: l_act_category_rec act_category_rec_type;
1566: l_return_status VARCHAR2(1);
1567: l_msg_count NUMBER;
1568: l_msg_data VARCHAR2(200);
1569: l_act_category_id AMS_ACT_CATEGORIES.ACTIVITY_CATEGORY_ID%TYPE;
1570:
1571: l_act_cty_validate_item_rec Act_category_validate_rec_type;
1572: l_act_cty_default_item_rec Act_category_validate_rec_type;
1573: l_act_cty_validate_row_rec Act_category_validate_rec_type;

Line 1629: l_act_category_id AMS_ACT_CATEGORIES.ACTIVITY_CATEGORY_ID%TYPE;

1625: l_act_category_rec act_category_rec_type;
1626: l_return_status VARCHAR2(1);
1627: l_msg_count NUMBER;
1628: l_msg_data VARCHAR2(200);
1629: l_act_category_id AMS_ACT_CATEGORIES.ACTIVITY_CATEGORY_ID%TYPE;
1630:
1631: l_act_category_req_item_rec act_category_validate_rec_type;
1632: l_act_cty_validate_item_rec act_category_validate_rec_type;
1633: l_act_cty_default_item_rec act_category_validate_rec_type;

Line 1678: l_act_category_id AMS_ACT_CATEGORIES.ACTIVITY_CATEGORY_ID%TYPE;

1674: l_act_category_rec act_category_rec_type;
1675: l_return_status VARCHAR2(1);
1676: l_msg_count NUMBER;
1677: l_msg_data VARCHAR2(200);
1678: l_act_category_id AMS_ACT_CATEGORIES.ACTIVITY_CATEGORY_ID%TYPE;
1679:
1680: l_act_category_req_item_rec act_category_validate_rec_type;
1681: l_act_cty_validate_item_rec act_category_validate_rec_type;
1682: l_act_cty_default_item_rec act_category_validate_rec_type;

Line 1687: FROM AMS_ACT_CATEGORIES

1683: l_act_cty_validate_row_rec act_category_validate_rec_type;
1684:
1685: CURSOR C(my_act_category_id NUMBER) is
1686: SELECT *
1687: FROM AMS_ACT_CATEGORIES
1688: WHERE ACTIVITY_CATEGORY_ID = my_act_category_id;
1689:
1690: BEGIN
1691:

Line 1739: l_act_category_id AMS_ACT_CATEGORIES.ACTIVITY_CATEGORY_ID%TYPE;

1735: l_act_category_rec act_category_rec_type;
1736: l_return_status VARCHAR2(1);
1737: l_msg_count NUMBER;
1738: l_msg_data VARCHAR2(200);
1739: l_act_category_id AMS_ACT_CATEGORIES.ACTIVITY_CATEGORY_ID%TYPE;
1740:
1741: l_act_category_req_item_rec act_category_validate_rec_type;
1742: l_act_cty_validate_item_rec act_category_validate_rec_type;
1743: l_act_cty_default_item_rec act_category_validate_rec_type;