APPS.IGW_PROP_ABSTRACTS_PVT dependencies on IGW_PROP_ABSTRACTS

Line 1: PACKAGE BODY Igw_Prop_Abstracts_Pvt AS

1: PACKAGE BODY Igw_Prop_Abstracts_Pvt AS
2: --$Header: igwvabsb.pls 115.6 2002/11/14 18:50:52 vmedikon ship $
3:
4: ---------------------------------------------------------------------------
5:

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

2: --$Header: igwvabsb.pls 115.6 2002/11/14 18:50:52 vmedikon ship $
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_ABSTRACTS_PVT';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Check_Lock

Line 33: FROM igw_prop_abstracts

29: IF p_rowid IS NOT NULL AND p_record_version_number IS NOT NULL THEN
30:
31: SELECT 'N'
32: INTO l_locked
33: FROM igw_prop_abstracts
34: WHERE rowid = p_rowid
35: AND record_version_number = p_record_version_number;
36:
37: END IF;

Line 66: INSERT INTO igw_prop_abstracts

62:
63: PROCEDURE Populate_Prop_Abstracts( p_proposal_id IN NUMBER ) IS
64: BEGIN
65:
66: INSERT INTO igw_prop_abstracts
67: (
68: proposal_id,
69: abstract_type,
70: abstract_type_code,

Line 95: FROM igw_prop_abstracts

91: lookup_type in ('IGW_ABSTRACT_TYPES','IGW_RESOURCE_TYPES') AND
92: (lookup_type,lookup_code) NOT IN
93: ( SELECT abstract_type,
94: abstract_type_code
95: FROM igw_prop_abstracts
96: WHERE proposal_id = p_proposal_id );
97:
98: COMMIT;
99:

Line 292: Igw_Prop_Abstracts_Tbh.Update_Row

288: /*
289: ** Invoke Table Handler to Update data
290: */
291:
292: Igw_Prop_Abstracts_Tbh.Update_Row
293: (
294: p_rowid => p_rowid,
295: p_proposal_id => l_proposal_id,
296: p_abstract_type => p_abstract_type,

Line 379: END Igw_Prop_Abstracts_Pvt;

375: END Update_Prop_Abstract;
376:
377: ---------------------------------------------------------------------------
378:
379: END Igw_Prop_Abstracts_Pvt;