APPS.JTF_CAL_ADDR_PVT dependencies on JTF_CAL_ADDRESSES

Line 21: FROM jtf_cal_addresses

17: ** Cursor to lock the record
18: ***************************************************************************/
19: ( b_address_id IN NUMBER
20: )IS SELECT object_version_number
21: FROM jtf_cal_addresses
22: WHERE address_id = b_address_id
23: FOR UPDATE OF object_version_number NOWAIT;
24:
25: l_object_version_number NUMBER;

Line 75: -- Function : Create record in JTF_CAL_ADDRESSES table.

71: --------------------------------------------------------------------------
72: -- Start of comments
73: -- API name : Insert_Row
74: -- Type : Private
75: -- Function : Create record in JTF_CAL_ADDRESSES table.
76: -- Pre-reqs : None.
77: -- Parameters :
78: -- name direction type required?
79: -- ---- --------- ---- ---------

Line 121: FROM JTF_CAL_ADDRESSES

117:
118: CURSOR c_record_exists
119: (b_address_id NUMBER
120: )IS SELECT ROWID
121: FROM JTF_CAL_ADDRESSES
122: WHERE address_id = b_address_id;
123:
124: BEGIN
125: --

Line 159: INSERT INTO JTF_CAL_ADDRESSES

155: ------------------------------------------------------------------------
156: -- Insert into table. Generate the ID from the
157: -- sequence and return it
158: ------------------------------------------------------------------------
159: INSERT INTO JTF_CAL_ADDRESSES
160: ( ADDRESS_ID
161: , RESOURCE_ID
162: , CREATED_BY
163: , CREATION_DATE

Line 202: ( JTF_CAL_ADDRESSES_S.NEXTVAL -- returning into l_adress_id

198: , APPLICATION_ID
199: , SECURITY_GROUP_ID
200: , OBJECT_VERSION_NUMBER
201: ) VALUES
202: ( JTF_CAL_ADDRESSES_S.NEXTVAL -- returning into l_adress_id
203: , p_adr_rec.RESOURCE_ID
204: , p_adr_rec.CREATED_BY
205: , p_adr_rec.CREATION_DATE
206: , p_adr_rec.LAST_UPDATED_BY

Line 313: -- Function : Update record in JTF_CAL_ADDRESSES table.

309: --------------------------------------------------------------------------
310: -- Start of comments
311: -- API name : Update_Row
312: -- Type : Private
313: -- Function : Update record in JTF_CAL_ADDRESSES table.
314: -- Pre-reqs : None.
315: -- Parameters :
316: -- name direction type required?
317: -- ---- --------- -------- ---------

Line 386: UPDATE JTF_CAL_ADDRESSES

382: , p_adr_rec.object_version_number
383: );
384:
385:
386: UPDATE JTF_CAL_ADDRESSES
387: SET RESOURCE_ID = p_adr_rec.RESOURCE_ID
388: , LAST_UPDATED_BY = p_adr_rec.LAST_UPDATED_BY -- Needs to be set by caller
389: , LAST_UPDATE_DATE = p_adr_rec.LAST_UPDATE_DATE -- Needs to be set by caller
390: , LAST_UPDATE_LOGIN = p_adr_rec.LAST_UPDATE_LOGIN -- Needs to be set by caller

Line 494: -- Description : Soft delete record in JTF_CAL_ADDRESSES table.

490: --------------------------------------------------------------------------
491: -- Start of comments
492: -- API Name : Delete_Row
493: -- Type : Private
494: -- Description : Soft delete record in JTF_CAL_ADDRESSES table.
495: -- Pre-reqs : None
496: -- Parameters :
497: -- name direction type required?
498: -- ---- --------- ---- ---------

Line 568: UPDATE JTF_CAL_ADDRESSES

564: , p_object_version_number
565: );
566:
567:
568: UPDATE JTF_CAL_ADDRESSES
569: SET deleted_as_of = SYSDATE
570: WHERE address_id = p_address_id;
571:
572: --