[Home] [Help]
63: FROM ams_jtf_rs_emp_v
64: WHERE user_id = l_user_id;
65:
66: CURSOR c_association_seq IS
67: SELECT ams_object_associations_s.NEXTVAL
68: FROM DUAL;
69:
70: CURSOR c_association_count(association_id IN NUMBER) IS
71: SELECT COUNT(*)
68: FROM DUAL;
69:
70: CURSOR c_association_count(association_id IN NUMBER) IS
71: SELECT COUNT(*)
72: FROM ams_object_associations
73: WHERE object_association_id = association_id;
74:
75: CURSOR c_get_lang_code ( l_camp_sch_id IN NUMBER) IS
76: SELECT language_code
230: EXIT WHEN l_association_count = 0;
231: END LOOP;
232: END IF;
233:
234: INSERT INTO ams_object_associations(
235: OBJECT_ASSOCIATION_ID,
236: LAST_UPDATE_DATE,
237: LAST_UPDATED_BY,
238: CREATION_DATE,
451: l_res_id NUMBER;
452:
453: cursor get_objattr_info(l_obj_id IN NUMBER) is
454: select distinct a.using_object_type, a.master_object_type, a.master_object_id
455: from ams_object_associations a, ams_object_associations b
456: where a.master_object_type = b.master_object_type
457: and a.master_object_id = b.master_object_id
458: and a.using_object_type = b.using_object_type
459: and b.object_association_id = l_obj_id;
459: and b.object_association_id = l_obj_id;
460:
461: cursor get_count(c_obj_type IN VARCHAR2, c_obj_id IN NUMBER, c_attr IN VARCHAR2) is
462: select 'dummy'
463: from ams_object_associations
464: where master_object_type = c_obj_type
465: and master_object_id = c_obj_id
466: and using_object_type = c_attr;
467:
471: WHERE user_id = l_user_id;
472:
473: CURSOR get_master_info(l_obj_id IN NUMBER) IS
474: SELECT master_object_type, master_object_id
475: FROM ams_object_associations
476: WHERE object_association_id = l_obj_id;
477:
478: BEGIN
479:
534: OPEN get_objattr_info(l_c_obj_id);
535: FETCH get_objattr_info into l_attr, l_object_type, l_object_id;
536: close get_objattr_info;
537:
538: DELETE FROM ams_object_associations
539: WHERE object_association_id = p_object_association_id
540: AND object_version_number = p_object_version;
541:
542: IF (SQL%NOTFOUND) THEN
683: l_object_association_id NUMBER;
684:
685: CURSOR c_association_b IS
686: SELECT object_association_id
687: FROM ams_object_associations
688: WHERE object_association_id = p_object_association_id
689: AND object_version_number = p_object_version
690: FOR UPDATE OF object_association_id NOWAIT;
691:
913:
914: AMS_Utility_PVT.debug_message(l_full_name ||': update');
915: END IF;
916:
917: UPDATE ams_object_associations SET
918: last_update_date = SYSDATE,
919: last_updated_by = FND_GLOBAL.user_id,
920: last_update_login = FND_GLOBAL.conc_login_id,
921: object_version_number = l_association_rec.object_version_number + 1,
1347: ,p_masterobjId IN NUMBER
1348: ,p_masterobjType IN VARCHAR2)
1349: IS
1350: SELECT DISTINCT 'Y'
1351: FROM ams_object_associations
1352: WHERE master_object_type = p_masterobjType
1353: AND master_object_id = p_masterobjId
1354: AND using_object_type = p_using_objType
1355: AND using_object_id = p_using_id;
1365: IF p_validation_mode = JTF_PLSQL_API.g_create
1366: AND p_association_rec.object_association_id IS NOT NULL
1367: THEN
1368: IF AMS_Utility_PVT.check_uniqueness(
1369: 'ams_object_associations',
1370: 'object_association_id = ' || p_association_rec.object_association_id
1371: ) = FND_API.g_false
1372: THEN
1373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1795: IS
1796:
1797: CURSOR c_association IS
1798: SELECT *
1799: FROM ams_object_associations
1800: WHERE object_association_id = p_association_rec.object_association_id;
1801:
1802: l_association_rec c_association%ROWTYPE;
1803: