APPS.AMS_EVENTHEADER_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 83: FROM ams_event_headers_vl

79: FROM DUAL;
80:
81: CURSOR c_evh_count(evh_id IN NUMBER) IS
82: SELECT COUNT(*)
83: FROM ams_event_headers_vl
84: WHERE event_header_id = evh_id;
85:
86: CURSOR c_evh_status_evagd(ust_id IN NUMBER) IS
87: SELECT system_status_code

Line 1059: FROM ams_event_headers_vl

1055: AND act_budget_used_by_id =id_in;
1056:
1057: CURSOR c_evh IS
1058: SELECT global_flag,source_code
1059: FROM ams_event_headers_vl
1060: WHERE event_header_id = p_evh_rec.event_header_id;
1061:
1062:
1063: BEGIN

Line 2186: 'ams_event_headers_vl',

2182: IF p_validation_mode = JTF_PLSQL_API.g_create
2183: AND p_evh_rec.event_header_id IS NOT NULL
2184: THEN
2185: IF AMS_Utility_PVT.check_uniqueness(
2186: 'ams_event_headers_vl',
2187: 'event_header_id = ' || p_evh_rec.event_header_id
2188: ) = FND_API.g_false
2189: THEN
2190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 2344: 'ams_event_headers_vl',

2340:
2341: ----------------------- parent_event_header_id ------------------------
2342: IF p_evh_rec.parent_event_header_id <> FND_API.g_miss_num THEN
2343: IF AMS_Utility_PVT.check_fk_exists(
2344: 'ams_event_headers_vl',
2345: 'event_header_id',
2346: p_evh_rec.parent_event_header_id
2347: ) = FND_API.g_false
2348: THEN

Line 3325: FROM ams_event_headers_vl

3321: x_return_status varchar2(240);
3322:
3323: CURSOR c_evh IS
3324: SELECT *
3325: FROM ams_event_headers_vl
3326: WHERE event_header_id = p_evh_rec.event_header_id;
3327:
3328: l_evh_rec c_evh%ROWTYPE;
3329:

Line 3330: -- modified sugupta 08/13/2000 since ams_event_headers_vl doesnt have setup_id, and dont want to

3326: WHERE event_header_id = p_evh_rec.event_header_id;
3327:
3328: l_evh_rec c_evh%ROWTYPE;
3329:
3330: -- modified sugupta 08/13/2000 since ams_event_headers_vl doesnt have setup_id, and dont want to
3331: -- change odf files now.. add new cursor to get setup from table...
3332: -- need to change ams_event_headers_vl later to include setup_id
3333: CURSOR c_setup IS
3334: select setup_type_id

Line 3332: -- need to change ams_event_headers_vl later to include setup_id

3328: l_evh_rec c_evh%ROWTYPE;
3329:
3330: -- modified sugupta 08/13/2000 since ams_event_headers_vl doesnt have setup_id, and dont want to
3331: -- change odf files now.. add new cursor to get setup from table...
3332: -- need to change ams_event_headers_vl later to include setup_id
3333: CURSOR c_setup IS
3334: select setup_type_id
3335: from ams_event_headers_all_b
3336: where event_header_id = p_evh_rec.event_header_id;