[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)
2443:
2444: BEGIN
2445: SELECT pa_alloc_txn_details_s.nextval
2446: INTO lt_alloc_txn_id(i)
2447: FROM DUAL;
2448: EXCEPTION
2449: WHEN OTHERS THEN
2450: x_return_status := 'U';
2451: x_error_msg_count := 1;
2634: ,lt_attribute8(k)
2635: ,lt_attribute9(k)
2636: ,lt_attribute10(k)
2637: ,ln_sched_version_id
2638: FROM DUAL
2639: WHERE lt_process_task_flag(k) = 'Y';
2640: EXCEPTION
2641: WHEN OTHERS THEN
2642: x_return_status := 'U';