APPS.GR_ITEM_DISCLOSURES_PKG dependencies on GR_ITEM_DISCLOSURES

Line 1: PACKAGE BODY GR_ITEM_DISCLOSURES_PKG AS

1: PACKAGE BODY GR_ITEM_DISCLOSURES_PKG AS
2: /*$Header: GRHIIDB.pls 115.6 2002/10/25 20:17:06 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 91: INSERT INTO gr_item_disclosures

87: IF FND_API.To_Boolean(l_key_exists) THEN
88: RAISE Item_Exists_Error;
89: END IF;
90:
91: INSERT INTO gr_item_disclosures
92: (item_code,
93: disclosure_code,
94: print_on_document_flag,
95: minimum_reporting_level,

Line 275: UPDATE gr_item_disclosures

271:
272: IF l_return_status <> 'S' THEN
273: RAISE Foreign_Key_Error;
274: ELSE
275: UPDATE gr_item_disclosures
276: SET item_code = p_item_code,
277: disclosure_code = p_disclosure_code,
278: print_on_document_flag = p_print_on_document_flag,
279: minimum_reporting_level = p_minimum_reporting_level,

Line 394: FROM gr_item_disclosures

390:
391: CURSOR c_lock_discs
392: IS
393: SELECT *
394: FROM gr_item_disclosures
395: WHERE rowid = p_rowid
396: FOR UPDATE NOWAIT;
397: LockDiscRcd c_lock_discs%ROWTYPE;
398: BEGIN

Line 542: DELETE FROM gr_item_disclosures

538: IF l_return_status <> 'S' THEN
539: RAISE Check_Integrity_Error;
540: END IF;
541:
542: DELETE FROM gr_item_disclosures
543: WHERE rowid = p_rowid;
544:
545: /* Check the commit flag and if set, then commit the work. */
546:

Line 627: DELETE FROM gr_item_disclosures

623: x_oracle_error := 0;
624: x_msg_data := NULL;
625: l_msg_token := p_item_code;
626:
627: DELETE FROM gr_item_disclosures
628: WHERE item_code = p_item_code;
629:
630: IF FND_API.To_Boolean(p_commit) THEN
631: COMMIT WORK;

Line 846: FROM gr_item_disclosures dc

842:
843: CURSOR c_get_disclosure_rowid
844: IS
845: SELECT dc.rowid
846: FROM gr_item_disclosures dc
847: WHERE dc.item_code = p_item_code
848: AND dc.disclosure_code = p_disclosure_code;
849: DisclosureRecord c_get_disclosure_rowid%ROWTYPE;
850:

Line 881: END GR_ITEM_DISCLOSURES_PKG;

877: END IF;
878:
879: END Check_Primary_Key;
880:
881: END GR_ITEM_DISCLOSURES_PKG;