APPS.JTF_BRMPARAMETER_PVT dependencies on JTF_BRM_PARAMETERS

Line 9: -- Description : Create record in JTF_BRM_PARAMETERS table

5:
6: --------------------------------------------------------------------------
7: -- Start of comments
8: -- Procedure : Create_BRMParameter
9: -- Description : Create record in JTF_BRM_PARAMETERS table
10: -- Parameters :
11: -- name direction type required?
12: -- ---- --------- ---- ---------
13: -- p_api_version IN NUMBER required

Line 52: FROM JTF_BRM_PARAMETERS

48: l_rowid ROWID;
49: l_parameter_id NUMBER;
50:
51: CURSOR c IS SELECT ROWID
52: FROM JTF_BRM_PARAMETERS
53: WHERE PARAMETER_ID = l_parameter_id;
54:
55: BEGIN
56: --

Line 88: -- the passed in attributes into the JTF_BRM_PARAMETERS table.

84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: -------------------------------------------------------------------------
87: -- Perform the database operation. Set the parameter ID to 1, then insert
88: -- the passed in attributes into the JTF_BRM_PARAMETERS table.
89: -------------------------------------------------------------------------
90: l_parameter_id := 1;
91:
92: --

Line 95: INSERT INTO JTF_BRM_PARAMETERS

91:
92: --
93: -- Insert into table
94: --
95: INSERT INTO JTF_BRM_PARAMETERS
96: ( PARAMETER_ID
97: , CREATED_BY
98: , CREATION_DATE
99: , LAST_UPDATED_BY

Line 232: -- Description : Update record in JTF_BRM_PARAMETERS table

228:
229: --------------------------------------------------------------------------
230: -- Start of comments
231: -- Procedure : Update_BRMParameter
232: -- Description : Update record in JTF_BRM_PARAMETERS table
233: -- Parameters :
234: -- name direction type required?
235: -- ---- --------- ---- ---------
236: -- p_api_version IN NUMBER required

Line 311: UPDATE JTF_BRM_PARAMETERS

307: SELECT JTF_BRM_OBJECT_VERSION_S.NEXTVAL
308: INTO l_object_version_number
309: FROM DUAL;
310:
311: UPDATE JTF_BRM_PARAMETERS
312: SET LAST_UPDATED_BY = p_bp_rec.LAST_UPDATED_BY
313: , LAST_UPDATE_DATE = p_bp_rec.LAST_UPDATE_DATE
314: , LAST_UPDATE_LOGIN = p_bp_rec.LAST_UPDATE_LOGIN
315: , BRM_UOM_TYPE = p_bp_rec.BRM_UOM_TYPE

Line 403: -- Description : Delete record in JTF_BRM_PARAMETERS table

399:
400: --------------------------------------------------------------------------
401: -- Start of comments
402: -- Procedure : Delete_BRMParameter
403: -- Description : Delete record in JTF_BRM_PARAMETERS table
404: -- Parameters :
405: -- name direction type required?
406: -- ---- --------- ---- ---------
407: -- p_api_version IN NUMBER required

Line 472: DELETE FROM JTF_BRM_PARAMETERS

468: -- Initialize return status to SUCCESS
469: --
470: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
471:
472: DELETE FROM JTF_BRM_PARAMETERS
473: WHERE PARAMETER_ID = p_parameter_id;
474:
475: IF (SQL%NOTFOUND)
476: THEN