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_RBS_MAPPING dependencies on PJI_FP_TXN_ACCUM_HEADER

Line 2119: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2115: SAVEPOINT map_rbs_txn;
2116:
2117: SELECT distinct head.revenue_category
2118: BULK COLLECT INTO l_revenue_category
2119: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2120: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2121: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2122: AND head.revenue_category IS NOT NULL
2123: AND head.revenue_category NOT IN

Line 2187: pji_fp_txn_accum_header head

2183: decode(head.person_id,-1,null,head.person_id), --- named person
2184: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2185: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2186: FROM pa_rbs_map_tmp1 tmp,
2187: pji_fp_txn_accum_header head
2188: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2189: tmp.txn_accum_header_id = head.txn_accum_header_id;
2190:
2191:

Line 2450: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2446: SAVEPOINT map_rbs_txn;
2447:
2448: SELECT distinct head.revenue_category
2449: BULK COLLECT INTO l_revenue_category
2450: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2451: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2452: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2453: AND head.revenue_category IS NOT NULL
2454: AND head.revenue_category NOT IN

Line 2518: pji_fp_txn_accum_header head

2514: decode(head.person_id,-1,null,head.person_id), --- named person
2515: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2516: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2517: FROM pa_rbs_map_tmp1 tmp,
2518: pji_fp_txn_accum_header head
2519: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2520: tmp.txn_accum_header_id = head.txn_accum_header_id;
2521:
2522:

Line 2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header

2619: pa_debug.g_err_stage:= 'rbs version is provided';
2620: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2621: END IF;
2622:
2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header
2625:
2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required

Line 2624: --assuming that source_id is populated in pji_fp_txn_accum_header

2620: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2621: END IF;
2622:
2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header
2625:
2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2628:

Line 2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl

2622:
2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header
2625:
2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2628:
2629: SELECT distinct revenue_category_code
2630: BULK COLLECT INTO l_revenue_category

Line 2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required

2623: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2624: --assuming that source_id is populated in pji_fp_txn_accum_header
2625:
2626: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2627: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2628:
2629: SELECT distinct revenue_category_code
2630: BULK COLLECT INTO l_revenue_category
2631: FROM PA_RBS_PLANS_IN_TMP

Line 2663: lockhndl := auto_allocate_unique('LOCK_PJI_FP_TXN_ACCUM_HEADER');

2659: END;
2660:
2661:
2662: /* added for bug#4102476, 4101364 */
2663: lockhndl := auto_allocate_unique('LOCK_PJI_FP_TXN_ACCUM_HEADER');
2664: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;
2665: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2666: raise can_not_lock_header;
2667: END IF;

Line 2669: INSERT INTO PJI_FP_TXN_ACCUM_HEADER(

2665: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2666: raise can_not_lock_header;
2667: END IF;
2668:
2669: INSERT INTO PJI_FP_TXN_ACCUM_HEADER(
2670: txn_accum_header_id,
2671: vendor_id,
2672: project_role_id,
2673: revenue_category,

Line 2702: PJI_FP_TXN_ACCUM_HEADER_S.nextval ,

2698: CREATION_DATE,
2699: CREATED_BY,
2700: LAST_UPDATE_LOGIN )
2701: SELECT
2702: PJI_FP_TXN_ACCUM_HEADER_S.nextval ,
2703: decode(TAB1.supplier_id,null,-1,TAB1.supplier_id),
2704: decode(TAB1.role_id,null,-1,TAB1.role_id),
2705: decode(TAB1.revenue_category_code,null,'PJI$NULL',TAB1.revenue_category_code),
2706: decode(TAB1.resource_class_id,null,-1,TAB1.resource_class_id) ,

Line 2755: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2751: person_type_code
2752: FROM PA_RBS_PLANS_IN_TMP
2753: WHERE rowid NOT IN
2754: (SELECT /*+ ordered */ tmp.rowid
2755: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2756: WHERE
2757: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2758: head.project_role_id = nvl(tmp.role_id,-1) AND
2759: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND

Line 2837: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2833: tmp.person_id,
2834: tmp.bom_equipment_id,
2835: tmp.bom_labor_id,
2836: tmp.person_type_code
2837: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2838: WHERE
2839: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2840: head.project_role_id = nvl(tmp.role_id,-1) AND
2841: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND