APPS.ZX_TAXWARE_USER_PKG dependencies on ZX_PRVDR_HDR_EXTNS_GT

Line 106: | attributes into ZX_PRVDR_HDR_EXTNS_GT.

102: | OUT NOCOPY
103: |
104: | DESCRIPTION
105: | This routine contains the necessary logic to populate header_level user extensible
106: | attributes into ZX_PRVDR_HDR_EXTNS_GT.
107: |
108: | SCOPE - PUBLIC
109: |
110: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 122: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%TYPE ;

118: +==========================================================================*/
119: PROCEDURE Derive_Hdr_Ext_Attr( x_error_status OUT NOCOPY VARCHAR2
120: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
121:
122: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%TYPE ;
123: l_event_class_code ZX_LINES_DET_FACTORS.Event_Class_Code%TYPE;
124: l_application_id ZX_LINES_DET_FACTORS.Application_Id%TYPE;
125: l_entity_code ZX_LINES_DET_FACTORS.Entity_Code%TYPE;
126: l_trx_id ZX_LINES_DET_FACTORS.Trx_Id%TYPE;

Line 205: FROM ZX_PRVDR_HDR_EXTNS_GT

201: l_exists_in_hdrs_gt := 0;
202: BEGIN
203: SELECT 1
204: INTO l_exists_in_hdrs_gt
205: FROM ZX_PRVDR_HDR_EXTNS_GT
206: WHERE event_class_code = l_event_class_code
207: AND application_id = l_application_id
208: AND entity_code = l_entity_code
209: AND trx_id = l_trx_id

Line 220: ZX_PRVDR_HDR_EXTNS_GT

216:
217: IF l_exists_in_hdrs_gt = 0 THEN
218: BEGIN
219: INSERT INTO
220: ZX_PRVDR_HDR_EXTNS_GT
221: (
222: EVENT_CLASS_CODE,
223: APPLICATION_ID,
224: ENTITY_CODE,

Line 255: g_string :='Not able to insert in to ZX_PRVDR_HDR_EXTNS_GT table ';

251: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
252: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
253: END IF;
254: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: g_string :='Not able to insert in to ZX_PRVDR_HDR_EXTNS_GT table ';
256: x_messages_tbl:=g_messages_tbl;
257: error_exception_handle(g_string);
258: return;
259: END;