APPS.IGW_PROP_ABSTRACTS_TBH dependencies on IGW_PROP_ABSTRACTS

Line 1: PACKAGE BODY Igw_Prop_Abstracts_Tbh AS

1: PACKAGE BODY Igw_Prop_Abstracts_Tbh AS
2: /* $Header: igwtabsb.pls 115.6 2002/11/14 18:51:19 vmedikon ship $ */
3:
4: ---------------------------------------------------------------------------
5:

Line 6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_ABSTRACTS_TBH';

2: /* $Header: igwtabsb.pls 115.6 2002/11/14 18:51:19 vmedikon ship $ */
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_ABSTRACTS_TBH';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Insert_Row

Line 45: FROM igw_prop_abstracts

41: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
42:
43: CURSOR c IS
44: SELECT rowid
45: FROM igw_prop_abstracts
46: WHERE proposal_id = p_proposal_id AND
47: abstract_type = p_abstract_type AND
48: abstract_type_code = p_abstract_type_code;
49:

Line 66: INSERT INTO igw_prop_abstracts

62: App_Exception.Raise_Exception;
63:
64: END IF;
65:
66: INSERT INTO igw_prop_abstracts
67: (
68: proposal_id,
69: abstract_type,
70: abstract_type_code,

Line 206: UPDATE igw_prop_abstracts

202: App_Exception.Raise_Exception;
203:
204: END IF;
205:
206: UPDATE igw_prop_abstracts
207: SET proposal_id = p_proposal_id,
208: abstract_type = p_abstract_type,
209: abstract_type_code = p_abstract_type_code,
210: abstract = p_abstract,

Line 260: END Igw_Prop_Abstracts_Tbh;

256: END Update_Row;
257:
258: ---------------------------------------------------------------------------
259:
260: END Igw_Prop_Abstracts_Tbh;