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.GME_CREATE_STEP_PVT dependencies on GME_RESOURCE_TXNS

Line 471: -- Create data for GME_BATCH_STEP_RESOURCES and GME_RESOURCE_TXNS...

467: END LOOP; /* WHILE i IS NOT NULL; STEP ACTIVITIES */
468:
469: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
470: gme_debug.put_line ('Completed GME_BATCH_STEP_ACTIVITIES');
471: -- Create data for GME_BATCH_STEP_RESOURCES and GME_RESOURCE_TXNS...
472: gme_debug.put_line ('GME_BATCH_STEP_RESOURCES');
473: END IF;
474:
475: i := p_recipe_rout_resc_tbl.FIRST;

Line 1106: UPDATE gme_resource_txns

1102: WHERE batchstep_activity_id = l_batchstep_activity_id;
1103:
1104: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
1105: FOR l_rec IN cur_get_resources (l_batchstep_activity_id) LOOP
1106: UPDATE gme_resource_txns
1107: SET resource_usage =
1108: ROUND ( l_rec.plan_rsrc_usage
1109: / l_rec.plan_rsrc_count
1110: ,32)

Line 1191: UPDATE gme_resource_txns

1187: WHERE batchstep_activity_id = l_batchstep_activity_id;
1188:
1189: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
1190: FOR l_rec IN cur_get_resources (l_batchstep_activity_id) LOOP
1191: UPDATE gme_resource_txns
1192: SET resource_usage =
1193: ROUND ( l_rec.plan_rsrc_usage
1194: / l_rec.plan_rsrc_count
1195: ,32)

Line 3294: l_gme_resource_txns gme_resource_txns%ROWTYPE;

3290: ,p_doc_type IN VARCHAR2
3291: ,p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
3292: ,x_return_status OUT NOCOPY VARCHAR2)
3293: IS
3294: l_gme_resource_txns gme_resource_txns%ROWTYPE;
3295: l_txn_usage NUMBER;
3296: l_usage_time NUMBER;
3297: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3298: l_api_name CONSTANT VARCHAR2 (30) := 'insert_resource_txns';

Line 3332: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;

3328: / p_batch_step_resources_rec.plan_rsrc_count;
3329: END IF;
3330:
3331: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
3332: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;
3333: l_gme_resource_txns.doc_type := p_doc_type;
3334: l_gme_resource_txns.organization_id :=
3335: p_gme_batch_header_rec.organization_id;
3336: l_gme_resource_txns.line_type := 0;

Line 3333: l_gme_resource_txns.doc_type := p_doc_type;

3329: END IF;
3330:
3331: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
3332: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;
3333: l_gme_resource_txns.doc_type := p_doc_type;
3334: l_gme_resource_txns.organization_id :=
3335: p_gme_batch_header_rec.organization_id;
3336: l_gme_resource_txns.line_type := 0;
3337: l_gme_resource_txns.line_id :=

Line 3334: l_gme_resource_txns.organization_id :=

3330:
3331: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
3332: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;
3333: l_gme_resource_txns.doc_type := p_doc_type;
3334: l_gme_resource_txns.organization_id :=
3335: p_gme_batch_header_rec.organization_id;
3336: l_gme_resource_txns.line_type := 0;
3337: l_gme_resource_txns.line_id :=
3338: p_batch_step_resources_rec.batchstep_resource_id;

Line 3336: l_gme_resource_txns.line_type := 0;

3332: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;
3333: l_gme_resource_txns.doc_type := p_doc_type;
3334: l_gme_resource_txns.organization_id :=
3335: p_gme_batch_header_rec.organization_id;
3336: l_gme_resource_txns.line_type := 0;
3337: l_gme_resource_txns.line_id :=
3338: p_batch_step_resources_rec.batchstep_resource_id;
3339: l_gme_resource_txns.resources :=
3340: p_batch_step_resources_rec.resources;

Line 3337: l_gme_resource_txns.line_id :=

3333: l_gme_resource_txns.doc_type := p_doc_type;
3334: l_gme_resource_txns.organization_id :=
3335: p_gme_batch_header_rec.organization_id;
3336: l_gme_resource_txns.line_type := 0;
3337: l_gme_resource_txns.line_id :=
3338: p_batch_step_resources_rec.batchstep_resource_id;
3339: l_gme_resource_txns.resources :=
3340: p_batch_step_resources_rec.resources;
3341: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);

Line 3339: l_gme_resource_txns.resources :=

3335: p_gme_batch_header_rec.organization_id;
3336: l_gme_resource_txns.line_type := 0;
3337: l_gme_resource_txns.line_id :=
3338: p_batch_step_resources_rec.batchstep_resource_id;
3339: l_gme_resource_txns.resources :=
3340: p_batch_step_resources_rec.resources;
3341: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);
3342: l_gme_resource_txns.trans_qty_um :=
3343: p_batch_step_resources_rec.usage_um;

Line 3341: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);

3337: l_gme_resource_txns.line_id :=
3338: p_batch_step_resources_rec.batchstep_resource_id;
3339: l_gme_resource_txns.resources :=
3340: p_batch_step_resources_rec.resources;
3341: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);
3342: l_gme_resource_txns.trans_qty_um :=
3343: p_batch_step_resources_rec.usage_um;
3344: l_gme_resource_txns.trans_date :=
3345: p_batch_step_resources_rec.plan_start_date;

Line 3342: l_gme_resource_txns.trans_qty_um :=

3338: p_batch_step_resources_rec.batchstep_resource_id;
3339: l_gme_resource_txns.resources :=
3340: p_batch_step_resources_rec.resources;
3341: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);
3342: l_gme_resource_txns.trans_qty_um :=
3343: p_batch_step_resources_rec.usage_um;
3344: l_gme_resource_txns.trans_date :=
3345: p_batch_step_resources_rec.plan_start_date;
3346: l_gme_resource_txns.completed_ind := 0;

Line 3344: l_gme_resource_txns.trans_date :=

3340: p_batch_step_resources_rec.resources;
3341: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);
3342: l_gme_resource_txns.trans_qty_um :=
3343: p_batch_step_resources_rec.usage_um;
3344: l_gme_resource_txns.trans_date :=
3345: p_batch_step_resources_rec.plan_start_date;
3346: l_gme_resource_txns.completed_ind := 0;
3347: l_gme_resource_txns.posted_ind := 0;
3348: l_gme_resource_txns.overrided_protected_ind := 'N';

Line 3346: l_gme_resource_txns.completed_ind := 0;

3342: l_gme_resource_txns.trans_qty_um :=
3343: p_batch_step_resources_rec.usage_um;
3344: l_gme_resource_txns.trans_date :=
3345: p_batch_step_resources_rec.plan_start_date;
3346: l_gme_resource_txns.completed_ind := 0;
3347: l_gme_resource_txns.posted_ind := 0;
3348: l_gme_resource_txns.overrided_protected_ind := 'N';
3349: l_gme_resource_txns.start_date :=
3350: p_batch_step_resources_rec.plan_start_date;

Line 3347: l_gme_resource_txns.posted_ind := 0;

3343: p_batch_step_resources_rec.usage_um;
3344: l_gme_resource_txns.trans_date :=
3345: p_batch_step_resources_rec.plan_start_date;
3346: l_gme_resource_txns.completed_ind := 0;
3347: l_gme_resource_txns.posted_ind := 0;
3348: l_gme_resource_txns.overrided_protected_ind := 'N';
3349: l_gme_resource_txns.start_date :=
3350: p_batch_step_resources_rec.plan_start_date;
3351: l_gme_resource_txns.end_date :=

Line 3348: l_gme_resource_txns.overrided_protected_ind := 'N';

3344: l_gme_resource_txns.trans_date :=
3345: p_batch_step_resources_rec.plan_start_date;
3346: l_gme_resource_txns.completed_ind := 0;
3347: l_gme_resource_txns.posted_ind := 0;
3348: l_gme_resource_txns.overrided_protected_ind := 'N';
3349: l_gme_resource_txns.start_date :=
3350: p_batch_step_resources_rec.plan_start_date;
3351: l_gme_resource_txns.end_date :=
3352: p_batch_step_resources_rec.plan_cmplt_date;

Line 3349: l_gme_resource_txns.start_date :=

3345: p_batch_step_resources_rec.plan_start_date;
3346: l_gme_resource_txns.completed_ind := 0;
3347: l_gme_resource_txns.posted_ind := 0;
3348: l_gme_resource_txns.overrided_protected_ind := 'N';
3349: l_gme_resource_txns.start_date :=
3350: p_batch_step_resources_rec.plan_start_date;
3351: l_gme_resource_txns.end_date :=
3352: p_batch_step_resources_rec.plan_cmplt_date;
3353: l_gme_resource_txns.delete_mark := 0;

Line 3351: l_gme_resource_txns.end_date :=

3347: l_gme_resource_txns.posted_ind := 0;
3348: l_gme_resource_txns.overrided_protected_ind := 'N';
3349: l_gme_resource_txns.start_date :=
3350: p_batch_step_resources_rec.plan_start_date;
3351: l_gme_resource_txns.end_date :=
3352: p_batch_step_resources_rec.plan_cmplt_date;
3353: l_gme_resource_txns.delete_mark := 0;
3354:
3355: FOR i IN 1 .. p_batch_step_resources_rec.plan_rsrc_count LOOP

Line 3353: l_gme_resource_txns.delete_mark := 0;

3349: l_gme_resource_txns.start_date :=
3350: p_batch_step_resources_rec.plan_start_date;
3351: l_gme_resource_txns.end_date :=
3352: p_batch_step_resources_rec.plan_cmplt_date;
3353: l_gme_resource_txns.delete_mark := 0;
3354:
3355: FOR i IN 1 .. p_batch_step_resources_rec.plan_rsrc_count LOOP
3356: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3357: gme_debug.put_line ( g_pkg_name

Line 3364: || TO_CHAR (l_gme_resource_txns.end_date

3360: || ' '
3361: || 'resource transaction # '
3362: || i
3363: || ' end date '
3364: || TO_CHAR (l_gme_resource_txns.end_date
3365: ,'DD-MON-YYYY HH24:MI:SS') );
3366: END IF;
3367:
3368: /* once api is known will add this GMF_PeriodClose_PUB.Verify_PeriodClose

Line 3374: l_gme_resource_txns.trans_date := l_tran_rec_out.trans_date;

3370: x_tran_rec => l_tran_rec_out) THEN
3371: RAISE FND_API.g_exc_error;
3372: END IF;
3373:
3374: l_gme_resource_txns.trans_date := l_tran_rec_out.trans_date;
3375: */
3376:
3377: --FPBug#4395561 Start
3378: /*call create flex procedure to insert the default values of the GME_RSRC_TXN_FLEX

Line 3382: l_gme_resource_txns,

3378: /*call create flex procedure to insert the default values of the GME_RSRC_TXN_FLEX
3379: DFF's segments if they are enabled */
3380: l_return_status:=NULL;
3381: gme_validate_flex_fld_pvt.create_flex_resource_txns (
3382: l_gme_resource_txns,
3383: l_gme_resource_txns,
3384: l_return_status);
3385: IF l_return_status <> FND_API.g_ret_sts_success THEN
3386: RAISE create_flex_failure;

Line 3383: l_gme_resource_txns,

3379: DFF's segments if they are enabled */
3380: l_return_status:=NULL;
3381: gme_validate_flex_fld_pvt.create_flex_resource_txns (
3382: l_gme_resource_txns,
3383: l_gme_resource_txns,
3384: l_return_status);
3385: IF l_return_status <> FND_API.g_ret_sts_success THEN
3386: RAISE create_flex_failure;
3387: END IF;

Line 3390: IF (gme_resource_txns_dbl.insert_row

3386: RAISE create_flex_failure;
3387: END IF;
3388: --FPBug#4395561 End
3389:
3390: IF (gme_resource_txns_dbl.insert_row
3391: (p_resource_txns => l_gme_resource_txns
3392: ,x_resource_txns => l_gme_resource_txns) ) THEN
3393: NULL;
3394: ELSE

Line 3391: (p_resource_txns => l_gme_resource_txns

3387: END IF;
3388: --FPBug#4395561 End
3389:
3390: IF (gme_resource_txns_dbl.insert_row
3391: (p_resource_txns => l_gme_resource_txns
3392: ,x_resource_txns => l_gme_resource_txns) ) THEN
3393: NULL;
3394: ELSE
3395: RAISE error_insert_res_txns;

Line 3392: ,x_resource_txns => l_gme_resource_txns) ) THEN

3388: --FPBug#4395561 End
3389:
3390: IF (gme_resource_txns_dbl.insert_row
3391: (p_resource_txns => l_gme_resource_txns
3392: ,x_resource_txns => l_gme_resource_txns) ) THEN
3393: NULL;
3394: ELSE
3395: RAISE error_insert_res_txns;
3396: END IF;