APPS.IGW_PROP_QUESTIONS_TBH dependencies on IGW_PROP_QUESTIONS

Line 1: PACKAGE BODY Igw_Prop_Questions_Tbh AS

1: PACKAGE BODY Igw_Prop_Questions_Tbh AS
2: /* $Header: igwtpqeb.pls 115.6 2002/11/15 00:44:16 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:

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

2: /* $Header: igwtpqeb.pls 115.6 2002/11/15 00:44:16 ashkumar ship $ */
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_PROP_QUESTIONS_TBH';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Insert_Row

Line 30: FROM igw_prop_questions

26: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
27:
28: CURSOR c IS
29: SELECT rowid
30: FROM igw_prop_questions
31: WHERE proposal_id = p_proposal_id AND
32: question_number = p_question_number;
33:
34: BEGIN

Line 50: INSERT INTO igw_prop_questions

46: App_Exception.Raise_Exception;
47:
48: END IF;
49:
50: INSERT INTO igw_prop_questions
51: (
52: proposal_id,
53: question_number,
54: answer,

Line 145: UPDATE igw_prop_questions

141: App_Exception.Raise_Exception;
142:
143: END IF;
144:
145: UPDATE igw_prop_questions
146: SET question_number = p_question_number,
147: answer = p_answer,
148: explanation = p_explanation,
149: review_date = p_review_date,

Line 183: END Igw_Prop_Questions_Tbh;

179: END Update_Row;
180:
181: ---------------------------------------------------------------------------
182:
183: END Igw_Prop_Questions_Tbh;