APPS.PA_RES_ACCUMS dependencies on PA_RESOURCE_LIST_PARENTS_TMP

Line 1973: PA_RESOURCE_LIST_PARENTS_TMP temp table. Currently oracle projects allows

1969: /* Logical Flow of this API
1970:
1971: 1. In case resource list to which mapping needs to be done is grouped.
1972: 1.1 Insert all parents in resource list and their attributes into
1973: PA_RESOURCE_LIST_PARENTS_TMP temp table. Currently oracle projects allows
1974: resource list to be grouped only by organization, expenditure_category
1975: and revenue_category. Hence PA_RESOURCE_LIST_PARENTS_TMP table has only
1976: these three attributes.
1977:

Line 1975: and revenue_category. Hence PA_RESOURCE_LIST_PARENTS_TMP table has only

1971: 1. In case resource list to which mapping needs to be done is grouped.
1972: 1.1 Insert all parents in resource list and their attributes into
1973: PA_RESOURCE_LIST_PARENTS_TMP temp table. Currently oracle projects allows
1974: resource list to be grouped only by organization, expenditure_category
1975: and revenue_category. Hence PA_RESOURCE_LIST_PARENTS_TMP table has only
1976: these three attributes.
1977:
1978: 1.2 Now assign parents to each transaction in PA_MAPPABLE_TXNS_TMP table. This can
1979: be done by matching organization, expenditure_category or revenue_category

Line 1980: of the txn with that in PA_RESOURCE_LIST_PARENTS_TMP.

1976: these three attributes.
1977:
1978: 1.2 Now assign parents to each transaction in PA_MAPPABLE_TXNS_TMP table. This can
1979: be done by matching organization, expenditure_category or revenue_category
1980: of the txn with that in PA_RESOURCE_LIST_PARENTS_TMP.
1981:
1982: 1.3 At this point if parent could not be assigned then the txn should be
1983: assigned to list level unclassified resource.
1984:

Line 2337: delete from pa_resource_list_parents_tmp;

2333: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2334: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);
2335: END IF;
2336:
2337: delete from pa_resource_list_parents_tmp;
2338:
2339: /* PA_RESOURCE_LIST_PARENTS_TMP is a global temp table used by this process only.
2340: This table will have only one of the columns, either ORGANIZATION_ID or
2341: REVENUE_CATEGORY or EXPENDITURE_CATEGORY as NOT NULL, since PA_RESOURCE_LIST_MEMBERS

Line 2339: /* PA_RESOURCE_LIST_PARENTS_TMP is a global temp table used by this process only.

2335: END IF;
2336:
2337: delete from pa_resource_list_parents_tmp;
2338:
2339: /* PA_RESOURCE_LIST_PARENTS_TMP is a global temp table used by this process only.
2340: This table will have only one of the columns, either ORGANIZATION_ID or
2341: REVENUE_CATEGORY or EXPENDITURE_CATEGORY as NOT NULL, since PA_RESOURCE_LIST_MEMBERS
2342: can be grouped by any one of these three attributes only */
2343:

Line 2346: x_err_stage := 'Inserting into pa_resource_list_parents_tmp table';

2342: can be grouped by any one of these three attributes only */
2343:
2344: /* Point 1.1 */
2345:
2346: x_err_stage := 'Inserting into pa_resource_list_parents_tmp table';
2347: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2348: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);
2349: END IF;
2350:

Line 2351: INSERT INTO pa_resource_list_parents_tmp

2347: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2348: pa_debug.debug('update_parents_mem_id: ' || x_err_stage);
2349: END IF;
2350:
2351: INSERT INTO pa_resource_list_parents_tmp
2352: (resource_list_id
2353: ,resource_list_member_id
2354: ,resource_id
2355: ,organization_id

Line 2374: pa_debug.debug('update_parents_mem_id: ' || 'Inserted ' || sql%rowcount || ' rows into pa_resource_list_parents_tmp');

2370: AND prlm.enabled_flag = 'Y'
2371: );
2372:
2373: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2374: pa_debug.debug('update_parents_mem_id: ' || 'Inserted ' || sql%rowcount || ' rows into pa_resource_list_parents_tmp');
2375: END IF;
2376:
2377: /* Determine parent for each transaction in PA_MAPPABLE_TXNS_TMP.
2378: As parents can be only organizations, expenditure category or revenue category,

Line 2393: FROM pa_resource_list_parents_tmp PRLP

2389:
2390: UPDATE pa_mappable_txns_tmp PMT
2391: SET (parent_member_id, parent_resource_id) =
2392: (SELECT resource_list_member_id, resource_id
2393: FROM pa_resource_list_parents_tmp PRLP
2394: WHERE (pmt.expenditure_category = prlp.expenditure_category
2395: OR pmt.organization_id = prlp.organization_id
2396: OR pmt.revenue_category = prlp.revenue_category)
2397: AND pmt.resource_list_id = prlp.resource_list_id);