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 1224: FROM gmd_parameters_hdr h

1220: cp_parameter_name gmd_parameters_dtl.parameter_name%TYPE)IS
1221: SELECT st.status_code
1222: ,st.description
1223: ,st.status_type
1224: FROM gmd_parameters_hdr h
1225: ,gmd_parameters_dtl d
1226: ,gmd_status st
1227: WHERE (h.organization_id = cp_orgn_id OR h.organization_id IS NULL)
1228: AND h.parameter_id = d.parameter_id

Line 2235: FROM gmd_parameters_hdr h, gmd_parameters_dtl d

2231: X_return_status OUT NOCOPY VARCHAR2) IS
2232:
2233: CURSOR Cur_get_parameters IS
2234: SELECT parameter_name, parameter_value, parameter_type
2235: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2236: WHERE h.parameter_id = d.parameter_id
2237: AND h.organization_id = P_orgn_id
2238: UNION
2239: SELECT parameter_name, parameter_value, parameter_type

Line 2240: FROM gmd_parameters_hdr h, gmd_parameters_dtl d

2236: WHERE h.parameter_id = d.parameter_id
2237: AND h.organization_id = P_orgn_id
2238: UNION
2239: SELECT parameter_name, parameter_value, parameter_type
2240: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2241: WHERE h.parameter_id = d.parameter_id
2242: AND h.organization_id IS NULL
2243: AND NOT EXISTS (SELECT 1
2244: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1

Line 2244: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1

2240: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2241: WHERE h.parameter_id = d.parameter_id
2242: AND h.organization_id IS NULL
2243: AND NOT EXISTS (SELECT 1
2244: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1
2245: WHERE h1.parameter_id = d1.parameter_id
2246: AND h1.organization_id = P_orgn_id
2247: AND d1.parameter_name = d.parameter_name);
2248:

Line 2252: FROM gmd_parameters_hdr

2248:
2249:
2250: CURSOR Cur_get_lab_plant_ind IS
2251: SELECT plant_ind, lab_ind
2252: FROM gmd_parameters_hdr
2253: WHERE organization_id = P_orgn_id;
2254:
2255: l_Cur_get_parameters_fetch BOOLEAN := FALSE;
2256:

Line 2369: FROM gmd_parameters_hdr h, gmd_parameters_dtl d

2365: X_return_status OUT NOCOPY VARCHAR2) IS
2366:
2367: CURSOR Cur_get_parameter IS
2368: SELECT parameter_value
2369: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2370: WHERE h.parameter_id = d.parameter_id
2371: AND h.organization_id = P_orgn_id
2372: AND d.parameter_name = P_parm_name
2373: UNION

Line 2375: FROM gmd_parameters_hdr h, gmd_parameters_dtl d

2371: AND h.organization_id = P_orgn_id
2372: AND d.parameter_name = P_parm_name
2373: UNION
2374: SELECT parameter_value
2375: FROM gmd_parameters_hdr h, gmd_parameters_dtl d
2376: WHERE h.parameter_id = d.parameter_id
2377: AND h.organization_id IS NULL
2378: AND d.parameter_name = P_parm_name
2379: AND NOT EXISTS (SELECT 1

Line 2380: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1

2376: WHERE h.parameter_id = d.parameter_id
2377: AND h.organization_id IS NULL
2378: AND d.parameter_name = P_parm_name
2379: AND NOT EXISTS (SELECT 1
2380: FROM gmd_parameters_hdr h1, gmd_parameters_dtl d1
2381: WHERE h1.parameter_id = d1.parameter_id
2382: AND h1.organization_id = P_orgn_id
2383: AND d1.parameter_name = d.parameter_name);
2384: