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_BUDGET_LINES

Line 47: -- pa_budget_lines_v_pkg.check_overlapping_dates

43: --
44: --
45: --Called subprograms: PA_BUDGET_UTILS.create_draft
46: -- pa_budget_pvt.insert_budget_line
47: -- pa_budget_lines_v_pkg.check_overlapping_dates
48: -- PA_BUDGET_UTILS.summerize_project_totals
49: -- PA_BUDGET_FUND_PKG.get_budget_ctrl_options
50: --
51: --

Line 161: ,pa_budget_lines bl

157: IS
158: SELECT 'x'
159: FROM pa_budget_versions bv
160: ,pa_resource_assignments ra
161: ,pa_budget_lines bl
162: WHERE bv.budget_version_id = c_budget_version_id
163: AND bv.budget_version_id = ra.budget_version_id (+)
164: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
165: AND bv.ci_id IS NULL -- -- Added an extra clause ci_id IS NULL--Bug # 3507156

Line 2190: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id

2186: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2187: END IF;
2188:
2189: -- check for overlapping dates
2190: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id
2191: ,x_resource_name => l_resource_name
2192: ,x_err_code => l_err_code );
2193:
2194: IF l_err_code > 0

Line 2220: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

2216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2217: THEN
2218:
2219: FND_MSG_PUB.add_exc_msg
2220: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
2221: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
2222: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
2223:
2224: END IF;

Line 2594: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

2590: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2591: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2592: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2593: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2594: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2595: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2596: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2597: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2598: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 2602: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE

2598: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2599: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2600: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2601: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2602: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
2603: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2604: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2605: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2606: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

Line 2610: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE

2606: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2607: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2608: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2609: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2610: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
2611: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2612: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2613: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2614: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 2618: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE

2614: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2615: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2616: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2617: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2618: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
2619: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2620: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
2621: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2622: )

Line 2620: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

2616: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2617: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2618: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
2619: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2620: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
2621: :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2622: )
2623:
2624: IS

Line 3252: FROM pa_budget_lines

3248: CURSOR l_budget_lines_csr
3249: (p_budget_version_id NUMBER )
3250: IS
3251: SELECT 1
3252: FROM pa_budget_lines
3253: WHERE budget_version_id = p_budget_version_id;
3254:
3255: CURSOR l_budget_versions_csr
3256: (c_project_id NUMBER

Line 4999: -- pa_budget_lines_v_pkg.check_overlapping_dates

4995: -- existing WORKING budget.
4996: --
4997: --Called subprograms:
4998: -- pa_budget_pvt.insert_budget_line
4999: -- pa_budget_lines_v_pkg.check_overlapping_dates
5000: -- PA_BUDGET_UTILS.summerize_project_totals
5001: --
5002: --
5003: --

Line 5296: PA_BUDGET_LINES_V_PKG.check_overlapping_dates

5292: END IF;
5293:
5294:
5295: --check for overlapping dates
5296: PA_BUDGET_LINES_V_PKG.check_overlapping_dates
5297: ( x_budget_version_id => l_budget_version_id --IN
5298: ,x_resource_name => l_resource_name --OUT
5299: ,x_err_code => l_err_code );
5300:

Line 5330: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

5326:
5327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5328: THEN
5329: FND_MSG_PUB.add_exc_msg
5330: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5331: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
5332: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
5333: END IF;
5334:

Line 6033: , pa_budget_lines bl

6029: IS
6030: SELECT 'x'
6031: FROM pa_budget_versions bv
6032: , pa_resource_assignments ra
6033: , pa_budget_lines bl
6034: WHERE bv.budget_version_id = p_budget_version_id
6035: AND bv.budget_version_id = ra.budget_version_id (+)
6036: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
6037: AND bv.ci_id IS NULL -- -- Added an extra clause bv.ci_id IS NULL--Bug # 3507156

Line 7938: FROM pa_budget_lines

7934: SELECT rowidtochar(rowid)
7935: ,txn_currency_code
7936: ,start_date
7937: ,end_date
7938: FROM pa_budget_lines
7939: WHERE resource_assignment_id = p_resource_assignment_id
7940: AND trunc(start_date) = nvl(trunc(p_budget_start_date),trunc(start_date))
7941: AND txn_currency_code = nvl(p_currency_code,txn_currency_code);
7942:

Line 7980: FROM pa_budget_lines

7976: --needed to lock the budget line row
7977: CURSOR l_lock_budget_line_csr( p_budget_line_rowid VARCHAR2)
7978: IS
7979: SELECT 'x'
7980: FROM pa_budget_lines
7981: WHERE rowid = p_budget_line_rowid
7982: FOR UPDATE NOWAIT;
7983:
7984: --This cursor is used to get the approved rev plan type flag of the plan type

Line 8588: /FPB2: MRC PA_BUDGET_LINES_V_PKG.delete_row( l_budget_line_rowid ); /

8584:
8585: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
8586: CLOSE l_lock_budget_line_csr;
8587:
8588: /*FPB2: MRC PA_BUDGET_LINES_V_PKG.delete_row( l_budget_line_rowid ); */
8589: pa_budget_lines_v_pkg.delete_row(X_Rowid => l_budget_line_rowid);
8590: -- Bug Fix: 4569365. Removed MRC code.
8591: --, x_mrc_flag => 'Y'); /* FPB2: Added x_mrc_flag for MRC changes */
8592:

Line 8589: pa_budget_lines_v_pkg.delete_row(X_Rowid => l_budget_line_rowid);

8585: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
8586: CLOSE l_lock_budget_line_csr;
8587:
8588: /*FPB2: MRC PA_BUDGET_LINES_V_PKG.delete_row( l_budget_line_rowid ); */
8589: pa_budget_lines_v_pkg.delete_row(X_Rowid => l_budget_line_rowid);
8590: -- Bug Fix: 4569365. Removed MRC code.
8591: --, x_mrc_flag => 'Y'); /* FPB2: Added x_mrc_flag for MRC changes */
8592:
8593:

Line 8604: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

8600:
8601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8602: THEN
8603: FND_MSG_PUB.add_exc_msg
8604: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
8605: , p_procedure_name => 'DELETE_ROW'
8606: , p_error_text => SQLCODE );
8607:
8608: END IF;

Line 9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9005: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9006: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9009: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9007: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9008: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9009: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9010: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9013: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9011: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9012: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9013: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9014: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9016: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9017: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9018: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9019: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 9019: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

9015: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9016: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9017: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9018: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9019: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9020: /* Plan Amount Entry flags introduced by bug 6408139 */
9021: ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9022: ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9023: ,p_revenue_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9050: FROM pa_budget_lines

9046: (p_resource_assigment_id NUMBER
9047: ,p_budget_start_date DATE )
9048: IS
9049: SELECT 'X'
9050: FROM pa_budget_lines
9051: WHERE resource_assignment_id = p_resource_assigment_id
9052: AND start_date = p_budget_start_date;
9053:
9054: --needed to get the current budget version data

Line 9157: , pa_budget_lines bl

9153: IS
9154: SELECT 'x'
9155: FROM pa_budget_versions bv
9156: , pa_resource_assignments ra
9157: , pa_budget_lines bl
9158: WHERE bv.budget_version_id = p_budget_version_id
9159: AND bv.budget_version_id = ra.budget_version_id (+)
9160: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
9161: AND bv.ci_id IS NULL -- -- Added an extra clause bv.ci_id IS NULL--Bug # 3507156

Line 9277: FROM pa_budget_lines

9273: ,p_budget_start_date DATE
9274: ,p_txn_currency_code VARCHAR2)
9275: IS
9276: SELECT 'X'
9277: FROM pa_budget_lines
9278: WHERE resource_assignment_id = p_resource_assigment_id
9279: AND start_date = p_budget_start_date
9280: AND txn_currency_code = p_txn_currency_code;
9281:

Line 9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;

9398: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
9399: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9400: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9404: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9405: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9406:

Line 9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;

9399: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
9400: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9404: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9405: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9406:
9407: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

Line 9404: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;

9400: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9404: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9405: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9406:
9407: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9408: /*Added local variables for bug 6408139*/

Line 9405: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;

9401: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
9402: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE;
9403: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE;
9404: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE;
9405: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE;
9406:
9407: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
9408: /*Added local variables for bug 6408139*/
9409: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 12446: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id --IN

12442: /*Added the below if condition for the bug 3453650*/
12443: IF l_budget_type_code IS NOT NULL THEN
12444:
12445: -- check for overlapping dates
12446: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id --IN
12447: ,x_resource_name => l_resource_name --OUT
12448: ,x_err_code => l_err_code );
12449:
12450: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );

Line 12450: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );

12446: pa_budget_lines_v_pkg.check_overlapping_dates( x_budget_version_id => l_budget_version_id --IN
12447: ,x_resource_name => l_resource_name --OUT
12448: ,x_err_code => l_err_code );
12449:
12450: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );
12451:
12452: IF l_err_code > 0 THEN
12453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12454: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');

Line 12463: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

12459: RAISE FND_API.G_EXC_ERROR;
12460: ELSIF l_err_code < 0 THEN
12461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12462: FND_MSG_PUB.add_exc_msg
12463: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
12464: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
12465: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
12466: END IF;
12467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12683: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12684: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12685: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12688: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12686: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12687: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12688: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12689: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12692: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12690: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12691: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12692: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12693: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12695: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12696: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12697: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12698: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 12698: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12694: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12695: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12696: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12697: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
12698: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12699: )
12700:
12701: IS
12702:

Line 13010: FROM pa_budget_lines

13006: ,p_currency_code VARCHAR2)
13007: IS
13008: SELECT rowidtochar(rowid)
13009: ,budget_line_id
13010: FROM pa_budget_lines
13011: WHERE resource_assignment_id = p_resource_assigment_id
13012: AND trunc(start_date) = nvl(trunc(p_budget_start_date),trunc(start_date))
13013: AND txn_currency_code = nvl(p_currency_code,txn_currency_code);
13014:

Line 13019: FROM pa_budget_lines

13015: --needed to lock the budget line row
13016: CURSOR l_lock_budget_line_csr( p_budget_line_rowid VARCHAR2)
13017: IS
13018: SELECT 'x'
13019: FROM pa_budget_lines
13020: WHERE rowid = p_budget_line_rowid
13021: FOR UPDATE NOWAIT;
13022:
13023: l_api_name CONSTANT VARCHAR2(30) := 'update_budget_line';

Line 13629: --Take a db lock on the table pa_budget_lines

13625: --Update budget line for old FORMS based Budgets Model
13626: IF l_budget_type_code IS NOT NULL
13627: THEN
13628:
13629: --Take a db lock on the table pa_budget_lines
13630: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
13631: CLOSE l_lock_budget_line_csr; --FYI, does not release lock
13632:
13633: --Calling update_budget_line_sql to build a dynamic update statement

Line 14109: -- view definition. Changing the pa_budget_lines_v view could have a large impact.

14105: l_context_budget CONSTANT VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET;
14106:
14107: -- Bug 2863564 The cursor has been modified for financial planning changes.
14108: -- The changes include fetching of new columns which aren't included in the
14109: -- view definition. Changing the pa_budget_lines_v view could have a large impact.
14110: -- So, cursor has been modified to be based on the direct tables.
14111:
14112: ---- Bug # 3507156
14113: -- Modified the select statement to selecy alias name directly from pa_resource_list_members table

Line 14146: FROM pa_budget_lines bl,

14142: ,bl.project_revenue project_revenue
14143: ,bl.raw_cost projfunc_raw_cost
14144: ,bl.burdened_cost projfunc_burdened_cost
14145: ,bl.revenue projfunc_revenue
14146: FROM pa_budget_lines bl,
14147: pa_resource_assignments ra,
14148: pa_resource_list_members rlm
14149: WHERE bl.budget_version_id = c_budget_version_id
14150: AND bl.resource_assignment_id = ra.resource_assignment_id

Line 14220: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */

14216: l_entry_level pa_budget_entry_methods.entry_level_code%type; /* 2207723 */
14217:
14218: p_multiple_task_msg VARCHAR2(1) := 'T';
14219:
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;

Line 14223: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

14219:
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;

Line 14329: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;

14325: l_resource_id pa_resource_txn_attributes.resource_id%type;
14326: l_resource_name per_all_people_f.full_name%type;
14327: l_locked_by_name per_people_x.full_name%type;
14328:
14329: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
14330: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
14331: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14332:
14333: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE

Line 14330: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;

14326: l_resource_name per_all_people_f.full_name%type;
14327: l_locked_by_name per_people_x.full_name%type;
14328:
14329: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
14330: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
14331: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14332:
14333: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14334: INDEX BY BINARY_INTEGER;

Line 14331: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;

14327: l_locked_by_name per_people_x.full_name%type;
14328:
14329: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
14330: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
14331: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14332:
14333: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14334: INDEX BY BINARY_INTEGER;
14335: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE

Line 14333: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE

14329: l_rw_cost_rate_override pa_budget_lines.txn_cost_rate_override%TYPE;
14330: l_burden_cost_rate_override pa_budget_lines.burden_cost_rate_override%TYPE;
14331: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14332:
14333: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14334: INDEX BY BINARY_INTEGER;
14335: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE
14336: INDEX BY BINARY_INTEGER;
14337: TYPE l_bill_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_bill_rate_override%TYPE

Line 14335: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE

14331: l_bill_rate_override pa_budget_lines.txn_bill_rate_override%TYPE;
14332:
14333: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14334: INDEX BY BINARY_INTEGER;
14335: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE
14336: INDEX BY BINARY_INTEGER;
14337: TYPE l_bill_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_bill_rate_override%TYPE
14338: INDEX BY BINARY_INTEGER;
14339:

Line 14337: TYPE l_bill_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_bill_rate_override%TYPE

14333: TYPE l_rw_cost_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_cost_rate_override%TYPE
14334: INDEX BY BINARY_INTEGER;
14335: TYPE l_burdn_cst_rte_override_tbl_t IS TABLE OF pa_budget_lines.burden_cost_rate_override%TYPE
14336: INDEX BY BINARY_INTEGER;
14337: TYPE l_bill_rate_override_tbl_t IS TABLE OF pa_budget_lines.txn_bill_rate_override%TYPE
14338: INDEX BY BINARY_INTEGER;
14339:
14340: l_rw_cost_rate_override_tbl l_rw_cost_rate_override_tbl_t;
14341: l_burden_cst_rate_override_tbl l_burdn_cst_rte_override_tbl_t;

Line 16195: UPDATE pa_budget_lines

16191: IF p_multiple_task_msg <> 'F' THEN
16192: IF l_context = l_context_budget
16193: THEN
16194: FORALL i IN l_rowid_tbl.first .. l_rowid_tbl.last
16195: UPDATE pa_budget_lines
16196: SET raw_cost = l_txn_raw_cost_tbl(i),
16197: burdened_cost = l_txn_burdened_cost_tbl(i),
16198: revenue = l_txn_revenue_tbl(i),
16199: last_update_date = SYSDATE,

Line 16205: UPDATE pa_budget_lines

16201: last_update_login = G_LOGIN_ID
16202: WHERE rowid = l_rowid_tbl(i);
16203: ELSE
16204: FORALL i IN l_rowid_tbl.first .. l_rowid_tbl.last
16205: UPDATE pa_budget_lines
16206: SET quantity = l_quantity_tbl(i),
16207: display_quantity = l_display_quantity_tbl(i), --IPM Arch Enhancements Bug 4865563
16208: txn_raw_cost = l_txn_raw_cost_tbl(i),
16209: txn_burdened_cost = l_txn_burdened_cost_tbl(i),

Line 18710: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

18706: ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18707: ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18708: ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18709: ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18710: ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18711: ,P_UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18712: ,P_START_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_START_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
18713: ,P_END_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_END_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
18714: ,P_QUANTITY NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 19523: from pa_budget_lines

19519: end;*/
19520: l_resource_assignment_id_tbl(i) := pa_budget_pvt.G_res_assign_tbl(i).resource_assignment_id;
19521: begin
19522: select txn_currency_code into l_currency_code_tbl(i)
19523: from pa_budget_lines
19524: where resource_assignment_id=l_resource_assignment_id_tbl(i)
19525: and rownum=1;
19526: exception when no_data_found then
19527: l_currency_code_tbl(i):=l_currency_code;