APPS.IBY_FNDCPT_TRXN_PUB dependencies on DUAL

Line 1281: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;

1277: -- test_debug('l_segment_id: '|| l_segment_id);
1278: -- test_debug('l_encrypted: '|| l_encrypted);
1279: -- test_debug('l_sec_code: '|| l_sec_code);
1280:
1281: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;
1282:
1283: INSERT INTO iby_fndcpt_tx_extensions
1284: (trxn_extension_id, payment_channel_code, ext_payer_id,
1285: instr_assignment_id, origin_application_id, instrument_security_code,

Line 2588: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;

2584: IF (NOT Extension_Valid(l_pmt_channel,l_extension,FALSE,
2585: l_consumed_cvv2)) THEN
2586: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
2587: ELSE
2588: SELECT iby_fndcpt_tx_extensions_s.NEXTVAL INTO x_entity_id FROM DUAL;
2589: -- Bug: 8612180
2590: -- Insert PSON Number from parent record when copying transaction extension.
2591: INSERT INTO iby_fndcpt_tx_extensions
2592: (trxn_extension_id, payment_channel_code,

Line 2754: SELECT trunc(DBMS_RANDOM.VALUE(1000,9999)) INTO l_random_val FROM dual;

2750: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2751: iby_debug_pub.add('p_segment_id = '|| p_segment_id,G_LEVEL_STATEMENT,l_dbg_mod);
2752: END IF;
2753: IF (p_segment_id IS NOT NULL) THEN
2754: SELECT trunc(DBMS_RANDOM.VALUE(1000,9999)) INTO l_random_val FROM dual;
2755:
2756: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2757: iby_debug_pub.add('Updating the security code with random value.',
2758: G_LEVEL_STATEMENT,l_dbg_mod);

Line 5077: FROM DUAL;

5073:
5074: -- insert row into IBY_TANGIBLE
5075: SELECT IBY_TANGIBLE_S.NEXTVAL
5076: INTO l_mtangible
5077: FROM DUAL;
5078:
5079: print_debuginfo(l_module_name, 'Got MTtangible Id '
5080: ||l_mtangible);
5081: