APPS.IGW_REPORT_PROCESSING dependencies on IGW_PROP_ABSTRACTS

Line 162: delete from igw_prop_abstracts

158: and version_id = l_version_id;
159:
160: /*
161: --deleting inserted abstract into table igw_prop_abstracats
162: delete from igw_prop_abstracts
163: where proposal_id = p_proposal_id
164: and abstract_type_code = 'C.1'
165: and abstract_type = 'IGW_ABSTRACT_TYPES';
166: */

Line 230: insert into igw_prop_abstracts(

226: fnd_global.local_chr(10)||rec_report_justification.justification;
227: END LOOP; --rec_report_justification
228:
229: l_proposal_budget_just := nvl(substr(l_proposal_budget_just,1,4000),'NULL');
230: insert into igw_prop_abstracts(
231: proposal_id
232: ,abstract_type_code
233: ,abstract
234: ,abstract_type

Line 285: delete from igw_prop_abstracts

281:
282:
283: BEGIN
284: --deleting inserted abstract into table igw_prop_abstracats
285: delete from igw_prop_abstracts
286: where proposal_id = p_proposal_id
287: and abstract_type_code = 'C.1'
288: and abstract_type = 'IGW_ABSTRACT_TYPES';
289:

Line 297: insert into igw_prop_abstracts(

293: fnd_global.local_chr(10)||rec_report_justification.justification;
294: END LOOP; --rec_report_justification
295:
296: l_proposal_budget_just := nvl(substr(l_proposal_budget_just,1,4000),'NULL');
297: insert into igw_prop_abstracts(
298: proposal_id
299: ,abstract_type_code
300: ,abstract
301: ,abstract_type

Line 1024: from igw_prop_abstracts

1020: v_abstract varchar2(4000):=null;
1021:
1022: cursor c is
1023: select abstract
1024: from igw_prop_abstracts
1025: where proposal_id = p_proposal_id
1026: and abstract_type_code = p_abstract_type_code;
1027:
1028: begin