APPS.PER_OFFER_PARAGRAPHS_PKG dependencies on PER_PROPOSAL_OFFER_PARAGRAPHS

Line 34: insert into PER_PROPOSAL_OFFER_PARAGRAPHS (

30: X_LAST_UPDATED_BY in VARCHAR2,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: begin
34: insert into PER_PROPOSAL_OFFER_PARAGRAPHS (
35: PARAGRAPH_NO,
36: BODY_TEXT,
37: CREATION_DATE,
38: CREATED_BY,

Line 60: from PER_PROPOSAL_OFFER_PARAGRAPHS

56: cursor CSR_BODY_TEXT (
57: X_PARAGRAPH_NO in VARCHAR2
58: ) is
59: select PARAGRAPH_NO
60: from PER_PROPOSAL_OFFER_PARAGRAPHS
61: where PARAGRAPH_NO = X_PARAGRAPH_NO
62: for update of PARAGRAPH_NO nowait;
63: RECINFO CSR_BODY_TEXT%rowtype;
64: begin

Line 83: update PER_PROPOSAL_OFFER_PARAGRAPHS set

79: X_LAST_UPDATED_BY in VARCHAR2,
80: X_LAST_UPDATE_LOGIN in NUMBER
81: ) is
82: begin
83: update PER_PROPOSAL_OFFER_PARAGRAPHS set
84: BODY_TEXT = X_BODY_TEXT,
85: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
86: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
87: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 98: delete from PER_PROPOSAL_OFFER_PARAGRAPHS

94: procedure DELETE_ROW (
95: X_PARAGRAPH_NO in VARCHAR2
96: ) is
97: begin
98: delete from PER_PROPOSAL_OFFER_PARAGRAPHS
99: where PARAGRAPH_NO = X_PARAGRAPH_NO;
100: if (sql%notfound) then
101: raise no_data_found;
102: end if;

Line 165: update PER_PROPOSAL_OFFER_PARAGRAPHS

161: X_LAST_UPDATE_DATE,
162: X_LAST_UPDATED_BY,
163: X_LAST_UPDATE_LOGIN
164: );
165: update PER_PROPOSAL_OFFER_PARAGRAPHS
166: set BODY_TEXT = X_BODY_TEXT,
167: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
168: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
169: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN