DBA Data[Home] [Help]

APPS.ZX_NEW_SERVICES_PKG dependencies on DUAL

Line 937: FROM dual;

933: | Get the event id for the whole document |
934: +-----------------------------------------*/
935: SELECT ZX_LINES_DET_FACTORS_S.NEXTVAL
936: INTO l_event_class_rec.event_id
937: FROM dual;
938:
939: /*------------------------------------------------+
940: | Update zx_lines_det_factors |
941: +------------------------------------------------*/

Line 1221: from dual;

1217: END IF;
1218:
1219: select ZX_LINES_DET_FACTORS_S.nextval
1220: into l_event_id
1221: from dual;
1222:
1223: l_event_class_rec.EVENT_ID := l_event_id;
1224: l_event_class_rec.INTERNAL_ORGANIZATION_ID := l_evnt_cls.internal_organization_id(1);
1225: l_event_class_rec.APPLICATION_ID := l_evnt_cls.application_id(1);

Line 2883: -- Assuming that tax only lines cannot be discarded individually.

2879: END IF; --IF p_trx_line_id IS NOT NULL THEN
2880: END IF; --l_count <> 0
2881:
2882: -- Discard Tax Only Lines if any for the complete invoice alone
2883: -- Assuming that tax only lines cannot be discarded individually.
2884: IF p_tax_only_line_flag = 'Y' AND p_trx_line_id IS NULL THEN
2885:
2886: ZX_API_PUB.discard_tax_only_lines
2887: ( p_api_version => p_api_version,