APPS.CAC_SR_OBJECT_CAPACITY_PUB dependencies on CAC_SR_OBJECT_CAPACITY_S

Line 16: ** This API returns the next value of the sequence cac_sr_object_capacity_s

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:

Line 22: SELECT cac_sr_object_capacity_s.nextval

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:

Line 78: ** for each record with the sequence cac_sr_object_capacity_s value if the

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

Line 328: ** if with the sequence cac_sr_object_capacity_s value if it is NULL in the

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: **