APPS.OE_FND_ATTACHMENTS_PUB dependencies on OE_FND_ATTACHMENTS_PUB

Line 1: PACKAGE BODY oe_fnd_attachments_pub as

1: PACKAGE BODY oe_fnd_attachments_pub as
2: /* $Header: OEXPATTB.pls 120.0 2005/06/01 00:01:09 appldev noship $ */
3:
4:
5: G_INVALID_PARAMETER_EXCEPTION EXCEPTION;

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Oe_Fnd_Attachments_Pub';

2: /* $Header: OEXPATTB.pls 120.0 2005/06/01 00:01:09 appldev noship $ */
3:
4:
5: G_INVALID_PARAMETER_EXCEPTION EXCEPTION;
6: G_PKG_NAME CONSTANT VARCHAR2(30):= 'Oe_Fnd_Attachments_Pub';
7:
8:
9: -- public functions
10: -------------------------------------------------------------------------

Line 65: oe_debug_pub.add( 'OE_FND_ATTACHMENTS_PUB.ADD_ATTACHMENT:BEGIN' || P_ENTITY_NAME || ' , '||P_PK1_VALUE ||' , '||P_PK2_VALUE ) ;

61: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
62: --
63: BEGIN
64: IF l_debug_level > 0 THEN
65: oe_debug_pub.add( 'OE_FND_ATTACHMENTS_PUB.ADD_ATTACHMENT:BEGIN' || P_ENTITY_NAME || ' , '||P_PK1_VALUE ||' , '||P_PK2_VALUE ) ;
66: END IF;
67:
68: -- Standard call to check for call compatibility
69: -----------------------------------------------------------------------

Line 84: oe_debug_pub.add( 'OE_FND_ATTACHMENTS_PUB.ATTACHMENT EXISTS DUMMY=' || L_DUMMY ) ;

80: l_attachment_exists := TRUE; -- assume
81: open C_ATCHMT;
82: fetch C_ATCHMT into l_dummy;
83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add( 'OE_FND_ATTACHMENTS_PUB.ATTACHMENT EXISTS DUMMY=' || L_DUMMY ) ;
85: END IF;
86: if (C_ATCHMT%NOTFOUND) then
87: l_attachment_exists := FALSE;
88: close C_ATCHMT;

Line 95: oe_debug_pub.add( 'OE_FND_ATTACHMENTS_PUB.ADD_ATTACHMENT:CALLING PVT.ADD_ATTACHMENT!' ) ;

91: end if;
92:
93: if (l_attachment_exists = FALSE) then
94: IF l_debug_level > 0 THEN
95: oe_debug_pub.add( 'OE_FND_ATTACHMENTS_PUB.ADD_ATTACHMENT:CALLING PVT.ADD_ATTACHMENT!' ) ;
96: END IF;
97:
98: Oe_Fnd_Attachments_PVT.Add_Attachment(
99: p_api_version => 1.0,

Line 118: oe_debug_pub.add( 'OE_FND_ATTACHMENTS_PUB.ADD_ATTACHMENT:END' ) ;

114:
115: end if;
116:
117: IF l_debug_level > 0 THEN
118: oe_debug_pub.add( 'OE_FND_ATTACHMENTS_PUB.ADD_ATTACHMENT:END' ) ;
119: END IF;
120:
121: END Add_Attachment;
122:

Line 635: END oe_fnd_attachments_pub;

631: null;
632: END Copy_Attachments;
633:
634:
635: END oe_fnd_attachments_pub;