APPS.PA_AUTOALLOC_WF_PKG dependencies on PA_ALLOC_RUN

Line 681: PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,

677: G_Err_Stage:='Delete Draft before submitting Allocation Concurrent Process';
678: Set_PA_WF_Stage(p_item_type,p_item_key,G_Err_Stage);
679: WriteDebugMsg(G_Err_Stage);
680:
681: PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,
682: v_allocation_run_id);
683:
684: vc_expnd_item_date :=fnd_date.date_to_canonical(v_expnd_item_date);
685: WriteDebugMsg('Expenditure Item Date in char format:='

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 920: PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,

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,
921: v_allocation_run_id);
922: elsif v_run_status = 'RV' then
923: p_result := 'COMPLETE:PASS';
924: else

Line 933: PA_ALLOC_RUN.Reverse_alloc_txns( v_rule_id

929: substr(p_item_key,1,19);
930: G_Err_Stage:= 'Calling Reverse_alloc_txns';
931: WriteDebugMsg(G_Err_Stage);
932:
933: PA_ALLOC_RUN.Reverse_alloc_txns( v_rule_id
934: ,v_allocation_run_id
935: ,v_rev_tgt_exp_group
936: ,v_rev_off_exp_group
937: ,v_retcode

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 1559: PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,

1555: v_rule_id := WF_ENGINE.GetItemAttrNumber( p_item_type,
1556: p_item_key,
1557: 'BATCH_ID');
1558:
1559: PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,
1560: v_allocation_run_id);
1561:
1562: Reset_PA_WF_Stack(p_item_type,p_item_key);
1563: p_result := 'COMPLETE';

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;