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_FOR_SEC1 dependencies on GMD_FORMULA_SECURITY

Line 21: to GMD_FORMULA_SECURITY table if the assignment type is 'AUTOMATIC'.

17: Change History
18: Who When What
19: nsrivast 16-JAN-2004 Replace the existing code with code to reflect the new behavior w.r.t. bug 3344335.
20: The procedure has been modified so that it no longer inserts records
21: to GMD_FORMULA_SECURITY table if the assignment type is 'AUTOMATIC'.
22:
23: When called from Security Profile form (p_formula_id is NULL)
24: 1) INSERT :- New record is added in GMD_SECURITY_PROFILES
25: 2) DELETE :- Delete records from GMD_SECURITY_PROFILES and Delete corresponding records

Line 26: from GMD_FORMULA_SECURITY if the assignment type is 'MANUAL'

22:
23: When called from Security Profile form (p_formula_id is NULL)
24: 1) INSERT :- New record is added in GMD_SECURITY_PROFILES
25: 2) DELETE :- Delete records from GMD_SECURITY_PROFILES and Delete corresponding records
26: from GMD_FORMULA_SECURITY if the assignment type is 'MANUAL'
27: 3) UPDATE :- Update records in GMD_SECURITY_PROFILES
28: Delete the records from GMD_FORMULA_SECURITY if the previous assignment type was 'MANUAL'
29:
30: When called from the Formula form for a specific formula (p_formula_id is NOT NULL)

Line 28: Delete the records from GMD_FORMULA_SECURITY if the previous assignment type was 'MANUAL'

24: 1) INSERT :- New record is added in GMD_SECURITY_PROFILES
25: 2) DELETE :- Delete records from GMD_SECURITY_PROFILES and Delete corresponding records
26: from GMD_FORMULA_SECURITY if the assignment type is 'MANUAL'
27: 3) UPDATE :- Update records in GMD_SECURITY_PROFILES
28: Delete the records from GMD_FORMULA_SECURITY if the previous assignment type was 'MANUAL'
29:
30: When called from the Formula form for a specific formula (p_formula_id is NOT NULL)
31: 1) INSERT :- Create records in GMD_FORMULA_SECURITY one for each security profile, with
32: 'Manual' assign type, associated with the Organisation with which the formula is associated.

Line 31: 1) INSERT :- Create records in GMD_FORMULA_SECURITY one for each security profile, with

27: 3) UPDATE :- Update records in GMD_SECURITY_PROFILES
28: Delete the records from GMD_FORMULA_SECURITY if the previous assignment type was 'MANUAL'
29:
30: When called from the Formula form for a specific formula (p_formula_id is NOT NULL)
31: 1) INSERT :- Create records in GMD_FORMULA_SECURITY one for each security profile, with
32: 'Manual' assign type, associated with the Organisation with which the formula is associated.
33: 2) DELETE :- Delete the records in GMD_FORMULA_SECURITY associated with that Formula_id
34: 3) UPDATE :- Update the columns in GMD_FORMULA_SECURITY for the formula id.
35: ************************************************************************************************************************************/

Line 33: 2) DELETE :- Delete the records in GMD_FORMULA_SECURITY associated with that Formula_id

29:
30: When called from the Formula form for a specific formula (p_formula_id is NOT NULL)
31: 1) INSERT :- Create records in GMD_FORMULA_SECURITY one for each security profile, with
32: 'Manual' assign type, associated with the Organisation with which the formula is associated.
33: 2) DELETE :- Delete the records in GMD_FORMULA_SECURITY associated with that Formula_id
34: 3) UPDATE :- Update the columns in GMD_FORMULA_SECURITY for the formula id.
35: ************************************************************************************************************************************/
36: IS
37:

Line 34: 3) UPDATE :- Update the columns in GMD_FORMULA_SECURITY for the formula id.

30: When called from the Formula form for a specific formula (p_formula_id is NOT NULL)
31: 1) INSERT :- Create records in GMD_FORMULA_SECURITY one for each security profile, with
32: 'Manual' assign type, associated with the Organisation with which the formula is associated.
33: 2) DELETE :- Delete the records in GMD_FORMULA_SECURITY associated with that Formula_id
34: 3) UPDATE :- Update the columns in GMD_FORMULA_SECURITY for the formula id.
35: ************************************************************************************************************************************/
36: IS
37:
38:

Line 40: -- Cursor cur_form_1 is used when inserting record into GMD_FORMULA_SECURITY wity assigned type Manual for a specific Formula

36: IS
37:
38:
39: --
40: -- Cursor cur_form_1 is used when inserting record into GMD_FORMULA_SECURITY wity assigned type Manual for a specific Formula
41: --
42:
43: CURSOR cur_form_1 IS
44: SELECT formula_id,

Line 106: DELETE FROM GMD_FORMULA_SECURITY

102: ELSE
103: -- Delete the records from fromula security if the old assignment type was 'MANUAL'
104: -- and action is delete/update
105: IF before_sec_prof_rec.assign_method_ind='M' THEN
106: DELETE FROM GMD_FORMULA_SECURITY
107: WHERE organization_id = before_sec_prof_rec.organization_id
108: AND NVL(user_id,-1) = NVL(before_sec_prof_rec.user_id,-1)
109: AND NVL(responsibility_id,0) = NVL(before_sec_prof_rec.responsibility_id,0)
110: AND NVL(other_organization_id, -1) = NVL(before_sec_prof_rec.other_organization_id, -1) ;

Line 141: --Creates new records in GMD_FORMULA_SECURITY table when db action is insert.

137: END IF;
138:
139: --Called from Manual Entry on formula for a specific formula.
140: ELSE
141: --Creates new records in GMD_FORMULA_SECURITY table when db action is insert.
142: IF p_db_action_ind = 'I' THEN
143: OPEN cur_form_1 ;
144: FETCH cur_form_1 INTO get_rec_1;
145: IF cur_form_1%FOUND THEN

Line 146: INSERT INTO GMD_FORMULA_SECURITY (

142: IF p_db_action_ind = 'I' THEN
143: OPEN cur_form_1 ;
144: FETCH cur_form_1 INTO get_rec_1;
145: IF cur_form_1%FOUND THEN
146: INSERT INTO GMD_FORMULA_SECURITY (
147: formula_security_id,
148: formula_id,
149: access_type_ind,
150: organization_id,

Line 159: gmd_formula_security_id_s.NEXTVAL,

155: creation_date,
156: last_update_date,
157: last_updated_by)
158: VALUES (
159: gmd_formula_security_id_s.NEXTVAL,
160: get_rec_1.formula_id,
161: sec_prof_rec.access_type_ind,
162: get_rec_1.owner_organization_id,
163: sec_prof_rec.user_id,

Line 174: DELETE FROM GMD_FORMULA_SECURITY

170: END IF;
171: CLOSE cur_form_1;
172: -- If db action is delete then delete all old profiles from Formula Security table.
173: ELSIF p_db_action_ind = 'D' THEN
174: DELETE FROM GMD_FORMULA_SECURITY
175: WHERE organization_id = sec_prof_rec.organization_id
176: AND NVL(user_id,-1) = NVL(sec_prof_rec.user_id,-1)
177: AND NVL(responsibility_id,0) = NVL(sec_prof_rec.responsibility_id,0)
178: AND NVL(other_organization_id, -1) = NVL(sec_prof_rec.other_organization_id, -1)

Line 181: UPDATE GMD_FORMULA_SECURITY

177: AND NVL(responsibility_id,0) = NVL(sec_prof_rec.responsibility_id,0)
178: AND NVL(other_organization_id, -1) = NVL(sec_prof_rec.other_organization_id, -1)
179: AND formula_id = p_formula_id;
180: ELSE -- Update the Formula Security table with new data when db action is Update.
181: UPDATE GMD_FORMULA_SECURITY
182: SET organization_id = sec_prof_rec.organization_id,
183: user_id = sec_prof_rec.user_id,
184: responsibility_id = sec_prof_rec.responsibility_id,
185: other_organization_id = sec_prof_rec.other_organization_id,