eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BUDGET_PUB dependencies on PA_PROJECTS

Line 25: FUNCTION get_project_id return pa_projects_all.project_id%type

21: and lookup_code = p_pm_product_code;
22:
23: -- Added by Xin Liu 24-APR-03
24:
25: FUNCTION get_project_id return pa_projects_all.project_id%type
26: is
27: BEGIN
28: return PA_BUDGET_PUB.G_PROJECT_ID;
29: END;

Line 31: PROCEDURE set_project_id (p_project_id IN PA_PROJECTS_ALL.project_id%type) is

27: BEGIN
28: return PA_BUDGET_PUB.G_PROJECT_ID;
29: END;
30:
31: PROCEDURE set_project_id (p_project_id IN PA_PROJECTS_ALL.project_id%type) is
32: BEGIN
33: PA_BUDGET_PUB.G_Project_Id := p_project_id;
34: END;
35:

Line 173: l_project_id pa_projects_all.project_id%TYPE;

169:
170: l_api_name CONSTANT VARCHAR2(30) := 'create_draft_budget';
171: l_return_status VARCHAR2(1);
172:
173: l_project_id pa_projects_all.project_id%TYPE;
174: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
175: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
176: l_err_code NUMBER;
177: l_err_stage VARCHAR2(120);

Line 250: l_amg_segment1 pa_projects_all.segment1%TYPE;

246: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
250: l_amg_segment1 pa_projects_all.segment1%TYPE;
251: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
252: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
253: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
254: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

Line 609: FROM pa_projects_all

605: END IF;
606:
607: SELECT segment1
608: INTO l_amg_segment1
609: FROM pa_projects_all
610: WHERE project_id=l_project_id;
611:
612: IF l_debug_mode = 'Y' THEN
613: pa_debug.g_err_stage := 'Got the budget type details and segment1 of the project';

Line 2690: FROM pa_projects_all p, pa_tasks pa

2686: AND cu.PROJFUNC_CURRENCY_FLAG = 'Y'; */
2687: --added the below query
2688: SELECT Nvl(p.PROJFUNC_CURRENCY_CODE,'USD')
2689: INTO l_txn_currency_code
2690: FROM pa_projects_all p, pa_tasks pa
2691: WHERE pa.task_id = p_pa_task_id
2692: AND p.project_id= pa.project_id;
2693: --bug fix 14114695 end
2694: END IF;

Line 3367: pa_projects p,

3363: IS
3364: SELECT v.resource_list_id,
3365: t.project_type_class_code
3366: FROM pa_project_types t,
3367: pa_projects p,
3368: pa_budget_versions v
3369: WHERE v.budget_version_id = p_draft_version_id
3370: AND v.project_id = p.project_id
3371: AND p.project_type = t.project_type

Line 3420: (p_pa_project_id pa_projects.project_id%type)

3416:
3417: --needed to get the field values associated to a AMG message
3418:
3419: CURSOR l_amg_project_csr
3420: (p_pa_project_id pa_projects.project_id%type)
3421: IS
3422: SELECT segment1
3423: FROM pa_projects p
3424: WHERE p.project_id = p_pa_project_id;

Line 3423: FROM pa_projects p

3419: CURSOR l_amg_project_csr
3420: (p_pa_project_id pa_projects.project_id%type)
3421: IS
3422: SELECT segment1
3423: FROM pa_projects p
3424: WHERE p.project_id = p_pa_project_id;
3425:
3426: l_amg_segment1 VARCHAR2(25);
3427:

Line 3430: (c_project_id pa_projects_all.project_id%TYPE,

3426: l_amg_segment1 VARCHAR2(25);
3427:
3428: -- Needed to check whether the plan type id passed is attached to the project or Not
3429: CURSOR l_plan_type_option_csr
3430: (c_project_id pa_projects_all.project_id%TYPE,
3431: c_fin_plan_type_id pa_proj_fp_options.proj_fp_options_id%TYPE)
3432: IS
3433: SELECT 'X'
3434: FROM pa_proj_fp_options pfo

Line 3441: (c_project_id pa_projects_all.project_id%TYPE,

3437: AND pfo.fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
3438:
3439: -- Needed to get the version id and record version number of the original baselined version
3440: CURSOR l_orig_baselined_ver_csr
3441: (c_project_id pa_projects_all.project_id%TYPE,
3442: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
3443: c_version_type pa_budget_versions.version_type%TYPE)
3444: IS
3445: SELECT budget_version_id

Line 5223: l_amg_project_number pa_projects_all.segment1%TYPE;

5219: l_module_name VARCHAR2(80);
5220: l_data VARCHAR2(2000);
5221: l_msg_index_out NUMBER;
5222:
5223: l_amg_project_number pa_projects_all.segment1%TYPE;
5224: l_amg_task_number VARCHAR2(50);
5225:
5226: --debug variables
5227: l_debug_mode VARCHAR2(1);

Line 6216: (p_pa_project_id pa_projects.project_id%type)

6212:
6213: --needed to get the field values associated to a AMG message
6214:
6215: CURSOR l_amg_project_csr
6216: (p_pa_project_id pa_projects.project_id%type)
6217: IS
6218: SELECT segment1
6219: FROM pa_projects p
6220: WHERE p.project_id = p_pa_project_id;

Line 6219: FROM pa_projects p

6215: CURSOR l_amg_project_csr
6216: (p_pa_project_id pa_projects.project_id%type)
6217: IS
6218: SELECT segment1
6219: FROM pa_projects p
6220: WHERE p.project_id = p_pa_project_id;
6221:
6222: l_amg_segment1 VARCHAR2(25);
6223:

Line 7135: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

7131: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
7132: ,p_msg_count OUT NOCOPY NUMBER
7133: ,p_msg_data OUT NOCOPY VARCHAR2
7134: ,p_return_status OUT NOCOPY VARCHAR2
7135: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7136: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7137: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7138: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7139: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 7136: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7132: ,p_msg_count OUT NOCOPY NUMBER
7133: ,p_msg_data OUT NOCOPY VARCHAR2
7134: ,p_return_status OUT NOCOPY VARCHAR2
7135: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7136: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7137: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7138: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7139: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 7137: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

7133: ,p_msg_data OUT NOCOPY VARCHAR2
7134: ,p_return_status OUT NOCOPY VARCHAR2
7135: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7136: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7137: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7138: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7139: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7141: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 7208: (p_pa_project_id pa_projects.project_id%type)

7204: AND use_for_workplan_flag = 'Y';
7205:
7206: --needed to get the field values associated to a AMG message
7207: CURSOR l_amg_project_csr
7208: (p_pa_project_id pa_projects.project_id%type)
7209: IS
7210: SELECT segment1
7211: FROM pa_projects p
7212: WHERE p.project_id = p_pa_project_id;

Line 7211: FROM pa_projects p

7207: CURSOR l_amg_project_csr
7208: (p_pa_project_id pa_projects.project_id%type)
7209: IS
7210: SELECT segment1
7211: FROM pa_projects p
7212: WHERE p.project_id = p_pa_project_id;
7213:
7214: l_amg_segment1 VARCHAR2(25);
7215:

Line 7249: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

7245: l_fin_plan_type_id NUMBER;
7246: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;
7247: l_version_type pa_budget_versions.version_type%TYPE;
7248: l_version_number NUMBER;
7249: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
7250:
7251: ll_fin_plan_type_id NUMBER; --Added for bug 13968843
7252:
7253:

Line 8147: ,c_project_id pa_projects_all.project_id%TYPE)

8143:
8144: --This cursor is used to get the approved rev plan type flag of the plan type
8145: CURSOR l_approved_revenue_flag_csr
8146: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
8147: ,c_project_id pa_projects_all.project_id%TYPE)
8148: IS
8149: SELECT approved_rev_plan_type_flag
8150: FROM pa_proj_fp_options
8151: WHERE project_id=c_project_id

Line 8163: FROM pa_projects_all

8159: ( c_project_id NUMBER
8160: ,c_currency_code VARCHAR2)
8161: IS
8162: SELECT 1
8163: FROM pa_projects_all
8164: WHERE project_id = c_project_id
8165: AND projfunc_currency_code = c_currency_code;
8166:
8167: --This cursor is used to fetch the txn currencies of the plan version

Line 8237: l_amg_project_number pa_projects_all.segment1%TYPE;

8233: l_module_name VARCHAR2(80);
8234: l_data VARCHAR2(2000);
8235: l_msg_index_out NUMBER;
8236:
8237: l_amg_project_number pa_projects_all.segment1%TYPE;
8238: l_amg_task_number VARCHAR2(50);
8239:
8240: -- Bug# 5998035
8241: l_call_del_planning_trans VARCHAR2(1) := 'N';

Line 9390: l_multi_currency_billing_flag PA_PROJECTS_ALL.MULTI_CURRENCY_BILLING_FLAG%TYPE;

9386: l_uncategorized_list_id NUMBER;
9387: l_uncategorized_rlmid NUMBER;
9388: l_uncategorized_resid NUMBER;
9389: l_track_as_labor_flag VARCHAR2(1);
9390: l_multi_currency_billing_flag PA_PROJECTS_ALL.MULTI_CURRENCY_BILLING_FLAG%TYPE;
9391:
9392: temp_budget_start_date DATE; -- adding this variable to store the budget_start_date value bug#12424439 ->FP:Bug#12606319
9393:
9394: l_amg_segment1 VARCHAR2(25);

Line 9400: (p_pa_project_id pa_projects.project_id%type)

9396:
9397: --needed to get the field values associated to a AMG message
9398:
9399: CURSOR l_amg_project_csr
9400: (p_pa_project_id pa_projects.project_id%type)
9401: IS
9402: SELECT segment1
9403: FROM pa_projects p
9404: WHERE p.project_id = p_pa_project_id;

Line 9403: FROM pa_projects p

9399: CURSOR l_amg_project_csr
9400: (p_pa_project_id pa_projects.project_id%type)
9401: IS
9402: SELECT segment1
9403: FROM pa_projects p
9404: WHERE p.project_id = p_pa_project_id;
9405:
9406: CURSOR l_amg_task_csr
9407: (p_pa_task_id pa_tasks.task_id%type)

Line 9550: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650

9546: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9548: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9549:
9550: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650
9551: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650
9552:
9553: i number;
9554: j number;

Line 9551: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650

9547: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9548: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9549:
9550: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650
9551: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650
9552:
9553: i number;
9554: j number;
9555: lx_change_reason_code VARCHAR2(30);

Line 9573: l_amg_project_number pa_projects_all.segment1%TYPE;

9569: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9570: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9571: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9572: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9573: l_amg_project_number pa_projects_all.segment1%TYPE;
9574: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9575: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9576: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
9577: l_allow_qty_flag VARCHAR2(1);

Line 11070: FROM pa_projects_all p

11066: SELECT p.project_currency_code
11067: ,p.projfunc_currency_code
11068: INTO l_project_currency_code
11069: ,l_projfunc_currency_code
11070: FROM pa_projects_all p
11071: WHERE p.project_id = l_project_id;
11072:
11073:
11074: SELECT projfunc_cost_rate_type

Line 13300: l_amg_project_number pa_projects_all.segment1%TYPE;

13296: l_module_name VARCHAR2(80);
13297: l_data VARCHAR2(2000);
13298: l_msg_index_out NUMBER;
13299:
13300: l_amg_project_number pa_projects_all.segment1%TYPE;
13301: l_amg_task_number VARCHAR2(50);
13302:
13303: --debug variables
13304: l_debug_mode VARCHAR2(1);

Line 14470: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

14466: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */
14467:
14468: --Included the following variables as part of changes to AMG due to finplan model.
14469: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14470: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14471: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 14471: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

14467:
14468: --Included the following variables as part of changes to AMG due to finplan model.
14469: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14470: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14471: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

14468: --Included the following variables as part of changes to AMG due to finplan model.
14469: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14470: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14471: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

14469: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14470: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14471: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14477:

Line 14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

14470: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14471: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14477:
14478: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

Line 14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

14471: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14477:
14478: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14479: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

Line 14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

14472: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14473: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14477:
14478: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14479: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14480: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

Line 14502: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects

14498: ll_version_type pa_budget_versions.version_type%TYPE;
14499: ll_version_number pa_budget_versions.version_number%TYPE;
14500: --needed to get the field values associated to a AMG message
14501:
14502: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects
14503: CURSOR l_amg_project_csr
14504: (p_pa_project_id pa_projects.project_id%type)
14505: IS
14506: SELECT segment1

Line 14504: (p_pa_project_id pa_projects.project_id%type)

14500: --needed to get the field values associated to a AMG message
14501:
14502: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects
14503: CURSOR l_amg_project_csr
14504: (p_pa_project_id pa_projects.project_id%type)
14505: IS
14506: SELECT segment1
14507: ,baseline_funding_flag
14508: FROM pa_projects_all p

Line 14508: FROM pa_projects_all p

14504: (p_pa_project_id pa_projects.project_id%type)
14505: IS
14506: SELECT segment1
14507: ,baseline_funding_flag
14508: FROM pa_projects_all p
14509: WHERE p.project_id = p_pa_project_id;
14510:
14511: l_amg_project_rec l_amg_project_csr%ROWTYPE;
14512: --l_amg_segment1 VARCHAR2(25); no more used. Replaced by l_amg_project_rec.segment1

Line 17368: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17364: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17365: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
17366: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17367: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17368: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17442: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

17438: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17439: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17440: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17441:
17442: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17443: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17444: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17445:
17446: l_description PA_BUDGET_VERSIONS.description%Type;

Line 19143: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19139: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
19140: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
19141: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19142: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19143: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19414: l_project_number pa_projects_all.segment1%type;

19410: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19411: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19412: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19413: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19414: l_project_number pa_projects_all.segment1%type;
19415:
19416: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;
19417: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
19418: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type;

Line 19849: FROM pa_projects_all pa,

19845: SELECT decode(pf.approved_rev_plan_type_flag,'Y'
19846: ,pa.PROJFUNC_CURRENCY_CODE
19847: ,pa.PROJECT_CURRENCY_CODE)
19848: INTO l_currency_code
19849: FROM pa_projects_all pa,
19850: pa_proj_fp_options pf
19851: WHERE pa.project_id=l_project_id
19852: AND pa.project_id=pf.project_id
19853: AND pf.fin_plan_version_id=l_budget_version_id;