APPS.JTF_BRMWFATTRVALUE_PVT dependencies on JTF_BRM_WF_ATTR_VALUES

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

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

Line 52: FROM JTF_BRM_WF_ATTR_VALUES

48: l_rowid ROWID;
49: l_wf_attr_value_id NUMBER;
50:
51: CURSOR c IS SELECT ROWID
52: FROM JTF_BRM_WF_ATTR_VALUES
53: WHERE WF_ATTR_VALUE_ID = l_wf_attr_value_id;
54:
55: BEGIN
56: --

Line 88: -- JTF_BRM_WF_ATTR_VALUES table.

84:
85: -- ----------------------------------------------------------------------
86: -- Perform the database operation. Generate the ID from the
87: -- sequence, then insert the passed in attributes into the
88: -- JTF_BRM_WF_ATTR_VALUES table.
89: ----------------------------------------------------------------------
90: IF (p_bwa_rec.wf_attr_value_id IS NULL)
91: THEN
92: SELECT jtf_brm_wf_attr_values_s.NEXTVAL INTO l_wf_attr_value_id

Line 92: SELECT jtf_brm_wf_attr_values_s.NEXTVAL INTO l_wf_attr_value_id

88: -- JTF_BRM_WF_ATTR_VALUES table.
89: ----------------------------------------------------------------------
90: IF (p_bwa_rec.wf_attr_value_id IS NULL)
91: THEN
92: SELECT jtf_brm_wf_attr_values_s.NEXTVAL INTO l_wf_attr_value_id
93: FROM DUAL;
94: ELSE
95: l_wf_attr_value_id := p_bwa_rec.wf_attr_value_id;
96: END IF;

Line 101: INSERT INTO JTF_BRM_WF_ATTR_VALUES

97:
98: --
99: -- Insert into table
100: --
101: INSERT INTO JTF_BRM_WF_ATTR_VALUES
102: ( WF_ATTR_VALUE_ID
103: , PROCESS_ID
104: , WF_ITEM_TYPE
105: , WF_ACTIVITY_NAME

Line 240: -- Function : Update record in JTF_BRM_WF_ATTR_VALUES table.

236: --------------------------------------------------------------------------
237: -- Start of comments
238: -- API name : Update_WFAttrValue
239: -- Type : Private
240: -- Function : Update record in JTF_BRM_WF_ATTR_VALUES table.
241: -- Pre-reqs : None.
242: -- Parameters :
243: -- name direction type required?
244: -- ---- --------- ---- ---------

Line 319: UPDATE JTF_BRM_WF_ATTR_VALUES

315: SELECT JTF_BRM_OBJECT_VERSION_S.NEXTVAL
316: INTO l_object_version_number
317: FROM DUAL;
318:
319: UPDATE JTF_BRM_WF_ATTR_VALUES
320: SET PROCESS_ID = p_bwa_rec.PROCESS_ID
321: , WF_ITEM_TYPE = p_bwa_rec.WF_ITEM_TYPE
322: , WF_ACTIVITY_NAME = p_bwa_rec.WF_ACTIVITY_NAME
323: , WF_ACTIVITY_VERSION = p_bwa_rec.WF_ACTIVITY_VERSION

Line 412: -- Description : Delete record in JTF_BRM_WF_ATTR_VALUES table.

408: --------------------------------------------------------------------------
409: -- Start of comments
410: -- API Name : Delete_WFAttrValue
411: -- Type : Private
412: -- Description : Delete record in JTF_BRM_WF_ATTR_VALUES table.
413: -- Pre-reqs : None
414: -- Parameters :
415: -- name direction type required?
416: -- ---- --------- ---- ---------

Line 482: DELETE FROM JTF_BRM_WF_ATTR_VALUES

478: -- Initialize return status to SUCCESS
479: --
480: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
481:
482: DELETE FROM JTF_BRM_WF_ATTR_VALUES
483: WHERE WF_ATTR_VALUE_ID = p_wf_attr_value_id;
484:
485: --
486: -- Check whether delete was succesful