APPS.GMD_API_GRP dependencies on GMD_PARAMETERS_DTL

Line 1220: cp_parameter_name gmd_parameters_dtl.parameter_name%TYPE)IS

1216: V_orgn_id IN NUMBER,
1217: X_entity_status OUT NOCOPY GMD_API_GRP.status_rec_type) IS
1218:
1219: CURSOR cur_def_status(cp_orgn_id NUMBER,
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

Line 1225: ,gmd_parameters_dtl d

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
1229: AND d.parameter_name = cp_parameter_name

Line 2230: X_out_rec OUT NOCOPY GMD_PARAMETERS_DTL_PKG.parameter_rec_type,

2226: -- Sriram.S 05-NOV-2004 Created
2227: --===================================================================== */
2228:
2229: PROCEDURE FETCH_PARM_VALUES (P_orgn_id IN NUMBER,
2230: X_out_rec OUT NOCOPY GMD_PARAMETERS_DTL_PKG.parameter_rec_type,
2231: X_return_status OUT NOCOPY VARCHAR2) IS
2232:
2233: CURSOR Cur_get_parameters IS
2234: SELECT parameter_name, parameter_value, parameter_type

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 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: