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_FP_PLANNING_TRANSACTION_PUB dependencies on PA_RESOURCE_ASGN_CURR_TMP

Line 5831: delete pa_resource_asgn_curr_tmp;

5827: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5828: END IF;
5829:
5830: -- IPM changes - populate tmp table to use for rollup
5831: delete pa_resource_asgn_curr_tmp;
5832:
5833: IF l_ra_id_temp_tbl.COUNT > 0 THEN
5834: -- IPM - populate the currency code
5835: l_curr_code_temp_tbl.extend(l_ra_id_temp_tbl.COUNT);

Line 5851: INSERT INTO pa_resource_asgn_curr_tmp

5847: END IF;
5848: END LOOP;
5849:
5850: FORALL i IN l_ra_id_temp_tbl.first .. l_ra_id_temp_tbl.last
5851: INSERT INTO pa_resource_asgn_curr_tmp
5852: (RA_TXN_ID
5853: ,RESOURCE_ASSIGNMENT_ID
5854: ,TXN_CURRENCY_CODE
5855: ,DELETE_FLAG

Line 8161: INSERT INTO pa_resource_asgn_curr_tmp

8157: /*
8158: IF l_resource_assignment_id_tbl.COUNT > 0 THEN
8159: FORALL i IN l_resource_assignment_id_tbl.first ..
8160: l_resource_assignment_id_tbl.last
8161: INSERT INTO pa_resource_asgn_curr_tmp
8162: (RA_TXN_ID
8163: ,RESOURCE_ASSIGNMENT_ID
8164: ,TXN_CURRENCY_CODE
8165: ,DELETE_FLAG

Line 8725: DELETE pa_resource_asgn_curr_tmp;

8721: IF l_calculate_flag = 'Y' then
8722:
8723: -- IPM changes - populate tmp table to use for rollup
8724: -- Bug 5034507: Delete temp table before inserting new records
8725: DELETE pa_resource_asgn_curr_tmp;
8726:
8727: -- For bug 5017855, ensure that the combinations of
8728: -- (resource_assignment_id, txn_currency_code) are distinct.
8729: -- Bug 5042399: Copy Source override rates to the temp table for Target resources.

Line 8731: INSERT INTO pa_resource_asgn_curr_tmp (

8727: -- For bug 5017855, ensure that the combinations of
8728: -- (resource_assignment_id, txn_currency_code) are distinct.
8729: -- Bug 5042399: Copy Source override rates to the temp table for Target resources.
8730: -- Bug 5070740: Need to copy override rates before calculate is called
8731: INSERT INTO pa_resource_asgn_curr_tmp (
8732: RESOURCE_ASSIGNMENT_ID,
8733: TXN_CURRENCY_CODE,
8734: TXN_RAW_COST_RATE_OVERRIDE,
8735: TXN_BURDEN_COST_RATE_OVERRIDE,

Line 9176: DELETE pa_resource_asgn_curr_tmp;

9172: END IF;
9173:
9174: -- IPM changes - populate tmp table to use for rollup
9175: -- Bug 5034507: Delete temp table before inserting new records
9176: DELETE pa_resource_asgn_curr_tmp;
9177:
9178: -- For bug 5017855, ensure that the combinations of
9179: -- (resource_assignment_id, txn_currency_code) are distinct.
9180: -- Bug 5042399: Copy Source override rates to the temp table for Target resources.

Line 9181: INSERT INTO pa_resource_asgn_curr_tmp (

9177:
9178: -- For bug 5017855, ensure that the combinations of
9179: -- (resource_assignment_id, txn_currency_code) are distinct.
9180: -- Bug 5042399: Copy Source override rates to the temp table for Target resources.
9181: INSERT INTO pa_resource_asgn_curr_tmp (
9182: RESOURCE_ASSIGNMENT_ID,
9183: TXN_CURRENCY_CODE,
9184: TXN_RAW_COST_RATE_OVERRIDE,
9185: TXN_BURDEN_COST_RATE_OVERRIDE,

Line 9423: delete pa_resource_asgn_curr_tmp;

9419: l_cbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ; --bug#16688443
9420:
9421: BEGIN
9422:
9423: delete pa_resource_asgn_curr_tmp;
9424: x_msg_count := 0;
9425: x_return_status := FND_API.G_RET_STS_SUCCESS;
9426:
9427: pa_task_assignment_utils.g_require_progress_rollup := 'N';

Line 9863: INSERT INTO pa_resource_asgn_curr_tmp

9859: -- IPM changes - populate tmp table to use for deletion later
9860: IF l_resource_assignment_id_tbl.COUNT > 0 THEN
9861: FORALL i IN l_resource_assignment_id_tbl.first ..
9862: l_resource_assignment_id_tbl.last
9863: INSERT INTO pa_resource_asgn_curr_tmp
9864: (RA_TXN_ID
9865: ,RESOURCE_ASSIGNMENT_ID
9866: ,TXN_CURRENCY_CODE
9867: ,DELETE_FLAG

Line 9909: INSERT INTO pa_resource_asgn_curr_tmp

9905: -- hr_utility.trace('RM DEL4');
9906: IF l_ra_id_in_pra_tbl.COUNT > 0 THEN
9907: FORALL i IN l_ra_id_in_pra_tbl.first ..
9908: l_ra_id_in_pra_tbl.last
9909: INSERT INTO pa_resource_asgn_curr_tmp
9910: (RA_TXN_ID
9911: ,RESOURCE_ASSIGNMENT_ID
9912: -- ,TXN_CURRENCY_CODE
9913: ,DELETE_FLAG

Line 10016: INSERT INTO pa_resource_asgn_curr_tmp

10012: -- hr_utility.trace('RM DEL6');
10013: IF l_resource_assignment_id_tbl.COUNT > 0 THEN
10014: FORALL i IN l_resource_assignment_id_tbl.first ..
10015: l_resource_assignment_id_tbl.last
10016: INSERT INTO pa_resource_asgn_curr_tmp
10017: (RA_TXN_ID
10018: ,RESOURCE_ASSIGNMENT_ID
10019: -- ,TXN_CURRENCY_CODE
10020: ,DELETE_FLAG

Line 10061: INSERT INTO pa_resource_asgn_curr_tmp

10057: -- hr_utility.trace('RM DEL3');
10058: IF l_ra_id_in_pra_tbl.COUNT > 0 THEN
10059: FORALL i IN l_ra_id_in_pra_tbl.first ..
10060: l_ra_id_in_pra_tbl.last
10061: INSERT INTO pa_resource_asgn_curr_tmp
10062: (RA_TXN_ID
10063: ,RESOURCE_ASSIGNMENT_ID
10064: -- ,TXN_CURRENCY_CODE
10065: ,DELETE_FLAG

Line 10183: INSERT INTO pa_resource_asgn_curr_tmp

10179: -- hr_utility.trace('RM DEL5');
10180: IF l_resource_assignment_id_tbl.COUNT > 0 THEN
10181: FORALL i IN l_resource_assignment_id_tbl.first ..
10182: l_resource_assignment_id_tbl.last
10183: INSERT INTO pa_resource_asgn_curr_tmp
10184: (RA_TXN_ID
10185: ,RESOURCE_ASSIGNMENT_ID
10186: -- ,TXN_CURRENCY_CODE
10187: ,DELETE_FLAG

Line 10240: INSERT INTO pa_resource_asgn_curr_tmp

10236: -- hr_utility.trace('RM DEL8');
10237: IF l_ra_id_in_pra_tbl.COUNT > 0 THEN
10238: FORALL i IN l_ra_id_in_pra_tbl.first ..
10239: l_ra_id_in_pra_tbl.last
10240: INSERT INTO pa_resource_asgn_curr_tmp
10241: (RA_TXN_ID
10242: ,RESOURCE_ASSIGNMENT_ID
10243: -- ,TXN_CURRENCY_CODE
10244: ,DELETE_FLAG

Line 10408: INSERT INTO pa_resource_asgn_curr_tmp

10404: -- hr_utility.trace('RM DEL1');
10405: IF l_resource_assignment_id_tbl.COUNT > 0 THEN
10406: FORALL i IN l_resource_assignment_id_tbl.first ..
10407: l_resource_assignment_id_tbl.last
10408: INSERT INTO pa_resource_asgn_curr_tmp
10409: (RA_TXN_ID
10410: ,RESOURCE_ASSIGNMENT_ID
10411: ,TXN_CURRENCY_CODE -- Bug 5057010
10412: ,DELETE_FLAG

Line 10463: INSERT INTO pa_resource_asgn_curr_tmp

10459: -- IPM changes - populate temp table for deletion
10460: IF l_ra_id_in_pra_tbl.COUNT > 0 THEN
10461: FORALL i IN l_ra_id_in_pra_tbl.first ..
10462: l_ra_id_in_pra_tbl.last
10463: INSERT INTO pa_resource_asgn_curr_tmp
10464: (RA_TXN_ID
10465: ,RESOURCE_ASSIGNMENT_ID
10466: -- ,TXN_CURRENCY_CODE
10467: ,DELETE_FLAG

Line 10498: -- if records have been inserted in pa_Resource_asgn_curr_tmp, in the delete flow.

10494:
10495: -- IPM changes - delete from new entity --{
10496: -- new entity maintenance api to be called before call to pa_fp_rollup_pkg.rollup_budget_version.
10497: -- Call new entity maintenance api for the budget version id (which has to be derived),
10498: -- if records have been inserted in pa_Resource_asgn_curr_tmp, in the delete flow.
10499: -- Note: Deriving l_budget_version_id may not be the right approach as we avoid calling BV/RA
10500: -- rollup api and pji api when l_budget_version_id is null (No BLs deleted)
10501: IF l_budget_version_id IS NOT NULL THEN
10502: pa_debug.g_err_stage:='Calling pa_fp_gen_amount_utils.get_plan_version_dtls:bv_id ' || l_budget_version_id;

Line 11784: INSERT INTO pa_resource_asgn_curr_tmp

11780: RETURNING resource_assignment_id BULK COLLECT INTO l_delete_ra_id_tbl;
11781: /* Bug 5754758 - Commenting the code, as the maintain_data is now called in version level mode to delete the RACs.
11782: IF l_delete_ra_id_tbl.COUNT > 0 THEN
11783: FORALL i IN l_delete_ra_id_tbl.first .. l_delete_ra_id_tbl.last
11784: INSERT INTO pa_resource_asgn_curr_tmp
11785: (RA_TXN_ID
11786: ,RESOURCE_ASSIGNMENT_ID
11787: ,DELETE_FLAG
11788: )

Line 11914: INSERT INTO pa_resource_asgn_curr_tmp

11910: END IF;
11911: --Bug 13701718 CBS related Chnages end here
11912: IF l_delete_ra_id_tbl.COUNT > 0 THEN
11913: FORALL i IN l_delete_ra_id_tbl.first .. l_delete_ra_id_tbl.last
11914: INSERT INTO pa_resource_asgn_curr_tmp
11915: (RA_TXN_ID
11916: ,RESOURCE_ASSIGNMENT_ID
11917: ,DELETE_FLAG
11918: )