APPS.ZX_API_PUB dependencies on DUAL

Line 892: --from dual;

888: +-----------------------------------------*/
889: --Bug 7650433
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 949: from dual;

945:
946: --Bug 7650433
947: select ZX_LINES_DET_FACTORS_S.nextval
948: into l_event_id
949: from dual;
950:
951: IF l_evnt_cls.event_class_code(i) = 'CREDIT_MEMO' THEN
952: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'Y';
953: END IF;

Line 1647: from dual;

1643:
1644: /*Fetch the event id for the document*/
1645: select ZX_LINES_DET_FACTORS_S.nextval
1646: into l_event_class_rec.event_id
1647: from dual;
1648:
1649: /*Populate the event class record structure*/
1650: IF G_DATA_TRANSFER_MODE = 'PLS' THEN
1651: l_event_class_rec.INTERNAL_ORGANIZATION_ID := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(1);

Line 2494: --from dual;

2490: +-----------------------------------------*/
2491: --Bug 7650433
2492: --select ZX_LINES_DET_FACTORS_S.nextval
2493: --into l_event_id
2494: --from dual;
2495:
2496: OPEN event_classes;
2497: LOOP
2498: FETCH event_classes BULK COLLECT INTO

Line 2583: from dual;

2579: LOOP
2580: --Bug 7650433
2581: select ZX_LINES_DET_FACTORS_S.nextval
2582: into l_event_id
2583: from dual;
2584: -- added for bug fix 5417887
2585: IF l_evnt_cls.event_class_code(i) = 'CREDIT_MEMO' THEN
2586: ZX_GLOBAL_STRUCTURES_PKG.g_credit_memo_exists_flg := 'Y';
2587: END IF;

Line 3131: FROM dual;

3127: +--------------------------------------------------*/
3128: /*Retrieve the sequence id since it has to be same for all updated rows*/
3129: select ZX_LINES_DET_FACTORS_S.nextval
3130: INTO l_event_class_rec.event_id
3131: FROM dual;
3132:
3133: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3134: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
3135: 'application_id: '||to_char(p_sync_trx_rec.application_id)||

Line 4584: from dual;

4580: | Get the event id for the whole document |
4581: +-----------------------------------------*/
4582: select ZX_LINES_DET_FACTORS_S.nextval
4583: into l_event_class_rec.event_id
4584: from dual;
4585:
4586: /*------------------------------------------------------+
4587: | Validate Input Paramerters and Fetch Tax Options |
4588: +------------------------------------------------------*/

Line 4915: from dual;

4911: | Get the event id for the whole document |
4912: +-----------------------------------------*/
4913: select zx_lines_det_factors_s.nextval
4914: into l_event_class_rec.event_id
4915: from dual;
4916:
4917: /*------------------------------------------------------+
4918: | Validate Input Paramerters and Fetch Tax Options |
4919: +------------------------------------------------------*/

Line 5264: --from dual;

5260: +-----------------------------------------*/
5261: --Bug 7650433
5262: --select ZX_LINES_DET_FACTORS_S.nextval
5263: --into l_event_id
5264: --from dual;
5265:
5266: /*------------------------------------------------+
5267: | Update zx_lines_det_factors |
5268: +------------------------------------------------*/

Line 5327: from dual;

5323: LOOP
5324: --Bug 7650433
5325: select ZX_LINES_DET_FACTORS_S.nextval
5326: into l_event_id
5327: from dual;
5328:
5329: -- Changed code to bulk collection for Bug#14613482 --
5330: OPEN c_event_info(l_evnt_cls.application_id(i),
5331: l_evnt_cls.entity_code(i),

Line 6423: from dual;

6419: | Get the event id for the whole document |
6420: +-----------------------------------------*/
6421: select ZX_LINES_DET_FACTORS_S.nextval
6422: into l_event_class_rec.event_id
6423: from dual;
6424:
6425: /*------------------------------------------------+
6426: | Update zx_lines_det_factors |
6427: +------------------------------------------------*/

Line 9861: FROM dual;

9857:
9858: IF NOT(l_record_exists) THEN
9859: SELECT ZX_LINES_DET_FACTORS_S.nextval
9860: INTO l_event_class_rec.event_id
9861: FROM dual;
9862: END IF;
9863:
9864: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9865: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 10234: FROM dual;

10230: +-----------------------------------------------------------------------------------------*/
10231: IF NOT(l_record_exists) THEN
10232: SELECT ZX_LINES_DET_FACTORS_S.nextval
10233: INTO l_event_class_rec.event_id
10234: FROM dual;
10235: END IF;
10236:
10237: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
10238: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,

Line 12581: FROM dual;

12577:
12578: IF NOT(l_record_exists) THEN
12579: SELECT zx_lines_det_factors_s.nextval
12580: INTO l_event_class_rec.event_id
12581: FROM dual;
12582: END IF;
12583:
12584: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
12585: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,