APPS.GMA_MIGRATION_PUB dependencies on SY_ORGN_MST

Line 14: -- P_update Update sy_orgn_mst - 'Y' - Yes, 'N' - No

10: -- organization based on its usage.
11: --
12: -- PARAMETERS:
13: -- P_orgn_code Organization Code
14: -- P_update Update sy_orgn_mst - 'Y' - Yes, 'N' - No
15: -- X_active_ind Out variable for active indicator,
16: -- 0 - If organization is not active
17: -- 1 - If the organization is active
18: -- SYNOPSIS:

Line 122: UPDATE sy_orgn_mst

118: END IF;
119: CLOSE Cur_check_item_cost;
120:
121: IF P_update = 'Y' THEN
122: UPDATE sy_orgn_mst
123: SET active_ind = 0
124: WHERE orgn_code = P_orgn_code;
125: END IF;
126: X_active_ind := 1;

Line 130: UPDATE sy_orgn_mst

126: X_active_ind := 1;
127: EXCEPTION
128: WHEN ORG_EXISTS THEN
129: IF P_update = 'Y' THEN
130: UPDATE sy_orgn_mst
131: SET active_ind = 1
132: WHERE orgn_code = P_orgn_code;
133: END IF;
134: X_active_ind := 1;