APPS.GR_ORGANIZATION_CONTACTS_PKG dependencies on GR_ORGANIZATION_CONTACTS

Line 1: PACKAGE BODY GR_ORGANIZATION_CONTACTS_PKG AS

1: PACKAGE BODY GR_ORGANIZATION_CONTACTS_PKG AS
2: /*$Header: GRHIORCB.pls 115.6 2002/10/28 17:00:20 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 93: INSERT INTO gr_organization_contacts

89: IF FND_API.To_Boolean(l_key_exists) THEN
90: RAISE Item_Exists_Error;
91: END IF;
92:
93: INSERT INTO gr_organization_contacts
94: (orgn_code,
95: daytime_contact_name,
96: daytime_telephone,
97: daytime_extension,

Line 295: UPDATE gr_organization_contacts

291:
292: IF l_return_status <> 'S' THEN
293: RAISE Foreign_Key_Error;
294: ELSE
295: UPDATE gr_organization_contacts
296: SET orgn_code = p_orgn_code,
297: daytime_contact_name = p_daytime_contact_name,
298: daytime_telephone = p_daytime_telephone,
299: daytime_extension = p_daytime_extension,

Line 428: FROM gr_organization_contacts

424:
425: CURSOR c_lock_orgn_contacts
426: IS
427: SELECT *
428: FROM gr_organization_contacts
429: WHERE rowid = p_rowid
430: FOR UPDATE NOWAIT;
431: LockContactRcd c_lock_orgn_contacts%ROWTYPE;
432:

Line 585: DELETE FROM gr_organization_contacts

581: IF l_return_status <> 'S' THEN
582: RAISE Check_Integrity_Error;
583: END IF;
584:
585: DELETE FROM gr_organization_contacts
586: WHERE rowid = p_rowid;
587:
588: /* Check the commit flag and if set, then commit the work. */
589:

Line 820: FROM gr_organization_contacts orc

816:
817: CURSOR c_get_orgn_contacts_rowid
818: IS
819: SELECT orc.rowid
820: FROM gr_organization_contacts orc
821: WHERE orc.orgn_code = p_orgn_code;
822: ContactRecord c_get_orgn_contacts_rowid%ROWTYPE;
823:
824: BEGIN

Line 854: END GR_ORGANIZATION_CONTACTS_PKG;

850: END IF;
851:
852: END Check_Primary_Key;
853:
854: END GR_ORGANIZATION_CONTACTS_PKG;