DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on FND_LOOKUPS

Line 612: FROM fnd_lookups

608: --Get Transaction Status from Lookup
609: BEGIN
610: SELECT lookup_code
611: INTO p_txn_header_rec_type.transaction_status
612: FROM fnd_lookups
613: WHERE lookup_type = 'DPP_TRANSACTION_STATUSES'
614: AND lookup_code = 'NEW';
615: EXCEPTION
616: WHEN no_data_found THEN

Line 913: FROM fnd_lookups

909: --Get line status from lookup
910: BEGIN
911: SELECT lookup_code
912: INTO p_txn_lines_tbl_type(i).line_status
913: FROM fnd_lookups
914: WHERE lookup_code = 'NEW'
915: AND lookup_type = 'DPP_TRANSACTION_STATUSES';
916: EXCEPTION
917: WHEN no_data_found THEN

Line 2090: FROM fnd_lookups fl

2086: --Get the Process code for Update Claim and set in the hdr rec type
2087: BEGIN
2088: SELECT fl.lookup_code
2089: INTO l_claim_txn_hdr_rec_type.Process_code
2090: FROM fnd_lookups fl
2091: WHERE fl.lookup_type = 'DPP_EXECUTION_PROCESSES'
2092: AND fl.lookup_code = 'UPDCLM';
2093: EXCEPTION
2094: WHEN no_data_found THEN

Line 3004: FROM fnd_lookups

3000:
3001: BEGIN
3002: SELECT lookup_code
3003: INTO l_status_cancelled
3004: FROM fnd_lookups
3005: WHERE lookup_type = 'DPP_TRANSACTION_STATUSES'
3006: AND lookup_code = 'CANCELLED';
3007: EXCEPTION
3008: WHEN no_data_found THEN