APPS.GMD_PARAMETERS_DTL_PKG dependencies on GMD_PARAMETERS_DTL

Line 1: PACKAGE BODY GMD_PARAMETERS_DTL_PKG AS

1: PACKAGE BODY GMD_PARAMETERS_DTL_PKG AS
2: /* $Header: GMDPRMDB.pls 120.6 2006/05/24 12:56:25 rkrishan noship $ */
3:
4:
5: /*======================================================================

Line 31: FROM GMD_PARAMETERS_DTL

27: ) IS
28:
29: CURSOR C IS
30: SELECT ROWID
31: FROM GMD_PARAMETERS_DTL
32: WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID;
33: BEGIN
34:
35: INSERT INTO GMD_PARAMETERS_DTL (

Line 35: INSERT INTO GMD_PARAMETERS_DTL (

31: FROM GMD_PARAMETERS_DTL
32: WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID;
33: BEGIN
34:
35: INSERT INTO GMD_PARAMETERS_DTL (
36: PARAMETER_ID,
37: PARAMETER_LINE_ID,
38: PARAMETER_TYPE,
39: PARAMETER_NAME,

Line 98: FROM GMD_PARAMETERS_DTL

94: PARAMETER_ID,
95: PARAMETER_TYPE,
96: PARAMETER_NAME,
97: PARAMETER_VALUE
98: FROM GMD_PARAMETERS_DTL
99: WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID
100: FOR UPDATE OF PARAMETER_LINE_ID NOWAIT;
101:
102: CURSOR cur_gem_lookups IS

Line 196: UPDATE GMD_PARAMETERS_DTL

192: X_LAST_UPDATE_LOGIN IN NUMBER
193: ) IS
194: BEGIN
195:
196: UPDATE GMD_PARAMETERS_DTL
197: SET
198: PARAMETER_ID = X_PARAMETER_ID,
199: PARAMETER_TYPE = X_PARM_TYPE,
200: PARAMETER_NAME = X_PARAMETER_NAME,

Line 231: DELETE FROM GMD_PARAMETERS_DTL

227: X_PARAMETER_LINE_ID IN NUMBER
228: ) IS
229: BEGIN
230:
231: DELETE FROM GMD_PARAMETERS_DTL
232: WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID;
233:
234: IF (SQL%NOTFOUND) THEN
235: RAISE NO_DATA_FOUND;

Line 263: from gmd_parameters_dtl d, gmd_parameters_hdr h

259: ,d.PARAMETER_VALUE PARAMETER_VALUE,d.creation_date creation_date
260: ,d.last_updated_by last_updated_by,d.last_update_date last_update_date
261: ,d.last_update_login last_update_login
262: ,d.created_by created_by
263: from gmd_parameters_dtl d, gmd_parameters_hdr h
264: where d.parameter_id = h.parameter_id
265: and d.parameter_type = l_type
266: and ((h.organization_id = l_org_id) or ((l_org_id is NULL) and (h.organization_id IS NULL)))
267: UNION

Line 274: from gmd_parameters_dtl d, gmd_parameters_hdr h

270: FROM gem_lookups l
271: WHERE lookup_type = l_gem_type
272: and ENABLED_FLAG = 'Y'
273: AND not exists (select 1
274: from gmd_parameters_dtl d, gmd_parameters_hdr h
275: where d.parameter_id = h.parameter_id
276: and d.parameter_type = l_type
277: and ((h.organization_id = l_org_id) or ((l_org_id is NULL) and (h.organization_id IS NULL)))
278: and d.parameter_name = l.lookup_code)

Line 324: END GMD_PARAMETERS_DTL_PKG;

320: Xparm_table(X_prcs_cnt).created_by:=l_get_prcs.created_by;
321: END LOOP;
322: END GET_PARAMETER_LIST;
323:
324: END GMD_PARAMETERS_DTL_PKG;
325: