APPS.PA_CI_ACTIONS_UTIL dependencies on PA_CONTROL_ITEMS

Line 31: from pa_control_items pci

27: return number
28: IS
29: Cursor next_number is
30: select pci.last_action_number
31: from pa_control_items pci
32: where pci.ci_id = p_ci_id
33: for update of pci.last_action_number;
34:
35: l_next_number number;

Line 46: UPDATE pa_control_items

42: l_next_number := 1;
43: end if;
44:
45:
46: UPDATE pa_control_items
47: set last_action_number = l_next_number + 1
48: where ci_id = p_ci_id;
49: return l_next_number;
50: EXCEPTION

Line 215: from pa_control_items

211: RETURN VARCHAR2
212: IS
213: Cursor open_actions is
214: select open_action_num
215: from pa_control_items
216: where ci_id = p_ci_id;
217:
218: --l_result varchar2(1); Commented and changed the data type for bug 4034873
219: l_result pa_control_items.open_action_num%type;

Line 219: l_result pa_control_items.open_action_num%type;

215: from pa_control_items
216: where ci_id = p_ci_id;
217:
218: --l_result varchar2(1); Commented and changed the data type for bug 4034873
219: l_result pa_control_items.open_action_num%type;
220:
221: BEGIN
222: Open open_actions;
223: fetch open_actions into l_result;