APPS.ZX_API_PUB dependencies on DUAL

Line 892: from dual;

888: | Get the event id for the whole document |
889: +-----------------------------------------*/
890: select ZX_LINES_DET_FACTORS_S.nextval
891: into l_event_id
892: from dual;
893:
894: OPEN event_classes;
895: LOOP
896: FETCH event_classes BULK COLLECT INTO

Line 1493: from dual;

1489:
1490: /*Fetch the event id for the document*/
1491: select ZX_LINES_DET_FACTORS_S.nextval
1492: into l_event_class_rec.event_id
1493: from dual;
1494:
1495: /*Populate the event class record structure*/
1496: IF G_DATA_TRANSFER_MODE = 'PLS' THEN
1497: l_event_class_rec.INTERNAL_ORGANIZATION_ID := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(1);

Line 2229: from dual;

2225: | Get the event id for the whole document |
2226: +-----------------------------------------*/
2227: select zx_lines_det_factors_s.nextval
2228: into l_event_id
2229: from dual;
2230:
2231: OPEN event_classes;
2232: LOOP
2233: FETCH event_classes BULK COLLECT INTO

Line 2653: FROM dual;

2649: +--------------------------------------------------*/
2650: /*Retrieve the sequence id since it has to be same for all updated rows*/
2651: select ZX_LINES_DET_FACTORS_S.nextval
2652: INTO l_event_class_rec.event_id
2653: FROM dual;
2654:
2655: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2657: 'application_id: '||to_char(p_sync_trx_rec.application_id)||

Line 3935: from dual;

3931: | Get the event id for the whole document |
3932: +-----------------------------------------*/
3933: select ZX_LINES_DET_FACTORS_S.nextval
3934: into l_event_class_rec.event_id
3935: from dual;
3936:
3937: /*------------------------------------------------------+
3938: | Validate Input Paramerters and Fetch Tax Options |
3939: +------------------------------------------------------*/

Line 4264: from dual;

4260: | Get the event id for the whole document |
4261: +-----------------------------------------*/
4262: select zx_lines_det_factors_s.nextval
4263: into l_event_class_rec.event_id
4264: from dual;
4265:
4266: /*------------------------------------------------------+
4267: | Validate Input Paramerters and Fetch Tax Options |
4268: +------------------------------------------------------*/

Line 4599: from dual;

4595: | Get the event id for the whole document |
4596: +-----------------------------------------*/
4597: select ZX_LINES_DET_FACTORS_S.nextval
4598: into l_event_id
4599: from dual;
4600:
4601: /*------------------------------------------------+
4602: | Update zx_lines_det_factors |
4603: +------------------------------------------------*/

Line 5465: from dual;

5461: | Get the event id for the whole document |
5462: +-----------------------------------------*/
5463: select ZX_LINES_DET_FACTORS_S.nextval
5464: into l_event_class_rec.event_id
5465: from dual;
5466:
5467: /*------------------------------------------------+
5468: | Update zx_lines_det_factors |
5469: +------------------------------------------------*/

Line 8776: FROM dual;

8772:
8773: IF NOT(l_record_exists) THEN
8774: SELECT ZX_LINES_DET_FACTORS_S.nextval
8775: INTO l_event_class_rec.event_id
8776: FROM dual;
8777: END IF;
8778:
8779: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8780: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 9147: FROM dual;

9143: +-----------------------------------------------------------------------------------------*/
9144: IF NOT(l_record_exists) THEN
9145: SELECT ZX_LINES_DET_FACTORS_S.nextval
9146: INTO l_event_class_rec.event_id
9147: FROM dual;
9148: END IF;
9149:
9150: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
9151: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 11479: FROM dual;

11475:
11476: IF NOT(l_record_exists) THEN
11477: SELECT zx_lines_det_factors_s.nextval
11478: INTO l_event_class_rec.event_id
11479: FROM dual;
11480: END IF;
11481:
11482: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
11483: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,