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.PJI_FM_SUM_PSI dependencies on PJI_FP_TXN_ACCUM

Line 157: from PJI_FP_TXN_ACCUM bal

153: from PJI_FM_PROJ_BATCH_MAP map
154: where map.WORKER_ID = p_worker_id);
155:
156: delete
157: from PJI_FP_TXN_ACCUM bal
158: where bal.PROJECT_ID in (select map.PROJECT_ID
159: from PJI_FM_PROJ_BATCH_MAP map
160: where map.WORKER_ID = p_worker_id);
161: /*

Line 225: from PJI_FP_TXN_ACCUM1 bal

221: from PJI_FM_PROJ_BATCH_MAP map
222: where map.WORKER_ID = p_worker_id);
223:
224: delete
225: from PJI_FP_TXN_ACCUM1 bal
226: where bal.PROJECT_ID in (select map.PROJECT_ID
227: from PJI_FM_PROJ_BATCH_MAP map
228: where map.WORKER_ID = p_worker_id);
229:

Line 2367: insert /+ append parallel(hdr_i) / into PJI_FP_TXN_ACCUM_HEADER hdr_i

2363: l_creation_date := sysdate;
2364: l_created_by := FND_GLOBAL.USER_ID;
2365: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2366:
2367: insert /*+ append parallel(hdr_i) */ into PJI_FP_TXN_ACCUM_HEADER hdr_i
2368: (
2369: TXN_ACCUM_HEADER_ID,
2370: PERSON_ID,
2371: EXPENDITURE_ORG_ID,

Line 2403: PJI_FP_TXN_ACCUM_HEADER_S.NEXTVAL TXN_ACCUM_HEADER_ID,

2399: LAST_UPDATE_LOGIN,
2400: CBS_ELEMENT_ID /* Added for CBS Changes */
2401: )
2402: select
2403: PJI_FP_TXN_ACCUM_HEADER_S.NEXTVAL TXN_ACCUM_HEADER_ID,
2404: PERSON_ID,
2405: EXPENDITURE_ORG_ID,
2406: EXPENDITURE_ORGANIZATION_ID,
2407: RESOURCE_CLASS_ID,

Line 2475: PJI_FP_TXN_ACCUM_HEADER hdr

2471: not exists
2472: (select
2473: 1
2474: from
2475: PJI_FP_TXN_ACCUM_HEADER hdr
2476: where
2477: tmp6.PERSON_ID = hdr.PERSON_ID and
2478: tmp6.EXPENDITURE_ORG_ID = hdr.EXPENDITURE_ORG_ID and
2479: tmp6.EXPENDITURE_ORGANIZATION_ID = hdr.EXPENDITURE_ORGANIZATION_ID and

Line 2549: insert /+ append parallel(bal) / into PJI_FP_TXN_ACCUM bal

2545:
2546: if (l_extraction_type = 'FULL' or
2547: l_extraction_type = 'PARTIAL') then
2548:
2549: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM bal
2550: (
2551: TXN_ACCUM_HEADER_ID,
2552: RESOURCE_CLASS_ID,
2553: PROJECT_ID,

Line 2656: PJI_FP_TXN_ACCUM_HEADER hdr

2652: l_last_update_login LAST_UPDATE_LOGIN,
2653: tmp6.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
2654: from
2655: PJI_FM_AGGR_FIN6 tmp6,
2656: PJI_FP_TXN_ACCUM_HEADER hdr
2657: where
2658: tmp6.WORKER_ID = p_worker_id and
2659: tmp6.RECORD_TYPE = 'A' and
2660: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 2862: PJI_FP_TXN_ACCUM_HEADER hdr

2858: tmp6.G2_OTH_COMMITTED_COST,
2859: tmp6.CBS_ELEMENT_ID /* Added for CBS Changes */
2860: from
2861: PJI_FM_AGGR_FIN6 tmp6,
2862: PJI_FP_TXN_ACCUM_HEADER hdr
2863: where
2864: tmp6.WORKER_ID = p_worker_id and
2865: tmp6.PERSON_ID = hdr.PERSON_ID and
2866: tmp6.EXPENDITURE_ORG_ID = hdr.EXPENDITURE_ORG_ID and

Line 2914: PJI_FP_TXN_ACCUM_HEADER hdr,

2910: select
2911: distinct tmp6.PROJECT_ID
2912: from
2913: PJI_FM_AGGR_FIN6 tmp6,
2914: PJI_FP_TXN_ACCUM_HEADER hdr,
2915: pa_projects_all prj
2916: where
2917: tmp6.WORKER_ID = p_worker_id and
2918: tmp6.RECORD_TYPE = 'A' and

Line 3111: PJI_FP_TXN_ACCUM_HEADER hdr,

3107: tmp6.G2_PR_COMMITTED_COST,
3108: tmp6.G2_OTH_COMMITTED_COST
3109: from
3110: PJI_FM_AGGR_FIN6 tmp6,
3111: PJI_FP_TXN_ACCUM_HEADER hdr,
3112: pa_projects_all prj
3113: where
3114: tmp6.WORKER_ID = p_worker_id and
3115: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 3190: insert /+ append parallel(bal) / into PJI_FP_TXN_ACCUM bal

3186: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3187:
3188: if (l_extraction_type = 'INCREMENTAL') then
3189:
3190: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM bal
3191: (
3192: TXN_ACCUM_HEADER_ID,
3193: RESOURCE_CLASS_ID,
3194: PROJECT_ID,

Line 3297: PJI_FP_TXN_ACCUM_HEADER hdr

3293: l_last_update_login LAST_UPDATE_LOGIN,
3294: tmp6.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
3295: from
3296: PJI_FM_AGGR_FIN6 tmp6,
3297: PJI_FP_TXN_ACCUM_HEADER hdr
3298: where
3299: tmp6.WORKER_ID = p_worker_id and
3300: tmp6.RECORD_TYPE = 'A' and
3301: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 3363: PJI_FP_TXN_ACCUM_HEADER hdr,

3359: select
3360: tmp6.PROJECT_ID
3361: from
3362: PJI_FM_AGGR_FIN6 tmp6,
3363: PJI_FP_TXN_ACCUM_HEADER hdr,
3364: pa_projects_all prj
3365: where
3366: tmp6.WORKER_ID = p_worker_id and
3367: tmp6.RECORD_TYPE = 'A' and

Line 3460: insert /+ append parallel(bal) / into PJI_FP_TXN_ACCUM1 bal

3456:
3457: -- Only insert commitments during FULL run since INCREMENTAL commitments
3458: -- data is handled at the same time as INCREMETNAL actuals data above.
3459:
3460: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal
3461: (
3462: TXN_ACCUM_HEADER_ID,
3463: PROJECT_ID,
3464: PROJECT_ORG_ID,

Line 3545: PJI_FP_TXN_ACCUM_HEADER hdr

3541: l_last_update_login LAST_UPDATE_LOGIN,
3542: tmp6.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
3543: from
3544: PJI_FM_AGGR_FIN6 tmp6,
3545: PJI_FP_TXN_ACCUM_HEADER hdr
3546: where
3547: tmp6.WORKER_ID = p_worker_id and
3548: tmp6.RECORD_TYPE = 'M' and
3549: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 3610: PJI_FP_TXN_ACCUM_HEADER hdr,

3606: select
3607: tmp6.PROJECT_ID
3608: from
3609: PJI_FM_AGGR_FIN6 tmp6,
3610: PJI_FP_TXN_ACCUM_HEADER hdr,
3611: pa_projects_all prj
3612: where
3613: tmp6.WORKER_ID = p_worker_id and
3614: tmp6.RECORD_TYPE = 'M' and

Line 3700: insert /+ append parallel(bal) / into PJI_FP_TXN_ACCUM1 bal

3696: l_last_update_login := FND_GLOBAL.LOGIN_ID;
3697:
3698: if (l_extraction_type = 'INCREMENTAL' and l_extract_commitments = 'Y') then
3699:
3700: insert /*+ append parallel(bal) */ into PJI_FP_TXN_ACCUM1 bal
3701: (
3702: TXN_ACCUM_HEADER_ID,
3703: PROJECT_ID,
3704: PROJECT_ORG_ID,

Line 3785: PJI_FP_TXN_ACCUM_HEADER hdr

3781: l_last_update_login LAST_UPDATE_LOGIN,
3782: tmp6.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
3783: from
3784: PJI_FM_AGGR_FIN6 tmp6,
3785: PJI_FP_TXN_ACCUM_HEADER hdr
3786: where
3787: tmp6.WORKER_ID = p_worker_id and
3788: tmp6.RECORD_TYPE = 'M' and
3789: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 3845: PJI_FP_TXN_ACCUM_HEADER hdr,

3841: select
3842: tmp6.PROJECT_ID
3843: from
3844: PJI_FM_AGGR_FIN6 tmp6,
3845: PJI_FP_TXN_ACCUM_HEADER hdr,
3846: pa_projects_all prj
3847: where
3848: tmp6.WORKER_ID = p_worker_id and
3849: tmp6.RECORD_TYPE = 'M' and

Line 4175: PJI_FP_TXN_ACCUM psi

4171: tmp7.RECORD_TYPE
4172: from
4173: PJI_PJP_PROJ_BATCH_MAP map,
4174: PJI_FM_AGGR_FIN7 tmp7,
4175: PJI_FP_TXN_ACCUM psi
4176: where
4177: map.WORKER_ID = p_worker_id and
4178: tmp7.PROJECT_ID = map.PROJECT_ID and
4179: tmp7.RECORD_TYPE = 'A' and

Line 4262: update PJI_FP_TXN_ACCUM psi

4258: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4259:
4260: if (l_extraction_type = 'INCREMENTAL') then
4261:
4262: update PJI_FP_TXN_ACCUM psi
4263: set (TXN_RAW_COST,
4264: TXN_BILL_RAW_COST,
4265: TXN_BRDN_COST,
4266: TXN_BILL_BRDN_COST,

Line 4463: insert /+ append parallel(bal_i) / into PJI_FP_TXN_ACCUM bal_i

4459: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4460:
4461: if (l_extraction_type = 'INCREMENTAL') then
4462:
4463: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM bal_i
4464: (
4465: TXN_ACCUM_HEADER_ID,
4466: RESOURCE_CLASS_ID,
4467: PROJECT_ID,

Line 4674: from PJI_FP_TXN_ACCUM1 bal

4670:
4671: if (l_extraction_type = 'INCREMENTAL') then
4672:
4673: delete
4674: from PJI_FP_TXN_ACCUM1 bal
4675: where bal.PROJECT_ID in (select distinct
4676: fin7.PROJECT_ID
4677: from PJI_PJP_RMAP_FPR tmp7_r,
4678: PJI_FM_AGGR_FIN7 fin7

Line 4734: insert /+ append parallel(bal_i) / into PJI_FP_TXN_ACCUM1 bal_i

4730: l_last_update_login := FND_GLOBAL.LOGIN_ID;
4731:
4732: if (l_extraction_type = 'INCREMENTAL') then
4733:
4734: insert /*+ append parallel(bal_i) */ into PJI_FP_TXN_ACCUM1 bal_i
4735: (
4736: TXN_ACCUM_HEADER_ID,
4737: PROJECT_ID,
4738: PROJECT_ORG_ID,