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.GMD_SPEC_VRS_GRP dependencies on GMD_SAMPLING_PLANS

Line 162: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;

158: l_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE;
159: l_mon_vr_tmp GMD_MONITORING_SPEC_VRS%ROWTYPE;
160: l_item_mst IC_ITEM_MST%ROWTYPE;
161: l_item_mst_out IC_ITEM_MST%ROWTYPE;
162: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
163: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
164:
165: -- Exceptions
166: e_spec_fetch_error EXCEPTION;

Line 163: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

159: l_mon_vr_tmp GMD_MONITORING_SPEC_VRS%ROWTYPE;
160: l_item_mst IC_ITEM_MST%ROWTYPE;
161: l_item_mst_out IC_ITEM_MST%ROWTYPE;
162: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
163: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
164:
165: -- Exceptions
166: e_spec_fetch_error EXCEPTION;
167: e_smpl_plan_fetch_error EXCEPTION;

Line 198: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(

194: --odab added this test.
195: IF (p_mon_vr.sampling_plan_id IS NOT NULL)
196: THEN
197: l_sampling_plan.sampling_plan_id := p_mon_vr.sampling_plan_id;
198: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(
199: p_sampling_plan => l_sampling_plan,
200: x_sampling_plan => l_sampling_plan_out)
201: ) THEN
202: -- Fetch Error

Line 698: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;

694: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
695: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
696: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
697: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
698: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
699: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
700: l_inventory_item_id NUMBER;
701: l_organization_id NUMBER;
702: l_uom_rate NUMBER;

Line 699: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

695: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
696: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
697: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
698: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
699: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
700: l_inventory_item_id NUMBER;
701: l_organization_id NUMBER;
702: l_uom_rate NUMBER;
703:

Line 737: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(

733: --odab added this test.
734: IF (p_inv_vr.sampling_plan_id IS NOT NULL)
735: THEN
736: l_sampling_plan.sampling_plan_id := p_inv_vr.sampling_plan_id;
737: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(
738: p_sampling_plan => l_sampling_plan,
739: x_sampling_plan => l_sampling_plan_out)
740: ) THEN
741: -- Fetch Error

Line 1341: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;

1337: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1338: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1339: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;
1340: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
1341: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1342: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
1343: l_inventory_item_id NUMBER;
1344: l_organization_id NUMBER;
1345: l_uom_rate NUMBER;

Line 1342: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

1338: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1339: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;
1340: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
1341: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1342: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
1343: l_inventory_item_id NUMBER;
1344: l_organization_id NUMBER;
1345: l_uom_rate NUMBER;
1346:

Line 1380: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(

1376: --odab added this test.
1377: IF (p_wip_vr.sampling_plan_id IS NOT NULL)
1378: THEN
1379: l_sampling_plan.sampling_plan_id := p_wip_vr.sampling_plan_id;
1380: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(
1381: p_sampling_plan => l_sampling_plan,
1382: x_sampling_plan => l_sampling_plan_out)
1383: ) THEN
1384: -- Fetch Error

Line 2684: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;

2680:
2681: l_spec GMD_SPECIFICATIONS%ROWTYPE;
2682: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
2683: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
2684: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
2685: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
2686: l_inventory_item_id NUMBER;
2687: l_organization_id NUMBER;
2688: l_uom_rate NUMBER;

Line 2685: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

2681: l_spec GMD_SPECIFICATIONS%ROWTYPE;
2682: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
2683: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
2684: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
2685: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
2686: l_inventory_item_id NUMBER;
2687: l_organization_id NUMBER;
2688: l_uom_rate NUMBER;
2689:

Line 2723: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(

2719: --odab added this test.
2720: IF (p_cust_vr.sampling_plan_id IS NOT NULL)
2721: THEN
2722: l_sampling_plan.sampling_plan_id := p_cust_vr.sampling_plan_id;
2723: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(
2724: p_sampling_plan => l_sampling_plan,
2725: x_sampling_plan => l_sampling_plan_out)
2726: ) THEN
2727: -- Fetch Error

Line 3335: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;

3331:
3332: l_spec GMD_SPECIFICATIONS%ROWTYPE;
3333: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
3334: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
3335: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
3336: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
3337: l_inventory_item_id NUMBER;
3338: l_organization_id NUMBER;
3339: l_uom_rate NUMBER;

Line 3336: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;

3332: l_spec GMD_SPECIFICATIONS%ROWTYPE;
3333: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
3334: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
3335: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
3336: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
3337: l_inventory_item_id NUMBER;
3338: l_organization_id NUMBER;
3339: l_uom_rate NUMBER;
3340:

Line 3374: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(

3370: --odab added this test.
3371: IF (p_supp_vr.sampling_plan_id IS NOT NULL)
3372: THEN
3373: l_sampling_plan.sampling_plan_id := p_supp_vr.sampling_plan_id;
3374: IF NOT (GMD_Sampling_Plans_PVT.Fetch_Row(
3375: p_sampling_plan => l_sampling_plan,
3376: x_sampling_plan => l_sampling_plan_out)
3377: ) THEN
3378: -- Fetch Error