81: -- Budget Information
82: CURSOR l_budget_type_csr( p_budget_type_code VARCHAR2 )
83: IS
84: SELECT budget_type
85: FROM pa_budget_types
86: WHERE budget_type_code = p_budget_type_code;
87:
88:
89: l_return_status VARCHAR2(1);
110: l_project_manager_uname VARCHAR2(200) := NULL;
111: l_project_party_id NUMBER := NULL;
112: l_project_role_id NUMBER := NULL;
113: l_project_role_name VARCHAR2(80):= NULL;
114: l_budget_type pa_budget_types.budget_type%TYPE;
115: l_mark_as_original pa_budget_versions.original_flag%TYPE;
116:
117:
118: l_projects_rec l_projects_csr%ROWTYPE;
444: l_err_stack VARCHAR2(630) := NULL;
445:
446: l_project_id NUMBER := NULL;
447: l_draft_version_id NUMBER := NULL;
448: l_budget_type_code pa_budget_types.budget_type_code%TYPE := NULL;
449: l_mark_as_original pa_budget_versions.original_flag%TYPE := NULL;
450: l_budget_wf_flag VARCHAR2(1) := NULL;
451: l_bgt_intg_flag VARCHAR2(1) := NULL;
452: l_fck_req_flag VARCHAR2(1) := NULL;