APPS.IGW_PROP_QUESTIONS_PVT dependencies on IGW_PROP_QUESTIONS

Line 1: PACKAGE BODY Igw_Prop_Questions_Pvt AS

1: PACKAGE BODY Igw_Prop_Questions_Pvt AS
2: --$Header: igwvpqeb.pls 115.5 2002/11/15 00:44:01 ashkumar ship $
3:
4: ---------------------------------------------------------------------------
5:

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

2: --$Header: igwvpqeb.pls 115.5 2002/11/15 00:44:01 ashkumar ship $
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_QUESTIONS_PVT';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Check_Lock

Line 33: FROM igw_prop_questions

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_questions
34: WHERE rowid = p_rowid
35: AND record_version_number = p_record_version_number;
36:
37: END IF;

Line 149: INSERT INTO igw_prop_questions

145:
146: PROCEDURE Populate_Prop_Questions( p_proposal_id IN NUMBER ) IS
147: BEGIN
148:
149: INSERT INTO igw_prop_questions
150: (
151: proposal_id,
152: question_number,
153: answer,

Line 179: FROM igw_prop_questions

175: SYSDATE >= start_date_active AND
176: (SYSDATE <= end_date_active OR end_date_active IS NULL) AND
177: question_number NOT IN
178: ( SELECT question_number
179: FROM igw_prop_questions
180: WHERE proposal_id = p_proposal_id );
181:
182: COMMIT;
183:

Line 329: Igw_Prop_Questions_Tbh.Update_Row

325: /*
326: ** Invoke Table Handler to Update data
327: */
328:
329: Igw_Prop_Questions_Tbh.Update_Row
330: (
331: p_rowid => p_rowid,
332: p_record_version_number => p_record_version_number,
333: p_proposal_id => l_proposal_id,

Line 401: END Igw_Prop_Questions_Pvt;

397: END Update_Prop_Question;
398:
399: ---------------------------------------------------------------------------
400:
401: END Igw_Prop_Questions_Pvt;