APPS.WIP_WICTPG dependencies on FND_ATTACHED_DOCUMENTS

Line 286: x_purge_rec.table_name := 'FND_ATTACHED_DOCUMENTS';

282: end if;
283:
284: if ( p_option IN (REPORT_ONLY, PURGE_AND_REPORT) ) then
285: -- This procedure is used for counting only, later it will be deleted
286: x_purge_rec.table_name := 'FND_ATTACHED_DOCUMENTS';
287:
288: /* Removed commented code */
289: /* Bug 2943615 - modified wip_entity_id, org_id on the R.H.S to char
290: to avoid ORA-1722 error */

Line 293: from FND_ATTACHED_DOCUMENTS

289: /* Bug 2943615 - modified wip_entity_id, org_id on the R.H.S to char
290: to avoid ORA-1722 error */
291: select count(*)
292: into x_num_rows
293: from FND_ATTACHED_DOCUMENTS
294: WHERE PK1_VALUE = to_char(x_purge_rec.wip_entity_id)
295: AND (( PK2_VALUE = to_char(x_purge_rec.org_id)
296: AND ENTITY_NAME = 'WIP_DISCRETE_JOBS'
297: )

Line 316: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(

312: if (p_Option <> REPORT_ONLY) then
313:
314: /* Bug 6056455: (FP of 5224338) Added following if condition before calling FND API to delete attachments*/
315: if ( l_op_count > 0) then
316: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
317: X_entity_name => 'WIP_DISCRETE_OPERATIONS',
318: X_pk1_value => to_char(x_purge_rec.wip_entity_id),
319: X_pk3_value => to_char(x_purge_rec.org_id),
320: X_delete_document_flag => 'Y' );

Line 323: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(

319: X_pk3_value => to_char(x_purge_rec.org_id),
320: X_delete_document_flag => 'Y' );
321: end if;
322:
323: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
324: X_entity_name => 'WIP_DISCRETE_JOBS',
325: X_pk1_value => to_char(x_purge_rec.wip_entity_id),
326: X_pk2_value => to_char(x_purge_rec.org_id),
327: X_delete_document_flag => 'Y' );

Line 440: x_purge_rec.table_name := 'FND_ATTACHED_DOCUMENTS';

436:
437:
438: if ( p_option IN (REPORT_ONLY, PURGE_AND_REPORT) ) then
439: -- This procedure is used for counting only, later it will be deleted
440: x_purge_rec.table_name := 'FND_ATTACHED_DOCUMENTS';
441:
442: /* Removed commented code */
443: /* Bug 2943615 - modified wip_entity_id, org_id, schedule_id on the R.H.S to char
444: to avoid ORA-1722 error */

Line 447: from FND_ATTACHED_DOCUMENTS

443: /* Bug 2943615 - modified wip_entity_id, org_id, schedule_id on the R.H.S to char
444: to avoid ORA-1722 error */
445: select count(*)
446: into x_num_rows
447: from FND_ATTACHED_DOCUMENTS
448: WHERE PK1_VALUE = to_char(x_purge_rec.wip_entity_id)
449: AND PK3_VALUE = to_char(x_purge_rec.org_id)
450: AND ( ( PK2_VALUE = to_char(x_purge_rec.schedule_id)
451: AND ENTITY_NAME = 'WIP_REPETITIVE_SCHEDULES'

Line 471: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(

467:
468:
469: -- If the action type option is to purge then call the API supplied by dlane
470: if (p_Option <> REPORT_ONLY) then
471: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
472: X_entity_name => 'WIP_REPETITIVE_OPERATIONS',
473: X_pk1_value => to_char(x_purge_rec.wip_entity_id),
474: X_pk3_value => to_char(x_purge_rec.org_id),
475: X_pk4_value => to_char(x_purge_rec.schedule_id),

Line 478: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(

474: X_pk3_value => to_char(x_purge_rec.org_id),
475: X_pk4_value => to_char(x_purge_rec.schedule_id),
476: X_delete_document_flag => 'Y' );
477:
478: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
479: X_entity_name => 'WIP_REPETITIVE_SCHEDULES',
480: X_pk1_value => to_char(x_purge_rec.wip_entity_id),
481: X_pk2_value => to_char(x_purge_rec.schedule_id),
482: X_pk3_value => to_char(x_purge_rec.org_id),