[Home] [Help]
1: PACKAGE BODY CAC_SR_OBJECT_CAPACITY_PUB AS
2: /* $Header: cacsrocpb.pls 120.1.12010000.4 2009/06/01 08:45:42 anangupt ship $ */
3:
4: -- package identification
5: g_pkg_name constant varchar2(30) := 'CAC_SR_OBJECT_CAPACITY_PUB';
1: PACKAGE BODY CAC_SR_OBJECT_CAPACITY_PUB AS
2: /* $Header: cacsrocpb.pls 120.1.12010000.4 2009/06/01 08:45:42 anangupt ship $ */
3:
4: -- package identification
5: g_pkg_name constant varchar2(30) := 'CAC_SR_OBJECT_CAPACITY_PUB';
6: g_default_capacity_status constant number := 1;
7:
8: /*******************************************************************************
9: ** Private APIs
12: FUNCTION get_new_object_capacity_id
13: /*******************************************************************************
14: ** get_new_object_capacity_id
15: **
16: ** This API returns the next value of the sequence cac_sr_object_capacity_s
17: **
18: *******************************************************************************/
19: RETURN NUMBER IS
20:
18: *******************************************************************************/
19: RETURN NUMBER IS
20:
21: CURSOR get_object_capacity_id IS
22: SELECT cac_sr_object_capacity_s.nextval
23: FROM dual;
24:
25: l_return NUMBER;
26:
74: ** generate_object_capacity
75: **
76: ** This API calls JTF_CALENDAR_PUB_24HR.Get_Resource_Shifts API and builds the
77: ** pl/sql table with object capacity records. It populates object_capacity_id
78: ** for each record with the sequence cac_sr_object_capacity_s value if the
79: ** parameter p_PopulateID is 'T'.
80: ** It will return a list of tasks also if the p_FetchTasks parameter is set to
81: ** true. This is needed only if you want to fetch all the tasks at one shot as
82: ** it will be more performant than fetching tasks for each object capacity
322: PROCEDURE insert_object_capacity
323: /*******************************************************************************
324: ** insert_object_capacity
325: **
326: ** This API calls table handler to insert data into cac_sr_object_capacity
327: ** using pl/sql table passed. It populates object_capacity_id for each record
328: ** if with the sequence cac_sr_object_capacity_s value if it is NULL in the
329: ** record.
330: ** It updates the task assignment with the corresponding object_capacity_id
324: ** insert_object_capacity
325: **
326: ** This API calls table handler to insert data into cac_sr_object_capacity
327: ** using pl/sql table passed. It populates object_capacity_id for each record
328: ** if with the sequence cac_sr_object_capacity_s value if it is NULL in the
329: ** record.
330: ** It updates the task assignment with the corresponding object_capacity_id
331: ** if the p_Update_Tasks parameter is set to 'T'.
332: **
403: p_Object_Capacity(l_idx).availability_type:=DEFAULT_AVAILABILITY_TYPE;
404: END IF;
405:
406: -- call the table handler to insert data
407: CAC_SR_OBJECT_CAPACITY_PKG.INSERT_ROW
408: (
409: X_ROWID => l_rowid,
410: X_OBJECT_CAPACITY_ID => p_Object_Capacity(l_idx).OBJECT_CAPACITY_ID,
411: X_OBJECT_VERSION_NUMBER => p_Object_Capacity(l_idx).OBJECT_VERSION_NUMBER,
506: PROCEDURE update_object_capacity
507: /*******************************************************************************
508: ** update_object_capacity New version
509: **
510: ** This API calls table handler to update data into cac_sr_object_capacity.
511: ** Only the available hours fields and status can be updated.
512: ** This version include updation of shift type also.
513: *******************************************************************************/
514: ( p_api_version IN NUMBER -- API version you coded against
559: SCHEDULE_DETAIL_ID,
560: STATUS,
561: AVAILABILITY_TYPE,
562: SOURCE_TYPE
563: FROM CAC_SR_OBJECT_CAPACITY
564: WHERE OBJECT_CAPACITY_ID = b_object_capacity_id
565: FOR UPDATE OF OBJECT_CAPACITY_ID NOWAIT;
566:
567: l_api_name constant varchar2(30) := 'UPDATE_OBJECT_CAPACITY';
701: l_user := FND_GLOBAL.USER_ID;
702: l_login := FND_GLOBAL.LOGIN_ID;
703:
704: -- call the table handler to update data
705: CAC_SR_OBJECT_CAPACITY_PKG.UPDATE_ROW
706: (
707: X_OBJECT_CAPACITY_ID => l_Object_Capacity.OBJECT_CAPACITY_ID,
708: X_OBJECT_VERSION_NUMBER => l_Object_Capacity.OBJECT_VERSION_NUMBER,
709: X_OBJECT_TYPE => l_Object_Capacity.OBJECT_TYPE,
762: PROCEDURE delete_object_capacity
763: /*******************************************************************************
764: ** delete_object_capacity
765: **
766: ** This API calls table handler to delete data from cac_sr_object_capacity.
767: ** It will also update the task assignments and remove the object capacity id
768: ** if the p_update_tasks is true
769: **
770: *******************************************************************************/
785: (
786: b_object_capacity_id NUMBER
787: ) IS SELECT
788: OBJECT_VERSION_NUMBER
789: FROM CAC_SR_OBJECT_CAPACITY
790: WHERE OBJECT_CAPACITY_ID = b_object_capacity_id
791: FOR UPDATE OF OBJECT_CAPACITY_ID NOWAIT;
792:
793: CURSOR c_tasks
881: END LOOP;
882: END IF;
883:
884: -- call the table handler to delete data
885: CAC_SR_OBJECT_CAPACITY_PKG.DELETE_ROW
886: (
887: X_OBJECT_CAPACITY_ID => p_object_capacity_id
888: );
889:
1003:
1004: END build_object_capacity;
1005:
1006:
1007: END CAC_SR_OBJECT_CAPACITY_PUB;