DBA Data[Home] [Help]

APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on ENG_ATTACHMENT_IMPLEMENTATION

Line 1: package body ENG_ATTACHMENT_IMPLEMENTATION as

1: package body ENG_ATTACHMENT_IMPLEMENTATION as
2: /*$Header: ENGUATTB.pls 120.22.12010000.2 2010/02/03 08:02:06 maychen ship $ */
3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) :=

Line 6: 'ENG_ATTACHMENT_IMPLEMENTATION' ;

2: /*$Header: ENGUATTB.pls 120.22.12010000.2 2010/02/03 08:02:06 maychen ship $ */
3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) :=
6: 'ENG_ATTACHMENT_IMPLEMENTATION' ;
7: -- For Debug
8: g_debug_file UTL_FILE.FILE_TYPE ;
9: g_debug_flag BOOLEAN := FALSE ; -- For TEST : FALSE ;
10: g_output_dir VARCHAR2(80) := NULL ;

Line 273: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Update_Attachment_Status log');

269: -- commit;
270:
271: -- Write debug message if debug mode is on
272: IF g_debug_flag THEN
273: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Update_Attachment_Status log');
274: Write_Debug('-----------------------------------------------------');
275: Write_Debug('p_change_id : ' || p_change_id );
276: Write_Debug('p_approval_status : ' || p_approval_status );
277: Write_Debug('-----------------------------------------------------');

Line 805: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Implement_Attachment_Change log');

801: END IF ;
802:
803: -- Write debug message if debug mode is on
804: IF g_debug_flag THEN
805: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Implement_Attachment_Change log');
806: Write_Debug('-----------------------------------------------------');
807: Write_Debug('p_change_id : ' || p_change_id );
808: Write_Debug('p_rev_item_seq_id : ' || p_rev_item_seq_id );
809: Write_Debug('-----------------------------------------------------');

Line 1087: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Implement_Attachment_Change log');

1083: END IF ;
1084:
1085: -- Write debug message if debug mode is on
1086: IF g_debug_flag THEN
1087: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Implement_Attachment_Change log');
1088: Write_Debug('-----------------------------------------------------');
1089: Write_Debug('p_source_attachment_id : ' || p_source_attachment_id );
1090: Write_Debug('p_source_status : ' || p_source_status );
1091: Write_Debug('p_dest_entity_name : ' || p_dest_entity_name );

Line 1311: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Complete_Attachment_Approval log');

1307: END IF ;
1308:
1309: -- Write debug message if debug mode is on
1310: IF g_debug_flag THEN
1311: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Complete_Attachment_Approval log');
1312: Write_Debug('-----------------------------------------------------');
1313: Write_Debug('p_change_id : ' || p_change_id );
1314: Write_Debug('p_approval_status : ' || p_approval_status );
1315: Write_Debug('-----------------------------------------------------');

Line 1449: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.COpy_Attachments_And_Changes log');

1445: END IF ;
1446:
1447: -- Write debug message if debug mode is on
1448: IF g_debug_flag THEN
1449: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.COpy_Attachments_And_Changes log');
1450: Write_Debug('-----------------------------------------------------');
1451: Write_Debug('p_change_id : ' || p_change_id );
1452: Write_Debug('p_rev_item_seq_id : ' || p_rev_item_seq_id );
1453: Write_Debug('p_org_id : ' || p_org_id );

Line 1645: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Migrate_Attachment_And_Change log');

1641: END IF ;
1642:
1643: -- Write debug message if debug mode is on
1644: IF g_debug_flag THEN
1645: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Migrate_Attachment_And_Change log');
1646: Write_Debug('-----------------------------------------------------');
1647: Write_Debug('p_change_id : ' || p_change_id );
1648: Write_Debug('p_rev_item_seq_id : ' || p_rev_item_seq_id );
1649: Write_Debug('p_org_id : ' || p_org_id );

Line 1859: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Attachments_And_Changes log');

1855: END IF ;
1856:
1857: -- Write debug message if debug mode is on
1858: IF g_debug_flag THEN
1859: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Attachments_And_Changes log');
1860: Write_Debug('-----------------------------------------------------');
1861: Write_Debug('p_change_id : ' || p_change_id );
1862: Write_Debug('p_rev_item_seq_id : ' || p_rev_item_seq_id );
1863: Write_Debug('p_org_id : ' || p_org_id );

Line 1984: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Attachment_For_Curr_CO log');

1980: END IF ;
1981:
1982: -- Write debug message if debug mode is on
1983: IF g_debug_flag THEN
1984: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Attachment_For_Curr_CO log');
1985: Write_Debug('-----------------------------------------------------');
1986: Write_Debug('p_change_id : ' || p_change_id );
1987: Write_Debug('p_rev_item_seq_id : ' || p_rev_item_seq_id );
1988: Write_Debug('-----------------------------------------------------');

Line 2122: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Attachments log');

2118: END IF ;
2119:
2120: -- Write debug message if debug mode is on
2121: IF g_debug_flag THEN
2122: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Attachments log');
2123: Write_Debug('-----------------------------------------------------');
2124: Write_Debug('p_org_id : ' || p_org_id );
2125: Write_Debug('p_inv_item_id : ' || p_inv_item_id );
2126: Write_Debug('p_revision_id : ' || p_revision_id );

Line 2232: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Attachment log');

2228: END IF ;
2229:
2230: -- Write debug message if debug mode is on
2231: IF g_debug_flag THEN
2232: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Attachment log');
2233: Write_Debug('-----------------------------------------------------');
2234: Write_Debug('p_attachment_id : ' || p_attachment_id );
2235: Write_Debug('-----------------------------------------------------');
2236: Write_Debug('Initializing return status... ' );

Line 2343: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Changes log');

2339: END IF ;
2340:
2341: -- Write debug message if debug mode is on
2342: IF g_debug_flag THEN
2343: Write_Debug('ENG_ATTACHMENT_IMPLEMENTATION.Delete_Changes log');
2344: Write_Debug('-----------------------------------------------------');
2345: Write_Debug('p_change_id : ' || p_change_id );
2346: Write_Debug('p_rev_item_seq_id : ' || p_rev_item_seq_id );
2347: Write_Debug('-----------------------------------------------------');

Line 2520: END ENG_ATTACHMENT_IMPLEMENTATION;

2516:
2517: END Validate_floating_version;
2518:
2519:
2520: END ENG_ATTACHMENT_IMPLEMENTATION;