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 2090: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2086: SAVEPOINT map_rbs_txn;
2087:
2088: SELECT distinct head.revenue_category
2089: BULK COLLECT INTO l_revenue_category
2090: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2091: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2092: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2093: AND head.revenue_category IS NOT NULL
2094: AND head.revenue_category NOT IN

Line 2158: pji_fp_txn_accum_header head

2154: decode(head.person_id,-1,null,head.person_id), --- named person
2155: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2156: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2157: FROM pa_rbs_map_tmp1 tmp,
2158: pji_fp_txn_accum_header head
2159: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2160: tmp.txn_accum_header_id = head.txn_accum_header_id;
2161:
2162:

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

2284: pa_debug.g_err_stage:= 'rbs version is provided';
2285: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2286: END IF;
2287:
2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header
2290:
2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required

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

2285: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2286: END IF;
2287:
2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header
2290:
2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2293:

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

2287:
2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header
2290:
2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2293:
2294: SELECT distinct revenue_category_code
2295: BULK COLLECT INTO l_revenue_category

Line 2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required

2288: --check whether headers are present in pji_fp_txn_accum_header or not, if not then create them in pji_fp_txn_accum_header
2289: --assuming that source_id is populated in pji_fp_txn_accum_header
2290:
2291: -- PJI_FP_TXN_ACCUM_HEADER will have -1 for NUMBER columns and PJI$NULL for varchar columns and hence nvl
2292: -- on PJI_FP_TXN_ACCUM_HEADER columns is not required
2293:
2294: SELECT distinct revenue_category_code
2295: BULK COLLECT INTO l_revenue_category
2296: FROM PA_RBS_PLANS_IN_TMP

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

2324: END;
2325:
2326:
2327: /* added for bug#4102476, 4101364 */
2328: lockhndl := auto_allocate_unique('LOCK_PJI_FP_TXN_ACCUM_HEADER');
2329: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;
2330: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2331: raise can_not_lock_header;
2332: END IF;

Line 2334: INSERT INTO PJI_FP_TXN_ACCUM_HEADER(

2330: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2331: raise can_not_lock_header;
2332: END IF;
2333:
2334: INSERT INTO PJI_FP_TXN_ACCUM_HEADER(
2335: txn_accum_header_id,
2336: vendor_id,
2337: project_role_id,
2338: revenue_category,

Line 2367: PJI_FP_TXN_ACCUM_HEADER_S.nextval ,

2363: CREATION_DATE,
2364: CREATED_BY,
2365: LAST_UPDATE_LOGIN )
2366: SELECT
2367: PJI_FP_TXN_ACCUM_HEADER_S.nextval ,
2368: decode(TAB1.supplier_id,null,-1,TAB1.supplier_id),
2369: decode(TAB1.role_id,null,-1,TAB1.role_id),
2370: decode(TAB1.revenue_category_code,null,'PJI$NULL',TAB1.revenue_category_code),
2371: decode(TAB1.resource_class_id,null,-1,TAB1.resource_class_id) ,

Line 2420: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2416: person_type_code
2417: FROM PA_RBS_PLANS_IN_TMP
2418: WHERE rowid NOT IN
2419: (SELECT /*+ ordered */ tmp.rowid
2420: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2421: WHERE
2422: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2423: head.project_role_id = nvl(tmp.role_id,-1) AND
2424: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND

Line 2502: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head

2498: tmp.person_id,
2499: tmp.bom_equipment_id,
2500: tmp.bom_labor_id,
2501: tmp.person_type_code
2502: FROM PA_RBS_PLANS_IN_TMP tmp, PJI_FP_TXN_ACCUM_HEADER head
2503: WHERE
2504: head.vendor_id = nvl(tmp.supplier_id,-1) AND
2505: head.project_role_id = nvl(tmp.role_id,-1) AND
2506: head.revenue_category = nvl(tmp.revenue_category_code,'PJI$NULL') AND