DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_QUALITY_CONFIG

Line 1279: quality_config GMD_QUALITY_CONFIG%ROWTYPE;

1275: -- creation is in effect so that the number can be retrieved
1276: -- AFTER the sample has passed validation. Sample numbers were
1277: -- being lost.
1278: --
1279: quality_config GMD_QUALITY_CONFIG%ROWTYPE;
1280: found BOOLEAN;
1281:
1282: -- Exceptions
1283: e_smpl_plan_fetch_error EXCEPTION;

Line 2996: gmd_quality_config g ,

2992: -- Bug 4165704: changed for inventory convergence
2993: CURSOR c_lab_orgn (p_organization_id NUMBER) IS
2994: SELECT 1
2995: FROM mtl_parameters m,
2996: gmd_quality_config g ,
2997: org_access_view v
2998: WHERE g.quality_lab_ind = 'Y'
2999: AND g.organization_id = m.organization_id
3000: AND v.organization_id = m.organization_id

Line 3680: quality_config GMD_QUALITY_CONFIG%ROWTYPE;

3676:
3677: -- 2995114
3678: -- add position variable for debugging.
3679:
3680: quality_config GMD_QUALITY_CONFIG%ROWTYPE;
3681: l_revision VARCHAR2(3);
3682: l_subinventory VARCHAR2(10);
3683: l_locator_id NUMBER;
3684: l_msg_count NUMBER;

Line 3989: FROM gmd_quality_config

3985: -- instead moved it into public layer api
3986:
3987: CURSOR Cur_global_configurator IS
3988: SELECT transaction_reason_id
3989: FROM gmd_quality_config
3990: WHERE organization_id = p_sample.organization_id
3991: order by 1 ;
3992:
3993: --srakrish bug 5394566: Commenting the cursors as these have hardcoded values and material_detail_id is directly passed .