[Home] [Help]
134: IF p_run_id is NOT NULL then
135:
136: SELECT 'Y'
137: INTO l_exists
138: FROM dual
139: WHERE EXISTS
140: (SELECT NULL
141: FROM PA_ALLOC_TXN_DETAILS
142: WHERE run_id = p_run_id);
294: BEGIN
295: -- Test if the cdl row has already been placed in service
296: SELECT 'CLOSED'
297: INTO lv_value
298: FROM DUAL
299: WHERE EXISTS
300: (SELECT 'X'
301: FROM pa_project_asset_line_details ppald
302: WHERE ppald.reversed_flag = 'N'
341:
342: -- Test for specified exclusion
343: SELECT 1
344: INTO ln_count
345: FROM dual
346: WHERE EXISTS(
347: SELECT null
348: FROM pa_cint_exp_type_excl pcete
349: WHERE pcete.expenditure_type = p_exp_type
550: BEGIN
551: -- Look for interest transactions against the project, period and rate
552: SELECT 'Y'
553: INTO x_bypass
554: FROM DUAL
555: WHERE EXISTS
556: (SELECT 'X'
557: FROM pa_alloc_txn_details patd
558: ,pa_alloc_runs par
666:
667: BEGIN
668: SELECT 'Y'
669: INTO l_rate_falg
670: FROM DUAL
671: WHERE EXISTS (
672: SELECT null
673: FROM pa_cint_rate_multipliers rate
674: WHERE rate.ind_rate_sch_id = p_sch_id
991: IS
992: BEGIN
993: SELECT pa_alloc_runs_s.nextval
994: INTO x_run_id
995: FROM DUAL;
996:
997: pa_alloc_run.insert_alloc_runs
998: (x_run_id => x_run_id
999: ,p_rule_id => p_rule_id
1140: IF p_run_id is NOT NULL then
1141:
1142: SELECT 'Y'
1143: INTO l_exists
1144: FROM dual
1145: WHERE EXISTS
1146: (SELECT NULL
1147: FROM PA_ALLOC_TXN_DETAILS det
1148: WHERE det.run_id = p_run_id)
2446:
2447: BEGIN
2448: SELECT pa_alloc_txn_details_s.nextval
2449: INTO lt_alloc_txn_id(i)
2450: FROM DUAL;
2451: EXCEPTION
2452: WHEN OTHERS THEN
2453: x_return_status := 'U';
2454: x_error_msg_count := 1;
2637: ,lt_attribute8(k)
2638: ,lt_attribute9(k)
2639: ,lt_attribute10(k)
2640: ,ln_sched_version_id
2641: FROM DUAL
2642: WHERE lt_process_task_flag(k) = 'Y';
2643: EXCEPTION
2644: WHEN OTHERS THEN
2645: x_return_status := 'U';