APPS.JTF_BRMEXPRESSIONLINE_PVT dependencies on JTF_BRM_EXPRESSION_LINES

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

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

Line 48: FROM JTF_BRM_EXPRESSION_LINES

44: l_rowid ROWID;
45: l_expression_line_id NUMBER;
46:
47: CURSOR C IS SELECT ROWID
48: FROM JTF_BRM_EXPRESSION_LINES
49: WHERE expression_line_id = l_expression_line_id;
50:
51: BEGIN
52: --

Line 89: SELECT jtf_brm_expression_lines_s.NEXTVAL

85: -- JTF_BRM_EXPRESION_LINE table.
86: ------------------------------------------------------------------------
87: IF (p_bel_rec.expression_line_id IS NULL)
88: THEN
89: SELECT jtf_brm_expression_lines_s.NEXTVAL
90: INTO l_expression_line_id
91: FROM DUAL;
92: ELSE
93: l_expression_line_id := p_bel_rec.expression_line_id;

Line 99: INSERT INTO JTF_BRM_EXPRESSION_LINES

95:
96: --
97: -- Insert into table
98: --
99: INSERT INTO JTF_BRM_EXPRESSION_LINES
100: ( EXPRESSION_LINE_ID
101: , RULE_ID
102: , CREATED_BY
103: , CREATION_DATE

Line 244: -- Description : Update record in JTF_BRM_EXPRESSION_LINES table

240:
241: --------------------------------------------------------------------------
242: -- Start of comments
243: -- Procedure : Update_ExpressionLine
244: -- Description : Update record in JTF_BRM_EXPRESSION_LINES table
245: -- Parameters :
246: -- name direction type required?
247: -- ---- --------- ---- ---------
248: -- p_api_version IN NUMBER required

Line 306: SELECT jtf_brm_expression_lines_s.NEXTVAL

302:
303: ------------------------------------------------------------------------
304: -- Get a new object version number
305: ------------------------------------------------------------------------
306: SELECT jtf_brm_expression_lines_s.NEXTVAL
307: INTO l_object_version_number
308: FROM DUAL;
309:
310: UPDATE JTF_BRM_EXPRESSION_LINES

Line 310: UPDATE JTF_BRM_EXPRESSION_LINES

306: SELECT jtf_brm_expression_lines_s.NEXTVAL
307: INTO l_object_version_number
308: FROM DUAL;
309:
310: UPDATE JTF_BRM_EXPRESSION_LINES
311: SET RULE_ID = p_bel_rec.RULE_ID
312: , LAST_UPDATED_BY = p_bel_rec.LAST_UPDATED_BY
313: , LAST_UPDATE_DATE = p_bel_rec.LAST_UPDATE_DATE
314: , LAST_UPDATE_LOGIN = p_bel_rec.LAST_UPDATE_LOGIN

Line 407: -- Description : Delete record in JTF_BRM_EXPRESSION_LINES table

403:
404: --------------------------------------------------------------------------
405: -- Start of comments
406: -- Procedure : Delete_ExpressionLine
407: -- Description : Delete record in JTF_BRM_EXPRESSION_LINES table
408: -- Parameters :
409: -- name direction type required?
410: -- ---- --------- ---- ---------
411: -- p_api_version IN NUMBER required

Line 472: DELETE FROM JTF_BRM_EXPRESSION_LINES

468: -- Initialize return status to SUCCESS
469: --
470: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
471:
472: DELETE FROM JTF_BRM_EXPRESSION_LINES
473: WHERE expression_line_id = p_expression_line_id;
474:
475: --
476: -- Check if the delete was succesfull