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_API_GRP dependencies on GMD_PARAMETERS_HDR

Line 1230: FROM gmd_parameters_hdr h

1226: cp_parameter_name gmd_parameters_dtl.parameter_name%TYPE)IS
1227: SELECT st.status_code
1228: ,st.description
1229: ,st.status_type
1230: FROM gmd_parameters_hdr h
1231: ,gmd_parameters_dtl d
1232: ,gmd_status st
1233: WHERE (h.organization_id = cp_orgn_id OR h.organization_id IS NULL)
1234: AND h.parameter_id = d.parameter_id

Line 2255: FROM gmd_parameters_hdr h, gmd_parameters_dtl d

2251: X_return_status OUT NOCOPY VARCHAR2) IS
2252:
2253: CURSOR Cur_get_parameters IS
2254: SELECT parameter_name, parameter_value, parameter_type
2255: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2256: WHERE h.parameter_id = d.parameter_id
2257: AND h.organization_id = P_orgn_id
2258: UNION
2259: SELECT parameter_name, parameter_value, parameter_type

Line 2260: FROM gmd_parameters_hdr h, gmd_parameters_dtl d

2256: WHERE h.parameter_id = d.parameter_id
2257: AND h.organization_id = P_orgn_id
2258: UNION
2259: SELECT parameter_name, parameter_value, parameter_type
2260: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2261: WHERE h.parameter_id = d.parameter_id
2262: AND h.organization_id IS NULL
2263: AND NOT EXISTS (SELECT 1
2264: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1

Line 2264: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1

2260: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2261: WHERE h.parameter_id = d.parameter_id
2262: AND h.organization_id IS NULL
2263: AND NOT EXISTS (SELECT 1
2264: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1
2265: WHERE h1.parameter_id = d1.parameter_id
2266: AND h1.organization_id = P_orgn_id
2267: AND d1.parameter_name = d.parameter_name);
2268:

Line 2272: FROM gmd_parameters_hdr

2268:
2269:
2270: CURSOR Cur_get_lab_plant_ind IS
2271: SELECT plant_ind, lab_ind
2272: FROM gmd_parameters_hdr
2273: WHERE organization_id = P_orgn_id;
2274:
2275: l_Cur_get_parameters_fetch BOOLEAN := FALSE;
2276:

Line 2389: FROM gmd_parameters_hdr h, gmd_parameters_dtl d

2385: X_return_status OUT NOCOPY VARCHAR2) IS
2386:
2387: CURSOR Cur_get_parameter IS
2388: SELECT parameter_value
2389: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2390: WHERE h.parameter_id = d.parameter_id
2391: AND h.organization_id = P_orgn_id
2392: AND d.parameter_name = P_parm_name
2393: UNION

Line 2395: FROM gmd_parameters_hdr h, gmd_parameters_dtl d

2391: AND h.organization_id = P_orgn_id
2392: AND d.parameter_name = P_parm_name
2393: UNION
2394: SELECT parameter_value
2395: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2396: WHERE h.parameter_id = d.parameter_id
2397: AND h.organization_id IS NULL
2398: AND d.parameter_name = P_parm_name
2399: AND NOT EXISTS (SELECT 1

Line 2400: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1

2396: WHERE h.parameter_id = d.parameter_id
2397: AND h.organization_id IS NULL
2398: AND d.parameter_name = P_parm_name
2399: AND NOT EXISTS (SELECT 1
2400: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1
2401: WHERE h1.parameter_id = d1.parameter_id
2402: AND h1.organization_id = P_orgn_id
2403: AND d1.parameter_name = d.parameter_name);
2404: