APPS.PA_BUDGET_FUND_PKG dependencies on PA_PROJECTS_ALL

Line 37: g_project_id pa_projects_all.project_id%type;

33: g_msg_data VARCHAR2(1000);
34: g_procedure_name VARCHAR2(30);
35: g_debug_mode VARCHAR2(10);
36: g_draft_bvid pa_budget_versions.budget_version_id%type;
37: g_project_id pa_projects_all.project_id%type;
38: g_org_id pa_implementations_all.org_id%type; --Bug 6524116
39:
40: -- This is an autonomous procedure ...
41: PROCEDURE Update_bc_packets_fail(p_bud_ver_id IN NUMBER,

Line 110: l_project_num pa_projects_all.segment1%type; --Bug 6524116

106: l_msg_index_out NUMBER ;
107: l_chk_res_unres_multi NUMBER ;
108:
109: l_period_set_name VARCHAR2(15);
110: l_project_num pa_projects_all.segment1%type; --Bug 6524116
111:
112: --PRAGMA AUTONOMOUS_TRANSACTION;--Bug 6524116; Removed as this is causing issue with IGC funds checking.
113:
114: BEGIN

Line 198: from pa_projects_all p,

194:
195: --Bug 6524116
196: select segment1
197: into l_project_num
198: from pa_projects_all p,
199: pa_budget_versions bv
200: where p.project_id = bv.project_id
201: and bv.budget_version_id = p_budget_version_id;
202:

Line 939: l_template_flag pa_projects_all.template_flag%type;

935: l_msg_data VARCHAR2(240) ;
936: l_dummy number;
937: l_sqlerrm VARCHAR2(4000);
938: l_request_id NUMBER;
939: l_template_flag pa_projects_all.template_flag%type;
940: --Bug 6524116
941: l_cc_budget_entry_level_code VARCHAR2(30) ;
942: P_prev_budget_version_id number;
943: rejected_event_id_tab PSA_FUNDS_CHECKER_PKG.num_rec;

Line 1019: FROM pa_projects_all

1015: -- You should not call FC for template project ...
1016: -- ----------------------------------------------------------------------+
1017: SELECT nvl(template_flag,'N'), org_id
1018: INTO l_template_flag , g_org_id
1019: FROM pa_projects_all
1020: WHERE project_id = p_project_id;
1021:
1022: If l_template_flag = 'Y' then
1023: log_message('check_or_reserve_funds called for template project ..exit with success');

Line 2849: l_project_id pa_projects_all.project_id%TYPE;

2845: l_calling_module VARCHAR2(20);
2846: l_cc_calling_module VARCHAR2(20);
2847: l_data_set_id pa_budget_versions.budget_version_id%TYPE;
2848: l_cc_data_set_id pa_budget_versions.budget_version_id%TYPE;
2849: l_project_id pa_projects_all.project_id%TYPE;
2850: l_budget_type_code pa_budget_versions.Budget_type_code%TYPE;
2851:
2852: l_return_status VARCHAR2(1);
2853: l_msg_count NUMBER;

Line 3350: pa_projects_all pp

3346: Select decode(NVL(ppt.burden_cost_flag, 'N'),'Y',
3347: NVL(ppt.burden_amt_display_method,'S'),'N')
3348: into l_burden_method
3349: from pa_project_types ppt,
3350: pa_projects_all pp
3351: where ppt.project_type = pp.project_type
3352: and pp.project_id = X_project_id;
3353:
3354: log_message(' In Unburdened_cdl_exists:Burden method is :'||l_burden_method);