APPS.JTF_BRMPROCESS_PVT dependencies on JTF_BRM_PROCESSES

Line 10: -- Function : Create record in JTF_BRM_PROCESSES table.

6: --------------------------------------------------------------------------
7: -- Start of comments
8: -- API name : Create_BRMProcess
9: -- Type : Private
10: -- Function : Create record in JTF_BRM_PROCESSES table.
11: -- Pre-reqs : None.
12: -- Parameters :
13: -- name direction type required?
14: -- ---- --------- ---- ---------

Line 52: FROM JTF_BRM_PROCESSES

48: l_rowid ROWID;
49: l_process_id NUMBER;
50:
51: CURSOR C IS SELECT ROWID
52: FROM JTF_BRM_PROCESSES
53: WHERE PROCESS_ID = l_process_id;
54:
55: BEGIN
56: --

Line 89: -- JTF_BRM_PROCESSES table.

85:
86: -- ----------------------------------------------------------------------
87: -- Perform the database operation. Generate the method ID from the
88: -- sequence, then insert the passed in attributes into the
89: -- JTF_BRM_PROCESSES table.
90: ----------------------------------------------------------------------
91: IF (p_bpr_rec.Process_id IS NULL)
92: THEN
93: SELECT JTF_BRM_PROCESSES_S.NEXTVAL INTO l_Process_id

Line 93: SELECT JTF_BRM_PROCESSES_S.NEXTVAL INTO l_Process_id

89: -- JTF_BRM_PROCESSES table.
90: ----------------------------------------------------------------------
91: IF (p_bpr_rec.Process_id IS NULL)
92: THEN
93: SELECT JTF_BRM_PROCESSES_S.NEXTVAL INTO l_Process_id
94: FROM DUAL;
95: ELSE
96: l_process_id := p_bpr_rec.Process_id;
97: END IF;

Line 102: INSERT INTO JTF_BRM_PROCESSES

98:
99: --
100: -- Insert into table
101: --
102: INSERT INTO JTF_BRM_PROCESSES
103: ( PROCESS_ID
104: , RULE_ID
105: , CREATED_BY
106: , CREATION_DATE

Line 248: -- Function : Update record in JTF_BRM_PROCESSES table.

244: --------------------------------------------------------------------------
245: -- Start of comments
246: -- API name : Update_BRMParameter
247: -- Type : Private
248: -- Function : Update record in JTF_BRM_PROCESSES table.
249: -- Pre-reqs : None.
250: -- Parameters :
251: -- name direction type required?
252: -- ---- --------- ---- ---------

Line 326: UPDATE JTF_BRM_PROCESSES

322: SELECT JTF_BRM_OBJECT_VERSION_S.NEXTVAL
323: INTO l_object_version_number
324: FROM DUAL;
325:
326: UPDATE JTF_BRM_PROCESSES
327: SET RULE_ID = p_bpr_rec.RULE_ID
328: , LAST_UPDATED_BY = p_bpr_rec.LAST_UPDATED_BY
329: , LAST_UPDATE_DATE = p_bpr_rec.LAST_UPDATE_DATE
330: , LAST_UPDATE_LOGIN = p_bpr_rec.LAST_UPDATE_LOGIN

Line 423: -- Description : Delete record in JTF_BRM_PROCESSES table.

419: --------------------------------------------------------------------------
420: -- Start of comments
421: -- API Name : Delete_BRMParameter
422: -- Type : Private
423: -- Description : Delete record in JTF_BRM_PROCESSES table.
424: -- Pre-reqs : None
425: -- Parameters :
426: -- name direction type required?
427: -- ---- --------- ---- ---------

Line 492: DELETE FROM JTF_BRM_PROCESSES

488: -- Initialize return status to SUCCESS
489: --
490: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
491:
492: DELETE FROM JTF_BRM_PROCESSES
493: WHERE PROCESS_ID = p_process_id;
494:
495: --
496: -- Check whether update was succesful