APPS.AD_MANUAL_STEP_OBJECT dependencies on AD_MANUAL_STEP_HISTORY

Line 15: from ad_manual_step_history

11: return number is
12: hist_count number :=0;
13: begin
14: select count(0) into hist_count
15: from ad_manual_step_history
16: where step_key = p_step_key and
17: step_version = p_step_version and
18: status = p_status;
19:

Line 42: -- Procedure that adds manual steps in to ad_manual_step_history table

38: end is_step_already_done;
39:
40:
41: --
42: -- Procedure that adds manual steps in to ad_manual_step_history table
43: -- with the given parameters.
44: --
45: procedure add_manual_step_history(p_patch_number varchar2,
46: p_step_key varchar2,

Line 57: from ad_manual_step_history

53: l_step_key varchar2(100);
54: begin
55: select step_key
56: into l_step_key
57: from ad_manual_step_history
58: where step_key = p_step_key and
59: step_version = p_step_version;
60:
61: update ad_manual_step_history

Line 61: update ad_manual_step_history

57: from ad_manual_step_history
58: where step_key = p_step_key and
59: step_version = p_step_version;
60:
61: update ad_manual_step_history
62: set status = p_status,
63: patch_number = p_patch_number
64: where step_key = p_step_key and
65: step_version = p_step_version;

Line 69: insert into ad_manual_step_history

65: step_version = p_step_version;
66:
67: exception
68: when NO_DATA_FOUND then
69: insert into ad_manual_step_history
70: (history_id, step_key, step_version,step_text, cond_code,
71: patch_number, status, updated_by)
72: values
73: (ad_manual_step_history_s.nextval, p_step_key, p_step_version,

Line 73: (ad_manual_step_history_s.nextval, p_step_key, p_step_version,

69: insert into ad_manual_step_history
70: (history_id, step_key, step_version,step_text, cond_code,
71: patch_number, status, updated_by)
72: values
73: (ad_manual_step_history_s.nextval, p_step_key, p_step_version,
74: p_step_text, p_cond_code, p_patch_number,
75: p_status, p_username);
76: end;
77:

Line 83: update ad_manual_step_history

79: -- Procedure that updates given manual steps as completed.
80: --
81: procedure update_step_as_completed(p_patch_number varchar2) is
82: begin
83: update ad_manual_step_history
84: set status = 'Y'
85: where
86: status='D' and patch_number=p_patch_number;
87: end;