APPS.OZF_TASK_GROUP_PVT dependencies on OZF_REASONS

Line 64: SELECT ozf_reasons_s.nextval FROM DUAL;

60: l_reason_type_id number;
61: --
62: --Create this sequence in case and use in API
63: CURSOR reason_type_id_seq IS
64: SELECT ozf_reasons_s.nextval FROM DUAL;
65:
66: BEGIN
67: -- Standard begin of API savepoint
68: SAVEPOINT Create_task_group_PVT;

Line 153: INSERT INTO ozf_reasons (

149: OPEN reason_type_id_seq;
150: FETCH reason_type_id_seq INTO l_reason_type_id;
151: CLOSE reason_type_id_seq;
152:
153: INSERT INTO ozf_reasons (
154: reason_type_id,
155: object_version_number,
156: last_update_date,
157: last_updated_by,

Line 279: from ozf_reasons

275: l_reason_type varchar2(30);
276: --
277: CURSOR c_reason_type(cv_temp_group_id NUMBER) IS
278: select reason_type, object_version_number
279: from ozf_reasons
280: where task_template_group_id = cv_temp_group_id;
281:
282: BEGIN
283:

Line 390: UPDATE ozf_reasons

386: CLOSE c_reason_type;
387:
388: -- Update the reason type if changed
389: IF l_reason_type <> l_task_group.reason_type THEN
390: UPDATE ozf_reasons
391: SET REASON_TYPE = l_task_group.reason_type
392: , LAST_UPDATE_DATE = sysdate
393: , LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id, -1)
394: , OBJECT_VERSION_NUMBER = l_object_version_number + 1

Line 557: DELETE FROM ozf_reasons

553: END;
554:
555: -- Remove Reason Type association
556: -- CHECK Check to see if this should be deleted or made inactive
557: DELETE FROM ozf_reasons
558: WHERE task_template_group_id = p_task_template_group_id;
559:
560: --Standard check of commit
561: IF FND_API.To_Boolean ( p_commit ) THEN

Line 666: from ozf_reasons

662: l_reason_type varchar2(30);
663: --
664: CURSOR c_reason_type(cv_temp_group_id NUMBER) IS
665: select reason_type
666: from ozf_reasons
667: where task_template_group_id = cv_temp_group_id;
668:
669: BEGIN
670: -- Standard begin of API savepoint