APPS.DPP_TRANSACTION_PVT dependencies on DUAL

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

107: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_NULL';
108: RAISE Fnd_Api.G_EXC_ERROR;
109: END IF;
110:
111: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;
112:
113: mo_global.set_org_access( null,l_value,'M');
114:
115:

Line 678: FROM DUAL;

674: --Cursor to get the truncated effective start date and system date
675: CURSOR get_trunc_dates(effective_start_date DATE)
676: IS
677: SELECT trunc(effective_start_date), TRUNC(SYSDATE)
678: FROM DUAL;
679:
680: BEGIN
681: -- Initialize API return status to sucess
682: x_return_status := fnd_api.g_ret_sts_success;

Line 718: FROM dual;

714: --Validation part in Create Header
715: BEGIN
716: SELECT dpp_transaction_hdr_id_seq.nextval
717: INTO p_txn_header_rec_type.transaction_header_id
718: FROM dual;
719: EXCEPTION
720: WHEN no_data_found THEN
721: x_return_status := fnd_api.g_ret_sts_error;
722: fnd_message.set_name('DPP', 'DPP_TXN_SEQ_NO_ERR');

Line 737: FROM dual;

733: --Get transaction Number from sequence
734: BEGIN
735: SELECT dpp_transaction_number_seq.nextval
736: INTO p_txn_header_rec_type.transaction_number
737: FROM dual;
738:
739: EXCEPTION
740: WHEN no_data_found THEN
741: x_return_status := fnd_api.g_ret_sts_error;

Line 1072: FROM dual;

1068: --Get transaction line id from sequence
1069: BEGIN
1070: SELECT dpp_transaction_line_id_seq.nextval
1071: INTO p_txn_lines_tbl_type(i).transaction_line_id
1072: FROM dual;
1073:
1074: EXCEPTION
1075: WHEN no_data_found THEN
1076: x_return_status := fnd_api.g_ret_sts_error;

Line 1738: FROM dual;

1734:
1735:
1736: SELECT fnd_profile.VALUE('DPP_NEW_PRICE_DECIMAL_PRECISION')
1737: INTO l_rounding
1738: FROM dual;
1739:
1740: IF l_rounding IS NULL THEN
1741: l_rounding := 4;
1742: END IF;

Line 2995: FROM dual;

2991: END IF;
2992:
2993: SELECT fnd_profile.VALUE('DPP_AUDIT_ENABLED')
2994: INTO l_log_enabled
2995: FROM dual;
2996:
2997: IF DPP_DEBUG_HIGH_ON THEN
2998: fnd_file.put_line(fnd_file.log, 'Audit Enabled '||l_log_enabled );
2999: END IF;

Line 3788: FROM dual;

3784:
3785: IF l_transaction_int_header_id IS NULL THEN
3786: SELECT dpp_trans_int_hdr_id_seq.nextval
3787: INTO p_txn_header_rec_type.transaction_int_header_id
3788: FROM dual;
3789:
3790: INSERT INTO dpp_txn_headers_int_all
3791: (transaction_int_header_id,
3792: ref_document_number,

Line 3993: FROM dual;

3989:
3990: BEGIN
3991: SELECT dpp_trans_int_line_id_seq.nextval
3992: INTO p_transaction_lines_rec.transaction_int_line_id
3993: FROM dual;
3994:
3995:
3996: INSERT INTO dpp_txn_lines_int_all(
3997: transaction_int_header_id,

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

5077: ||'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
5078: --BUG 6806974
5079:
5080:
5081: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;
5082:
5083: mo_global.set_org_access( null,l_value,'M');
5084:
5085: