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 483: -- Create data for GME_BATCH_STEP_RESOURCES and GME_RESOURCE_TXNS...

479: END LOOP; /* WHILE i IS NOT NULL; STEP ACTIVITIES */
480:
481: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
482: gme_debug.put_line ('Completed GME_BATCH_STEP_ACTIVITIES');
483: -- Create data for GME_BATCH_STEP_RESOURCES and GME_RESOURCE_TXNS...
484: gme_debug.put_line ('GME_BATCH_STEP_RESOURCES');
485: END IF;
486:
487: i := p_recipe_rout_resc_tbl.FIRST;

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 1276: UPDATE gme_resource_txns

1272: WHERE batchstep_activity_id = l_batchstep_activity_id;
1273:
1274: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
1275: FOR l_rec IN cur_get_resources (l_batchstep_activity_id) LOOP
1276: UPDATE gme_resource_txns
1277: SET resource_usage =
1278: ROUND ( l_rec.plan_rsrc_usage
1279: / l_rec.plan_rsrc_count
1280: ,32)

Line 3802: l_gme_resource_txns gme_resource_txns%ROWTYPE;

3798: ,p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
3799: ,p_trans_count IN NUMBER
3800: ,x_return_status OUT NOCOPY VARCHAR2)
3801: IS
3802: l_gme_resource_txns gme_resource_txns%ROWTYPE;
3803: l_txn_usage NUMBER;
3804: l_usage_time NUMBER;
3805: l_hour_um mtl_units_of_measure.uom_code%TYPE;
3806: l_api_name CONSTANT VARCHAR2 (30) := 'insert_resource_txns';

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

3837: / p_batch_step_resources_rec.plan_rsrc_count;
3838: END IF;
3839:
3840: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
3841: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;
3842: l_gme_resource_txns.doc_type := p_doc_type;
3843: l_gme_resource_txns.organization_id :=
3844: p_gme_batch_header_rec.organization_id;
3845: l_gme_resource_txns.line_type := 0;

Line 3842: l_gme_resource_txns.doc_type := p_doc_type;

3838: END IF;
3839:
3840: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
3841: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;
3842: l_gme_resource_txns.doc_type := p_doc_type;
3843: l_gme_resource_txns.organization_id :=
3844: p_gme_batch_header_rec.organization_id;
3845: l_gme_resource_txns.line_type := 0;
3846: l_gme_resource_txns.line_id :=

Line 3843: l_gme_resource_txns.organization_id :=

3839:
3840: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
3841: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;
3842: l_gme_resource_txns.doc_type := p_doc_type;
3843: l_gme_resource_txns.organization_id :=
3844: p_gme_batch_header_rec.organization_id;
3845: l_gme_resource_txns.line_type := 0;
3846: l_gme_resource_txns.line_id :=
3847: p_batch_step_resources_rec.batchstep_resource_id;

Line 3845: l_gme_resource_txns.line_type := 0;

3841: l_gme_resource_txns.doc_id := p_batch_step_resources_rec.batch_id;
3842: l_gme_resource_txns.doc_type := p_doc_type;
3843: l_gme_resource_txns.organization_id :=
3844: p_gme_batch_header_rec.organization_id;
3845: l_gme_resource_txns.line_type := 0;
3846: l_gme_resource_txns.line_id :=
3847: p_batch_step_resources_rec.batchstep_resource_id;
3848: l_gme_resource_txns.resources :=
3849: p_batch_step_resources_rec.resources;

Line 3846: l_gme_resource_txns.line_id :=

3842: l_gme_resource_txns.doc_type := p_doc_type;
3843: l_gme_resource_txns.organization_id :=
3844: p_gme_batch_header_rec.organization_id;
3845: l_gme_resource_txns.line_type := 0;
3846: l_gme_resource_txns.line_id :=
3847: p_batch_step_resources_rec.batchstep_resource_id;
3848: l_gme_resource_txns.resources :=
3849: p_batch_step_resources_rec.resources;
3850: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);

Line 3848: l_gme_resource_txns.resources :=

3844: p_gme_batch_header_rec.organization_id;
3845: l_gme_resource_txns.line_type := 0;
3846: l_gme_resource_txns.line_id :=
3847: p_batch_step_resources_rec.batchstep_resource_id;
3848: l_gme_resource_txns.resources :=
3849: p_batch_step_resources_rec.resources;
3850: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);
3851: l_gme_resource_txns.trans_qty_um :=
3852: p_batch_step_resources_rec.usage_um;

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

3846: l_gme_resource_txns.line_id :=
3847: p_batch_step_resources_rec.batchstep_resource_id;
3848: l_gme_resource_txns.resources :=
3849: p_batch_step_resources_rec.resources;
3850: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);
3851: l_gme_resource_txns.trans_qty_um :=
3852: p_batch_step_resources_rec.usage_um;
3853: l_gme_resource_txns.trans_date :=
3854: p_batch_step_resources_rec.plan_start_date;

Line 3851: l_gme_resource_txns.trans_qty_um :=

3847: p_batch_step_resources_rec.batchstep_resource_id;
3848: l_gme_resource_txns.resources :=
3849: p_batch_step_resources_rec.resources;
3850: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);
3851: l_gme_resource_txns.trans_qty_um :=
3852: p_batch_step_resources_rec.usage_um;
3853: l_gme_resource_txns.trans_date :=
3854: p_batch_step_resources_rec.plan_start_date;
3855: l_gme_resource_txns.completed_ind := 0;

Line 3853: l_gme_resource_txns.trans_date :=

3849: p_batch_step_resources_rec.resources;
3850: l_gme_resource_txns.resource_usage := ROUND (l_txn_usage, 32);
3851: l_gme_resource_txns.trans_qty_um :=
3852: p_batch_step_resources_rec.usage_um;
3853: l_gme_resource_txns.trans_date :=
3854: p_batch_step_resources_rec.plan_start_date;
3855: l_gme_resource_txns.completed_ind := 0;
3856: l_gme_resource_txns.posted_ind := 0;
3857: l_gme_resource_txns.overrided_protected_ind := 'N';

Line 3855: l_gme_resource_txns.completed_ind := 0;

3851: l_gme_resource_txns.trans_qty_um :=
3852: p_batch_step_resources_rec.usage_um;
3853: l_gme_resource_txns.trans_date :=
3854: p_batch_step_resources_rec.plan_start_date;
3855: l_gme_resource_txns.completed_ind := 0;
3856: l_gme_resource_txns.posted_ind := 0;
3857: l_gme_resource_txns.overrided_protected_ind := 'N';
3858: l_gme_resource_txns.start_date :=
3859: p_batch_step_resources_rec.plan_start_date;

Line 3856: l_gme_resource_txns.posted_ind := 0;

3852: p_batch_step_resources_rec.usage_um;
3853: l_gme_resource_txns.trans_date :=
3854: p_batch_step_resources_rec.plan_start_date;
3855: l_gme_resource_txns.completed_ind := 0;
3856: l_gme_resource_txns.posted_ind := 0;
3857: l_gme_resource_txns.overrided_protected_ind := 'N';
3858: l_gme_resource_txns.start_date :=
3859: p_batch_step_resources_rec.plan_start_date;
3860: l_gme_resource_txns.end_date :=

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

3853: l_gme_resource_txns.trans_date :=
3854: p_batch_step_resources_rec.plan_start_date;
3855: l_gme_resource_txns.completed_ind := 0;
3856: l_gme_resource_txns.posted_ind := 0;
3857: l_gme_resource_txns.overrided_protected_ind := 'N';
3858: l_gme_resource_txns.start_date :=
3859: p_batch_step_resources_rec.plan_start_date;
3860: l_gme_resource_txns.end_date :=
3861: p_batch_step_resources_rec.plan_cmplt_date;

Line 3858: l_gme_resource_txns.start_date :=

3854: p_batch_step_resources_rec.plan_start_date;
3855: l_gme_resource_txns.completed_ind := 0;
3856: l_gme_resource_txns.posted_ind := 0;
3857: l_gme_resource_txns.overrided_protected_ind := 'N';
3858: l_gme_resource_txns.start_date :=
3859: p_batch_step_resources_rec.plan_start_date;
3860: l_gme_resource_txns.end_date :=
3861: p_batch_step_resources_rec.plan_cmplt_date;
3862: l_gme_resource_txns.delete_mark := 0;

Line 3860: l_gme_resource_txns.end_date :=

3856: l_gme_resource_txns.posted_ind := 0;
3857: l_gme_resource_txns.overrided_protected_ind := 'N';
3858: l_gme_resource_txns.start_date :=
3859: p_batch_step_resources_rec.plan_start_date;
3860: l_gme_resource_txns.end_date :=
3861: p_batch_step_resources_rec.plan_cmplt_date;
3862: l_gme_resource_txns.delete_mark := 0;
3863:
3864: FOR i IN 1 .. p_batch_step_resources_rec.plan_rsrc_count LOOP

Line 3862: l_gme_resource_txns.delete_mark := 0;

3858: l_gme_resource_txns.start_date :=
3859: p_batch_step_resources_rec.plan_start_date;
3860: l_gme_resource_txns.end_date :=
3861: p_batch_step_resources_rec.plan_cmplt_date;
3862: l_gme_resource_txns.delete_mark := 0;
3863:
3864: FOR i IN 1 .. p_batch_step_resources_rec.plan_rsrc_count LOOP
3865: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3866: gme_debug.put_line ( g_pkg_name

Line 3873: || TO_CHAR (l_gme_resource_txns.end_date

3869: || ' '
3870: || 'resource transaction # '
3871: || i
3872: || ' end date '
3873: || TO_CHAR (l_gme_resource_txns.end_date
3874: ,'DD-MON-YYYY HH24:MI:SS') );
3875: END IF;
3876:
3877: /* once api is known will add this GMF_PeriodClose_PUB.Verify_PeriodClose

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

3879: x_tran_rec => l_tran_rec_out) THEN
3880: RAISE FND_API.g_exc_error;
3881: END IF;
3882:
3883: l_gme_resource_txns.trans_date := l_tran_rec_out.trans_date;
3884: */
3885:
3886: --FPBug#4395561 Start
3887: /*call create flex procedure to insert the default values of the GME_RSRC_TXN_FLEX

Line 3891: l_gme_resource_txns,

3887: /*call create flex procedure to insert the default values of the GME_RSRC_TXN_FLEX
3888: DFF's segments if they are enabled */
3889: l_return_status:=NULL;
3890: gme_validate_flex_fld_pvt.create_flex_resource_txns (
3891: l_gme_resource_txns,
3892: l_gme_resource_txns,
3893: l_return_status);
3894: IF l_return_status <> FND_API.g_ret_sts_success THEN
3895: RAISE create_flex_failure;

Line 3892: l_gme_resource_txns,

3888: DFF's segments if they are enabled */
3889: l_return_status:=NULL;
3890: gme_validate_flex_fld_pvt.create_flex_resource_txns (
3891: l_gme_resource_txns,
3892: l_gme_resource_txns,
3893: l_return_status);
3894: IF l_return_status <> FND_API.g_ret_sts_success THEN
3895: RAISE create_flex_failure;
3896: END IF;

Line 3899: IF (gme_resource_txns_dbl.insert_row

3895: RAISE create_flex_failure;
3896: END IF;
3897: --FPBug#4395561 End
3898:
3899: IF (gme_resource_txns_dbl.insert_row
3900: (p_resource_txns => l_gme_resource_txns
3901: ,x_resource_txns => l_gme_resource_txns) ) THEN
3902: NULL;
3903: ELSE

Line 3900: (p_resource_txns => l_gme_resource_txns

3896: END IF;
3897: --FPBug#4395561 End
3898:
3899: IF (gme_resource_txns_dbl.insert_row
3900: (p_resource_txns => l_gme_resource_txns
3901: ,x_resource_txns => l_gme_resource_txns) ) THEN
3902: NULL;
3903: ELSE
3904: RAISE error_insert_res_txns;

Line 3901: ,x_resource_txns => l_gme_resource_txns) ) THEN

3897: --FPBug#4395561 End
3898:
3899: IF (gme_resource_txns_dbl.insert_row
3900: (p_resource_txns => l_gme_resource_txns
3901: ,x_resource_txns => l_gme_resource_txns) ) THEN
3902: NULL;
3903: ELSE
3904: RAISE error_insert_res_txns;
3905: END IF;