APPS.PA_AUTOALLOC_WF_PKG dependencies on PA_ALLOC_RUNS_ALL

Line 916: from pa_alloc_runs_all

912: 'PAXALGAT');
913:
914: select run_status,target_exp_group,offset_exp_group
915: into v_run_status,v_target_exp_group,v_offset_exp_group
916: from pa_alloc_runs_all
917: where run_id = v_allocation_run_id;
918:
919: if v_run_status in ('DF','DS','RF','IP') then
920: PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,

Line 1063: from pa_alloc_runs_all

1059: rev_target_exp_group),
1060: decode (v_operating_mode, 'N',offset_exp_group,
1061: rev_offset_exp_group)
1062: into v_target_exp_group,v_offset_exp_group
1063: from pa_alloc_runs_all
1064: where run_id = v_allocation_run_id;
1065:
1066: WriteDebugMsg('Target Expenditure Group : '||v_target_exp_group);
1067: WriteDebugMsg('Offset Expenditure Group : '||v_offset_exp_group);

Line 1897: from PA_ALLOC_RUNS_ALL

1893: IF v_parent_process = 'Generate Allocation' THEN
1894: begin
1895: select run_status,run_id
1896: into v_run_status,v_run_id
1897: from PA_ALLOC_RUNS_ALL
1898: where rule_id = v_batch_id
1899: and draft_request_id = v_conc_request_id;
1900:
1901: WriteDebugMsg('Run Status = '||v_run_status);

Line 1990: from PA_ALLOC_RUNS_ALL

1986: 'ALLOCATION_RUN_ID');
1987: WriteDebugMsg('Checking Release Status');
1988: select run_status
1989: into v_run_status
1990: from PA_ALLOC_RUNS_ALL
1991: where rule_id = v_batch_id
1992: and release_request_id = v_conc_request_id;
1993:
1994: WriteDebugMsg('Run Status = '||v_run_status);

Line 2113: from PA_ALLOC_RUNS_ALL

2109: p_item_key,
2110: 'STEP_NUMBER');
2111: select 'RELEASED'
2112: into v_result
2113: from PA_ALLOC_RUNS_ALL
2114: where run_id = v_allocation_run_id
2115: and run_status = 'RS';
2116:
2117: p_result := 'COMPLETE:'||v_result;