[Home] [Help]
3:
4: PROCEDURE sec_prof_form(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: before_sec_prof_rec IN gmd_security_profiles%ROWTYPE,
8: sec_prof_rec IN gmd_security_profiles%ROWTYPE,
9: p_formula_id IN NUMBER,
10: p_db_action_ind IN VARCHAR2,
11: x_return_status OUT NOCOPY VARCHAR2,
4: PROCEDURE sec_prof_form(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: before_sec_prof_rec IN gmd_security_profiles%ROWTYPE,
8: sec_prof_rec IN gmd_security_profiles%ROWTYPE,
9: p_formula_id IN NUMBER,
10: p_db_action_ind IN VARCHAR2,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
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
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'
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
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:
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)
31: 1) INSERT :- Create records in GMD_FORMULA_SECURITY one for each security profile, with
67: -- GMD_SECURITY_PROFILE table updated when called from GMDFMSCP form , Formula Id is always NULL
68: --
69: IF NVL(p_formula_id,0) = 0
70: THEN
71: --Creates new records in GMD_SECURITY_PROFILES table when db action is insert.
72: IF p_db_action_ind = 'I'
73: THEN
74: INSERT INTO GMD_SECURITY_PROFILES (
75: security_profile_id,
70: THEN
71: --Creates new records in GMD_SECURITY_PROFILES table when db action is insert.
72: IF p_db_action_ind = 'I'
73: THEN
74: INSERT INTO GMD_SECURITY_PROFILES (
75: security_profile_id,
76: object_type,
77: organization_id,
78: other_organization_id,
111: END IF;
112:
113: -- If db action is delete then delete all old profiles from Security Profile table.
114: IF p_db_action_ind = 'D' THEN
115: DELETE FROM GMD_SECURITY_PROFILES
116: WHERE organization_id = sec_prof_rec.organization_id
117: AND NVL(user_id,-1) = NVL(sec_prof_rec.user_id,-1)
118: AND NVL(responsibility_id,0) = NVL(sec_prof_rec.responsibility_id,0)
119: AND NVL(other_organization_id, -1) = NVL(sec_prof_rec.other_organization_id, -1);
119: AND NVL(other_organization_id, -1) = NVL(sec_prof_rec.other_organization_id, -1);
120:
121: -- Update the Security Profile table with new data when db action is Update.
122: ELSE
123: UPDATE GMD_SECURITY_PROFILES
124: SET organization_id = sec_prof_rec.organization_id,
125: other_organization_id = sec_prof_rec.other_organization_id,
126: user_id = sec_prof_rec.user_id,
127: responsibility_id = sec_prof_rec.responsibility_id,