APPS.IGW_PROP_SCIENCE_CODES_TBH dependencies on IGW_PROP_SCIENCE_CODES

Line 1: PACKAGE BODY Igw_Prop_Science_Codes_Tbh AS

1: PACKAGE BODY Igw_Prop_Science_Codes_Tbh AS
2: /* $Header: igwtkeyb.pls 115.5 2002/11/15 00:45:24 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:

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

2: /* $Header: igwtkeyb.pls 115.5 2002/11/15 00:45:24 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_SCIENCE_CODES_TBH';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Insert_Row

Line 27: FROM igw_prop_science_codes

23: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
24:
25: CURSOR c IS
26: SELECT rowid
27: FROM igw_prop_science_codes
28: WHERE proposal_id = p_proposal_id AND
29: science_code = p_science_code;
30:
31: BEGIN

Line 47: INSERT INTO igw_prop_science_codes

43: App_Exception.Raise_Exception;
44:
45: END IF;
46:
47: INSERT INTO igw_prop_science_codes
48: (
49: proposal_id,
50: science_code,
51: record_version_number,

Line 133: UPDATE igw_prop_science_codes

129: App_Exception.Raise_Exception;
130:
131: END IF;
132:
133: UPDATE igw_prop_science_codes
134: SET science_code = p_science_code,
135: record_version_number = record_version_number + 1,
136: last_update_date = l_last_update_date,
137: last_updated_by = l_last_updated_by,

Line 181: DELETE igw_prop_science_codes

177: BEGIN
178:
179: x_return_status := Fnd_Api.G_Ret_Sts_Success;
180:
181: DELETE igw_prop_science_codes
182: WHERE rowid = p_rowid
183: AND record_version_number = p_record_version_number;
184:
185: IF SQL%NotFound THEN

Line 211: END Igw_Prop_Science_Codes_Tbh;

207: END Delete_Row;
208:
209: ---------------------------------------------------------------------------
210:
211: END Igw_Prop_Science_Codes_Tbh;