APPS.PER_CATEGORY_TYPES_PKG dependencies on PER_PROPOSAL_CATEGORY_TYPES

Line 39: insert into PER_PROPOSAL_CATEGORY_TYPES (

35: X_LAST_UPDATED_BY in VARCHAR2,
36: X_LAST_UPDATE_LOGIN in NUMBER
37: ) is
38: begin
39: insert into PER_PROPOSAL_CATEGORY_TYPES (
40: PROPOSAL_CATEGORY_TYPE_ID,
41: CATEGORY_NAME,
42: TYPE,
43: HEADING_TEXT,

Line 75: from PER_PROPOSAL_CATEGORY_TYPES

71: cursor CSR_CATEGORY_NAME (
72: X_PROPOSAL_CATEGORY_TYPE_ID in VARCHAR2
73: ) is
74: select CATEGORY_NAME
75: from PER_PROPOSAL_CATEGORY_TYPES
76: where PROPOSAL_CATEGORY_TYPE_ID = X_PROPOSAL_CATEGORY_TYPE_ID
77: for update of CATEGORY_NAME nowait;
78: RECINFO CSR_CATEGORY_NAME%rowtype;
79: begin

Line 103: update PER_PROPOSAL_CATEGORY_TYPES set

99: X_LAST_UPDATED_BY in VARCHAR2,
100: X_LAST_UPDATE_LOGIN in NUMBER
101: ) is
102: begin
103: update PER_PROPOSAL_CATEGORY_TYPES set
104: CATEGORY_NAME = X_CATEGORY_NAME,
105: TYPE = X_TYPE,
106: HEADING_TEXT = X_HEADING_TEXT,
107: HELP_TEXT = X_HELP_TEXT,

Line 123: delete from PER_PROPOSAL_CATEGORY_TYPES

119: procedure DELETE_ROW (
120: X_PROPOSAL_CATEGORY_TYPE_ID in NUMBER
121: ) is
122: begin
123: delete from PER_PROPOSAL_CATEGORY_TYPES
124: where PROPOSAL_CATEGORY_TYPE_ID = X_PROPOSAL_CATEGORY_TYPE_ID;
125: if (sql%notfound) then
126: raise no_data_found;
127: end if;

Line 209: update PER_PROPOSAL_CATEGORY_TYPES

205: X_LAST_UPDATE_DATE,
206: X_LAST_UPDATED_BY,
207: X_LAST_UPDATE_LOGIN
208: );
209: update PER_PROPOSAL_CATEGORY_TYPES
210: set CATEGORY_NAME = X_CATEGORY_NAME,
211: HEADING_TEXT = X_HEADING_TEXT,
212: HELP_TEXT = X_HELP_TEXT,
213: NOTE_TEXT = X_NOTE_TEXT,