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 607: FROM pa_projects_all

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

Line 3295: pa_projects p,

3291: IS
3292: SELECT v.resource_list_id,
3293: t.project_type_class_code
3294: FROM pa_project_types t,
3295: pa_projects p,
3296: pa_budget_versions v
3297: WHERE v.budget_version_id = p_draft_version_id
3298: AND v.project_id = p.project_id
3299: AND p.project_type = t.project_type

Line 3348: (p_pa_project_id pa_projects.project_id%type)

3344:
3345: --needed to get the field values associated to a AMG message
3346:
3347: CURSOR l_amg_project_csr
3348: (p_pa_project_id pa_projects.project_id%type)
3349: IS
3350: SELECT segment1
3351: FROM pa_projects p
3352: WHERE p.project_id = p_pa_project_id;

Line 3351: FROM pa_projects p

3347: CURSOR l_amg_project_csr
3348: (p_pa_project_id pa_projects.project_id%type)
3349: IS
3350: SELECT segment1
3351: FROM pa_projects p
3352: WHERE p.project_id = p_pa_project_id;
3353:
3354: l_amg_segment1 VARCHAR2(25);
3355:

Line 3358: (c_project_id pa_projects_all.project_id%TYPE,

3354: l_amg_segment1 VARCHAR2(25);
3355:
3356: -- Needed to check whether the plan type id passed is attached to the project or Not
3357: CURSOR l_plan_type_option_csr
3358: (c_project_id pa_projects_all.project_id%TYPE,
3359: c_fin_plan_type_id pa_proj_fp_options.proj_fp_options_id%TYPE)
3360: IS
3361: SELECT 'X'
3362: FROM pa_proj_fp_options pfo

Line 3369: (c_project_id pa_projects_all.project_id%TYPE,

3365: AND pfo.fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
3366:
3367: -- Needed to get the version id and record version number of the original baselined version
3368: CURSOR l_orig_baselined_ver_csr
3369: (c_project_id pa_projects_all.project_id%TYPE,
3370: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
3371: c_version_type pa_budget_versions.version_type%TYPE)
3372: IS
3373: SELECT budget_version_id

Line 5113: l_amg_project_number pa_projects_all.segment1%TYPE;

5109: l_module_name VARCHAR2(80);
5110: l_data VARCHAR2(2000);
5111: l_msg_index_out NUMBER;
5112:
5113: l_amg_project_number pa_projects_all.segment1%TYPE;
5114: l_amg_task_number VARCHAR2(50);
5115:
5116: --debug variables
5117: l_debug_mode VARCHAR2(1);

Line 6064: (p_pa_project_id pa_projects.project_id%type)

6060:
6061: --needed to get the field values associated to a AMG message
6062:
6063: CURSOR l_amg_project_csr
6064: (p_pa_project_id pa_projects.project_id%type)
6065: IS
6066: SELECT segment1
6067: FROM pa_projects p
6068: WHERE p.project_id = p_pa_project_id;

Line 6067: FROM pa_projects p

6063: CURSOR l_amg_project_csr
6064: (p_pa_project_id pa_projects.project_id%type)
6065: IS
6066: SELECT segment1
6067: FROM pa_projects p
6068: WHERE p.project_id = p_pa_project_id;
6069:
6070: l_amg_segment1 VARCHAR2(25);
6071:

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

6979: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6980: ,p_msg_count OUT NOCOPY NUMBER
6981: ,p_msg_data OUT NOCOPY VARCHAR2
6982: ,p_return_status OUT NOCOPY VARCHAR2
6983: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6984: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6985: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6986: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6987: ,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 6984: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6980: ,p_msg_count OUT NOCOPY NUMBER
6981: ,p_msg_data OUT NOCOPY VARCHAR2
6982: ,p_return_status OUT NOCOPY VARCHAR2
6983: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6984: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6985: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6986: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6987: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

6981: ,p_msg_data OUT NOCOPY VARCHAR2
6982: ,p_return_status OUT NOCOPY VARCHAR2
6983: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6984: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6985: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6986: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6987: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6989: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 7056: (p_pa_project_id pa_projects.project_id%type)

7052: AND use_for_workplan_flag = 'Y';
7053:
7054: --needed to get the field values associated to a AMG message
7055: CURSOR l_amg_project_csr
7056: (p_pa_project_id pa_projects.project_id%type)
7057: IS
7058: SELECT segment1
7059: FROM pa_projects p
7060: WHERE p.project_id = p_pa_project_id;

Line 7059: FROM pa_projects p

7055: CURSOR l_amg_project_csr
7056: (p_pa_project_id pa_projects.project_id%type)
7057: IS
7058: SELECT segment1
7059: FROM pa_projects p
7060: WHERE p.project_id = p_pa_project_id;
7061:
7062: l_amg_segment1 VARCHAR2(25);
7063:

Line 7097: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

7093: l_fin_plan_type_id NUMBER;
7094: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;
7095: l_version_type pa_budget_versions.version_type%TYPE;
7096: l_version_number NUMBER;
7097: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
7098:
7099:
7100: BEGIN
7101:

Line 7987: ,c_project_id pa_projects_all.project_id%TYPE)

7983:
7984: --This cursor is used to get the approved rev plan type flag of the plan type
7985: CURSOR l_approved_revenue_flag_csr
7986: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
7987: ,c_project_id pa_projects_all.project_id%TYPE)
7988: IS
7989: SELECT approved_rev_plan_type_flag
7990: FROM pa_proj_fp_options
7991: WHERE project_id=c_project_id

Line 8003: FROM pa_projects_all

7999: ( c_project_id NUMBER
8000: ,c_currency_code VARCHAR2)
8001: IS
8002: SELECT 1
8003: FROM pa_projects_all
8004: WHERE project_id = c_project_id
8005: AND projfunc_currency_code = c_currency_code;
8006:
8007: --This cursor is used to fetch the txn currencies of the plan version

Line 8077: l_amg_project_number pa_projects_all.segment1%TYPE;

8073: l_module_name VARCHAR2(80);
8074: l_data VARCHAR2(2000);
8075: l_msg_index_out NUMBER;
8076:
8077: l_amg_project_number pa_projects_all.segment1%TYPE;
8078: l_amg_task_number VARCHAR2(50);
8079:
8080: -- Bug# 5998035
8081: l_call_del_planning_trans VARCHAR2(1) := 'N';

Line 9209: l_multi_currency_billing_flag PA_PROJECTS_ALL.MULTI_CURRENCY_BILLING_FLAG%TYPE;

9205: l_uncategorized_list_id NUMBER;
9206: l_uncategorized_rlmid NUMBER;
9207: l_uncategorized_resid NUMBER;
9208: l_track_as_labor_flag VARCHAR2(1);
9209: l_multi_currency_billing_flag PA_PROJECTS_ALL.MULTI_CURRENCY_BILLING_FLAG%TYPE;
9210:
9211: l_amg_segment1 VARCHAR2(25);
9212: l_amg_task_number VARCHAR2(50);
9213:

Line 9217: (p_pa_project_id pa_projects.project_id%type)

9213:
9214: --needed to get the field values associated to a AMG message
9215:
9216: CURSOR l_amg_project_csr
9217: (p_pa_project_id pa_projects.project_id%type)
9218: IS
9219: SELECT segment1
9220: FROM pa_projects p
9221: WHERE p.project_id = p_pa_project_id;

Line 9220: FROM pa_projects p

9216: CURSOR l_amg_project_csr
9217: (p_pa_project_id pa_projects.project_id%type)
9218: IS
9219: SELECT segment1
9220: FROM pa_projects p
9221: WHERE p.project_id = p_pa_project_id;
9222:
9223: CURSOR l_amg_task_csr
9224: (p_pa_task_id pa_tasks.task_id%type)

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

9363: lx_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9365: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9366:
9367: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650
9368: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650
9369:
9370: i number;
9371: j number;

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

9364: lx_project_rev_rate_date_typ pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
9365: lx_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
9366:
9367: l_project_currency_code pa_projects_all.project_currency_code%TYPE; -- 3453650
9368: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE; -- 3453650
9369:
9370: i number;
9371: j number;
9372: lx_change_reason_code VARCHAR2(30);

Line 9390: l_amg_project_number pa_projects_all.segment1%TYPE;

9386: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9387: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9388: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9389: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9390: l_amg_project_number pa_projects_all.segment1%TYPE;
9391: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9392: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9393: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;
9394: l_allow_qty_flag VARCHAR2(1);

Line 10872: FROM pa_projects_all p

10868: SELECT p.project_currency_code
10869: ,p.projfunc_currency_code
10870: INTO l_project_currency_code
10871: ,l_projfunc_currency_code
10872: FROM pa_projects_all p
10873: WHERE p.project_id = l_project_id;
10874:
10875:
10876: SELECT projfunc_cost_rate_type

Line 13077: l_amg_project_number pa_projects_all.segment1%TYPE;

13073: l_module_name VARCHAR2(80);
13074: l_data VARCHAR2(2000);
13075: l_msg_index_out NUMBER;
13076:
13077: l_amg_project_number pa_projects_all.segment1%TYPE;
13078: l_amg_task_number VARCHAR2(50);
13079:
13080: --debug variables
13081: l_debug_mode VARCHAR2(1);

Line 14224: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

14220: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */
14221:
14222: --Included the following variables as part of changes to AMG due to finplan model.
14223: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14224: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14225: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14226: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14227: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

Line 14225: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

14221:
14222: --Included the following variables as part of changes to AMG due to finplan model.
14223: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14224: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14225: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14226: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14227: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 14226: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

14222: --Included the following variables as part of changes to AMG due to finplan model.
14223: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14224: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14225: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14226: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14227: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 14227: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;

14223: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
14224: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14225: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14226: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14227: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14231:

Line 14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;

14224: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
14225: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14226: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14227: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14231:
14232: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

Line 14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

14225: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
14226: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14227: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14231:
14232: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14233: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

Line 14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

14226: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
14227: l_project_cost_rate_type pa_projects_all.project_rate_type%TYPE;
14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14231:
14232: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14233: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14234: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

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

14252: ll_version_type pa_budget_versions.version_type%TYPE;
14253: ll_version_number pa_budget_versions.version_number%TYPE;
14254: --needed to get the field values associated to a AMG message
14255:
14256: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects
14257: CURSOR l_amg_project_csr
14258: (p_pa_project_id pa_projects.project_id%type)
14259: IS
14260: SELECT segment1

Line 14258: (p_pa_project_id pa_projects.project_id%type)

14254: --needed to get the field values associated to a AMG message
14255:
14256: --Added baseline_funding flag and querying from pa_projects_all and not from pa_projects
14257: CURSOR l_amg_project_csr
14258: (p_pa_project_id pa_projects.project_id%type)
14259: IS
14260: SELECT segment1
14261: ,baseline_funding_flag
14262: FROM pa_projects_all p

Line 14262: FROM pa_projects_all p

14258: (p_pa_project_id pa_projects.project_id%type)
14259: IS
14260: SELECT segment1
14261: ,baseline_funding_flag
14262: FROM pa_projects_all p
14263: WHERE p.project_id = p_pa_project_id;
14264:
14265: l_amg_project_rec l_amg_project_csr%ROWTYPE;
14266: --l_amg_segment1 VARCHAR2(25); no more used. Replaced by l_amg_project_rec.segment1

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

17105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17106: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
17107: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17108: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17109: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17110: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17111: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17112: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17113: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 17183: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

17179: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
17180: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
17181: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
17182:
17183: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
17184: l_resource_list_name PA_RESOURCE_LISTS.NAME%TYPE;
17185: l_resource_list_id PA_RESOURCE_LISTS.resource_list_id%TYPE;
17186:
17187: l_description PA_BUDGET_VERSIONS.description%Type;

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

18854: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18855: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18856: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18857: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18858: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18859: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18860: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18861: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18862: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 19120: l_project_number pa_projects_all.segment1%type;

19116: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19117: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19118: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19119: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19120: l_project_number pa_projects_all.segment1%type;
19121:
19122: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;
19123: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
19124: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type;

Line 19495: FROM pa_projects_all pa,

19491: SELECT decode(pf.approved_rev_plan_type_flag,'Y'
19492: ,pa.PROJFUNC_CURRENCY_CODE
19493: ,pa.PROJECT_CURRENCY_CODE)
19494: INTO l_currency_code
19495: FROM pa_projects_all pa,
19496: pa_proj_fp_options pf
19497: WHERE pa.project_id=l_project_id
19498: AND pa.project_id=pf.project_id
19499: AND pf.fin_plan_version_id=l_budget_version_id;