APPS.GMD_API_GRP dependencies on GMD_PARAMETERS_DTL

Line 1226: cp_parameter_name gmd_parameters_dtl.parameter_name%TYPE)IS

1222: V_orgn_id IN NUMBER,
1223: X_entity_status OUT NOCOPY GMD_API_GRP.status_rec_type) IS
1224:
1225: CURSOR cur_def_status(cp_orgn_id NUMBER,
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

Line 1231: ,gmd_parameters_dtl d

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

Line 2250: X_out_rec OUT NOCOPY GMD_PARAMETERS_DTL_PKG.parameter_rec_type,

2246: -- Sriram.S 05-NOV-2004 Created
2247: --===================================================================== */
2248:
2249: PROCEDURE FETCH_PARM_VALUES (P_orgn_id IN NUMBER,
2250: X_out_rec OUT NOCOPY GMD_PARAMETERS_DTL_PKG.parameter_rec_type,
2251: X_return_status OUT NOCOPY VARCHAR2) IS
2252:
2253: CURSOR Cur_get_parameters IS
2254: SELECT parameter_name, parameter_value, parameter_type

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