APPS.DPP_TRANSACTION_PVT dependencies on DUAL

Line 106: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;

102: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_NULL';
103: RAISE Fnd_Api.G_EXC_ERROR;
104: END IF;
105:
106: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;
107:
108: mo_global.set_org_access( null,l_value,'M');
109:
110:

Line 559: FROM dual;

555: --Validation part in Create Header
556: BEGIN
557: SELECT dpp_transaction_hdr_id_seq.nextval
558: INTO p_txn_header_rec_type.transaction_header_id
559: FROM dual;
560: EXCEPTION
561: WHEN no_data_found THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');

Line 578: FROM dual;

574: --Get transaction Number from sequence
575: BEGIN
576: SELECT dpp_transaction_number_seq.nextval
577: INTO p_txn_header_rec_type.transaction_number
578: FROM dual;
579:
580: EXCEPTION
581: WHEN no_data_found THEN
582: x_return_status := fnd_api.g_ret_sts_error;

Line 889: FROM dual;

885: --Get transaction line id from sequence
886: BEGIN
887: SELECT dpp_transaction_line_id_seq.nextval
888: INTO p_txn_lines_tbl_type(i).transaction_line_id
889: FROM dual;
890:
891: EXCEPTION
892: WHEN no_data_found THEN
893: x_return_status := fnd_api.g_ret_sts_error;

Line 1533: FROM dual;

1529:
1530:
1531: SELECT fnd_profile.VALUE('DPP_NEW_PRICE_DECIMAL_PRECISION')
1532: INTO l_rounding
1533: FROM dual;
1534:
1535: IF l_rounding IS NULL THEN
1536: l_rounding := 4;
1537: END IF;

Line 2784: FROM dual;

2780: END IF;
2781:
2782: SELECT fnd_profile.VALUE('DPP_AUDIT_ENABLED')
2783: INTO l_log_enabled
2784: FROM dual;
2785:
2786: IF DPP_DEBUG_HIGH_ON THEN
2787: fnd_file.put_line(fnd_file.log, 'Audit Enabled '||l_log_enabled );
2788: END IF;

Line 3501: FROM dual;

3497:
3498: IF l_transaction_int_header_id IS NULL THEN
3499: SELECT dpp_trans_int_hdr_id_seq.nextval
3500: INTO p_txn_header_rec_type.transaction_int_header_id
3501: FROM dual;
3502:
3503: INSERT INTO dpp_txn_headers_int_all
3504: (transaction_int_header_id,
3505: ref_document_number,

Line 3703: FROM dual;

3699:
3700: BEGIN
3701: SELECT dpp_trans_int_line_id_seq.nextval
3702: INTO p_transaction_lines_rec.transaction_int_line_id
3703: FROM dual;
3704:
3705:
3706: INSERT INTO dpp_txn_lines_int_all(
3707: transaction_int_header_id,

Line 4794: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;

4790: ||'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4791: --BUG 6806974
4792:
4793:
4794: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;
4795:
4796: mo_global.set_org_access( null,l_value,'M');
4797:
4798: