APPS.GR_RECIPIENT_INFO_PKG dependencies on GR_RECIPIENT_INFO

Line 1: PACKAGE BODY GR_RECIPIENT_INFO_PKG AS

1: PACKAGE BODY GR_RECIPIENT_INFO_PKG AS
2: /*$Header: GRHIRECB.pls 115.6 2002/10/25 17:22:14 gkelly ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 160: INSERT INTO gr_recipient_info

156: IF FND_API.To_Boolean(l_key_exists) THEN
157: RAISE Label_Exists_Error;
158: END IF;
159:
160: INSERT INTO gr_recipient_info
161: (recipient_code,
162: recipient_name,
163: document_code,
164: territory_code,

Line 493: UPDATE gr_recipient_info

489:
490: IF l_return_status <> 'S' THEN
491: RAISE Foreign_Key_Error;
492: ELSE
493: UPDATE gr_recipient_info
494: SET recipient_code = p_recipient_code,
495: recipient_name = p_recipient_name,
496: document_code = p_document_code,
497: territory_code = p_territory_code,

Line 688: FROM gr_recipient_info

684:
685: CURSOR c_lock_recipient
686: IS
687: SELECT last_update_date
688: FROM gr_recipient_info
689: WHERE rowid = p_rowid
690: FOR UPDATE NOWAIT;
691: LockRecipientRcd c_lock_recipient%ROWTYPE;
692:

Line 921: DELETE FROM gr_recipient_info

917: IF l_return_status <> 'S' THEN
918: RAISE Check_Integrity_Error;
919: END IF;
920:
921: DELETE FROM gr_recipient_info
922: WHERE rowid = p_rowid;
923:
924: /* Check the commit flag and if set, then commit the work. */
925:

Line 1309: FROM gr_recipient_info rec

1305:
1306: CURSOR c_get_recipient_rowid
1307: IS
1308: SELECT rec.rowid
1309: FROM gr_recipient_info rec
1310: WHERE rec.recipient_code = p_recipient_code;
1311: RecipientRecord c_get_recipient_rowid%ROWTYPE;
1312:
1313: BEGIN

Line 1342: END GR_RECIPIENT_INFO_PKG;

1338: END IF;
1339:
1340: END Check_Primary_Key;
1341:
1342: END GR_RECIPIENT_INFO_PKG;