APPS.AD_UPDATE_WORK_PARAMS_PKG dependencies on AD_UPDATE_WORK_PARAMS

Line 1: PACKAGE BODY AD_UPDATE_WORK_PARAMS_PKG AS

1: PACKAGE BODY AD_UPDATE_WORK_PARAMS_PKG AS
2: -- $Header: adupwrkb.pls 115.3 2004/09/17 07:37:07 msailoz ship $
3:
4: PROCEDURE SET_PARAMETER(
5: p_owner IN VARCHAR2,

Line 9: l_owner AD_UPDATE_WORK_PARAMS.owner%TYPE ;

5: p_owner IN VARCHAR2,
6: p_name IN VARCHAR2,
7: p_value IN VARCHAR2)
8: IS
9: l_owner AD_UPDATE_WORK_PARAMS.owner%TYPE ;
10: l_name AD_UPDATE_WORK_PARAMS.name%TYPE ;
11: BEGIN
12: l_owner := upper(p_owner);
13: l_name := upper(p_name);

Line 10: l_name AD_UPDATE_WORK_PARAMS.name%TYPE ;

6: p_name IN VARCHAR2,
7: p_value IN VARCHAR2)
8: IS
9: l_owner AD_UPDATE_WORK_PARAMS.owner%TYPE ;
10: l_name AD_UPDATE_WORK_PARAMS.name%TYPE ;
11: BEGIN
12: l_owner := upper(p_owner);
13: l_name := upper(p_name);
14: --Update the value if the parameter already exists

Line 15: UPDATE AD_UPDATE_WORK_PARAMS

11: BEGIN
12: l_owner := upper(p_owner);
13: l_name := upper(p_name);
14: --Update the value if the parameter already exists
15: UPDATE AD_UPDATE_WORK_PARAMS
16: SET value = p_value,
17: last_update_date = SYSDATE,
18: last_updated_by = SYSADMIN_VALUE
19: WHERE owner = l_owner

Line 25: INSERT INTO AD_UPDATE_WORK_PARAMS(

21: AND session_id = GLOBAL_SESSION_VALUE;
22:
23: IF SQL%ROWCOUNT = 0 THEN
24: --Create a new parameter if the parameter has not been updated
25: INSERT INTO AD_UPDATE_WORK_PARAMS(
26: session_id,
27: owner,
28: name,
29: value,

Line 55: l_value AD_UPDATE_WORK_PARAMS.value%TYPE ;

51: p_owner IN VARCHAR2,
52: p_name IN VARCHAR2)
53: RETURN VARCHAR2
54: IS
55: l_value AD_UPDATE_WORK_PARAMS.value%TYPE ;
56: BEGIN
57: --Get the value for the parameter which is global
58: SELECT value INTO l_value
59: FROM AD_UPDATE_WORK_PARAMS

Line 59: FROM AD_UPDATE_WORK_PARAMS

55: l_value AD_UPDATE_WORK_PARAMS.value%TYPE ;
56: BEGIN
57: --Get the value for the parameter which is global
58: SELECT value INTO l_value
59: FROM AD_UPDATE_WORK_PARAMS
60: WHERE session_id = GLOBAL_SESSION_VALUE
61: AND owner = upper(p_owner)
62: AND name = upper(p_name);
63:

Line 78: l_owner AD_UPDATE_WORK_PARAMS.owner%TYPE ;

74: p_owner IN VARCHAR2,
75: p_name IN VARCHAR2,
76: p_value IN VARCHAR2)
77: IS
78: l_owner AD_UPDATE_WORK_PARAMS.owner%TYPE ;
79: l_name AD_UPDATE_WORK_PARAMS.name%TYPE ;
80: BEGIN
81:
82: l_owner := upper(p_owner);

Line 79: l_name AD_UPDATE_WORK_PARAMS.name%TYPE ;

75: p_name IN VARCHAR2,
76: p_value IN VARCHAR2)
77: IS
78: l_owner AD_UPDATE_WORK_PARAMS.owner%TYPE ;
79: l_name AD_UPDATE_WORK_PARAMS.name%TYPE ;
80: BEGIN
81:
82: l_owner := upper(p_owner);
83: l_name := upper(p_name);

Line 85: UPDATE AD_UPDATE_WORK_PARAMS

81:
82: l_owner := upper(p_owner);
83: l_name := upper(p_name);
84: --Update the value if the parameter already exists for the session
85: UPDATE AD_UPDATE_WORK_PARAMS
86: SET value = p_value,
87: last_update_date = SYSDATE,
88: last_updated_by = SYSADMIN_VALUE
89: WHERE owner = l_owner

Line 95: INSERT INTO AD_UPDATE_WORK_PARAMS(

91: AND session_id = p_session_id;
92:
93: IF SQL%ROWCOUNT = 0 THEN
94: --Create a new parameter if the parameter has not been updated for the session
95: INSERT INTO AD_UPDATE_WORK_PARAMS(
96: session_id,
97: owner,
98: name,
99: value,

Line 127: l_value AD_UPDATE_WORK_PARAMS.value%TYPE ;

123: p_owner IN VARCHAR2,
124: p_name IN VARCHAR2)
125: RETURN VARCHAR2
126: IS
127: l_value AD_UPDATE_WORK_PARAMS.value%TYPE ;
128: BEGIN
129: --Get the parameter for the name, owner and session
130: SELECT value INTO l_value
131: FROM AD_UPDATE_WORK_PARAMS

Line 131: FROM AD_UPDATE_WORK_PARAMS

127: l_value AD_UPDATE_WORK_PARAMS.value%TYPE ;
128: BEGIN
129: --Get the parameter for the name, owner and session
130: SELECT value INTO l_value
131: FROM AD_UPDATE_WORK_PARAMS
132: WHERE session_id = p_session_id
133: AND owner = upper(p_owner)
134: AND name = upper(p_name);
135:

Line 145: END AD_UPDATE_WORK_PARAMS_PKG;

141: RETURN UNDEF_VALUE;
142:
143: END GET_SESSION_PARAMETER;
144:
145: END AD_UPDATE_WORK_PARAMS_PKG;