APPS.ZX_VTX_USER_PKG dependencies on ZX_PRVDR_HDR_EXTNS_GT

Line 95: | attributes into ZX_PRVDR_HDR_EXTNS_GT.

91: | OUT NOCOPY
92: |
93: | DESCRIPTION
94: | This routine contains the necessary logic to populate header_level user extensible
95: | attributes into ZX_PRVDR_HDR_EXTNS_GT.
96: |
97: | SCOPE - PUBLIC
98: |
99: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 111: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%TYPE ;

107: +==========================================================================*/
108: PROCEDURE Derive_Hdr_Ext_Attr( x_error_status OUT NOCOPY VARCHAR2
109: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
110:
111: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%TYPE ;
112: l_event_class_code ZX_LINES_DET_FACTORS.Event_Class_Code%TYPE;
113: l_application_id ZX_LINES_DET_FACTORS.Application_Id%TYPE;
114: l_entity_code ZX_LINES_DET_FACTORS.Entity_Code%TYPE;
115: l_trx_id ZX_LINES_DET_FACTORS.Trx_Id%TYPE;

Line 196: FROM ZX_PRVDR_HDR_EXTNS_GT

192: l_exists_in_hdrs_gt := 0;
193: BEGIN
194: SELECT 1
195: INTO l_exists_in_hdrs_gt
196: FROM ZX_PRVDR_HDR_EXTNS_GT
197: WHERE event_class_code = l_event_class_code
198: AND application_id = l_application_id
199: AND entity_code = l_entity_code
200: AND trx_id = l_trx_id

Line 211: ZX_PRVDR_HDR_EXTNS_GT

207:
208: IF l_exists_in_hdrs_gt = 0 THEN
209: BEGIN
210: INSERT INTO
211: ZX_PRVDR_HDR_EXTNS_GT
212: (
213: EVENT_CLASS_CODE,
214: APPLICATION_ID,
215: ENTITY_CODE,

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

242: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
244: END IF;
245: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: g_string :='Not able to insert in to ZX_PRVDR_HDR_EXTNS_GT table ';
247: x_messages_tbl:=g_messages_tbl;
248: error_exception_handle(g_string);
249: return;
250: END;