APPS.GMD_FORMULA_SECURITY_ACCESS dependencies on FND_GLOBAL

Line 27: x_resp_id := fnd_global.resp_id;

23: DELETE FROM gmd_formula_security_temp;
24:
25: COMMIT;
26:
27: x_resp_id := fnd_global.resp_id;
28: x_user_id := fnd_global.user_id;
29:
30:
31: SELECT responsibility_id INTO v_resp_id

Line 28: x_user_id := fnd_global.user_id;

24:
25: COMMIT;
26:
27: x_resp_id := fnd_global.resp_id;
28: x_user_id := fnd_global.user_id;
29:
30:
31: SELECT responsibility_id INTO v_resp_id
32: FROM fnd_responsibility

Line 35: -- fnd_global.apps_initialize (2060, v_resp_id , 552);

31: SELECT responsibility_id INTO v_resp_id
32: FROM fnd_responsibility
33: WHERE responsibility_key = 'GMD_SECURITY_PROFILE_MGR';
34:
35: -- fnd_global.apps_initialize (2060, v_resp_id , 552);
36: l_organization_id := p_organization_id;
37: l_formula_id := p_formula_id;
38:
39: INSERT INTO gmd_formula_security_temp( assign_method_ind,

Line 118: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

114: WHERE organization_id = l_organization_id
115: AND formula_id = l_formula_id;
116:
117: COMMIT;
118: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

Line 122: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

118: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
123: X_return_code := SQLCODE;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
126:

Line 128: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
129: X_return_code := SQLCODE;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
132:

Line 134: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);

130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
132:
133: WHEN OTHERS THEN
134: -- fnd_global.apps_initialize (x_user_id, x_resp_id , 552);
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
137: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
138: FND_MSG_PUB.ADD;