APPS.PER_QUESTION_TYPES_PKG dependencies on PER_PROPOSAL_QUESTION_TYPES

Line 50: insert into PER_PROPOSAL_QUESTION_TYPES (

46: X_LAST_UPDATED_BY in VARCHAR2,
47: X_LAST_UPDATE_LOGIN in NUMBER
48: ) is
49: begin
50: insert into PER_PROPOSAL_QUESTION_TYPES (
51: PROPOSAL_QUESTION_NAME,
52: ALIGN,
53: HTML_TYPE,
54: WIDTH_SIZE,

Line 108: from PER_PROPOSAL_QUESTION_TYPES

104: cursor CSR_QUESTION_NAME (
105: X_PROPOSAL_QUESTION_NAME in VARCHAR2
106: ) is
107: select PROPOSAL_QUESTION_NAME
108: from PER_PROPOSAL_QUESTION_TYPES
109: where PROPOSAL_QUESTION_NAME = X_PROPOSAL_QUESTION_NAME
110: for update of PROPOSAL_QUESTION_NAME nowait;
111: RECINFO CSR_QUESTION_NAME%rowtype;
112: begin

Line 147: update PER_PROPOSAL_QUESTION_TYPES set

143: X_LAST_UPDATED_BY in VARCHAR2,
144: X_LAST_UPDATE_LOGIN in NUMBER
145: ) is
146: begin
147: update PER_PROPOSAL_QUESTION_TYPES set
148: ALIGN = X_ALIGN,
149: HTML_TYPE = X_HTML_TYPE,
150: WIDTH_SIZE = X_WIDTH_SIZE,
151: HEIGHT_SIZE = X_HEIGHT_SIZE,

Line 178: delete from PER_PROPOSAL_QUESTION_TYPES

174: procedure DELETE_ROW (
175: X_PROPOSAL_QUESTION_NAME in VARCHAR2
176: ) is
177: begin
178: delete from PER_PROPOSAL_QUESTION_TYPES
179: where PROPOSAL_QUESTION_NAME = X_PROPOSAL_QUESTION_NAME;
180: if (sql%notfound) then
181: raise no_data_found;
182: end if;

Line 297: update PER_PROPOSAL_QUESTION_TYPES

293: X_LAST_UPDATE_DATE,
294: X_LAST_UPDATED_BY,
295: X_LAST_UPDATE_LOGIN
296: );
297: update PER_PROPOSAL_QUESTION_TYPES
298: set DEFAULT_VALUE = X_DEFAULT_VALUE,
299: FULL_TEXT = X_FULL_TEXT,
300: QUESTION_HEADER = X_QUESTION_HEADER,
301: HELP_TEXT = X_HELP_TEXT,