APPS.PSA_IMPLEMENTATION dependencies on PSA_IMPLEMENTATION_ALL

Line 31: FROM psa_implementation_all

27: --
28: if g_mfar_enabled is null THEN
29: SELECT status
30: INTO p_enabled_flag
31: FROM psa_implementation_all
32: WHERE org_id = p_org_id
33: AND psa_feature = p_psa_feature;
34: g_mfar_enabled := p_enabled_flag;
35: --

Line 54: FROM psa_implementation_all

50: l_enabled_flag varchar2(1);
51: BEGIN
52: SELECT status
53: INTO l_enabled_flag
54: FROM psa_implementation_all
55: WHERE org_id = p_org_id
56: AND psa_feature = p_psa_feature;
57: --
58: IF l_enabled_flag = 'Y' THEN

Line 61: UPDATE psa_implementation_all

57: --
58: IF l_enabled_flag = 'Y' THEN
59: NULL;
60: ELSIF l_enabled_flag = 'N' THEN
61: UPDATE psa_implementation_all
62: SET status = 'Y'
63: WHERE org_id = p_org_id
64: AND psa_feature = p_psa_feature;
65: END IF;

Line 68: INSERT INTO psa_implementation_all(psa_feature

64: AND psa_feature = p_psa_feature;
65: END IF;
66: --
67: EXCEPTION WHEN no_data_found THEN
68: INSERT INTO psa_implementation_all(psa_feature
69: ,status
70: ,org_id)
71: VALUES (p_psa_feature
72: ,'Y'

Line 86: FROM psa_implementation_all

82: -- ========================= FND LOG ===========================
83: BEGIN
84: SELECT status
85: INTO l_enabled_flag
86: FROM psa_implementation_all
87: WHERE org_id = p_org_id
88: AND psa_feature = p_psa_feature;
89: --
90: IF l_enabled_flag = 'N' THEN

Line 93: UPDATE psa_implementation_all

89: --
90: IF l_enabled_flag = 'N' THEN
91: NULL;
92: ELSIF l_enabled_flag = 'Y' THEN
93: UPDATE psa_implementation_all
94: SET status = 'N'
95: WHERE org_id = p_org_id
96: AND psa_feature = p_psa_feature;
97: END IF;

Line 101: INSERT INTO psa_implementation_all(psa_feature

97: END IF;
98: --
99: EXCEPTION
100: WHEN no_data_found THEN
101: INSERT INTO psa_implementation_all(psa_feature
102: ,status
103: ,org_id)
104: VALUES (p_psa_feature
105: ,'N'