APPS.HXT_HDR dependencies on HXT_HOUR_DEDUCTION_RULES

Line 20: from HXT_HOUR_DEDUCTION_RULES

16: p_last_update_login NUMBER
17: ) is
18:
19: cursor c2 is select rowid
20: from HXT_HOUR_DEDUCTION_RULES
21: where effective_start_date = p_effective_start_date
22: and effective_end_date = p_effective_end_date
23: and hdp_id = p_hdp_id;
24:

Line 27: insert into HXT_HOUR_DEDUCTION_RULES(

23: and hdp_id = p_hdp_id;
24:
25: begin
26:
27: insert into HXT_HOUR_DEDUCTION_RULES(
28: hdp_id,
29: fcl_deduction_type,
30: effective_start_date,
31: hours,

Line 77: update HXT_HOUR_DEDUCTION_RULES

73: ) is
74:
75: begin
76:
77: update HXT_HOUR_DEDUCTION_RULES
78: set
79: fcl_deduction_type = p_fcl_deduction_type,
80: effective_start_date = p_effective_start_date,
81: hours = p_hours,

Line 96: delete from HXT_HOUR_DEDUCTION_RULES

92:
93:
94: procedure delete_HXT_HOUR_DEDUCTION_RULE(p_rowid VARCHAR2) is
95: begin
96: delete from HXT_HOUR_DEDUCTION_RULES
97: where rowid = chartorowid(p_rowid);
98: end delete_HXT_HOUR_DEDUCTION_RULE;
99:
100: procedure lock_HXT_HOUR_DEDUCTION_RULES(p_rowid VARCHAR2) is

Line 100: procedure lock_HXT_HOUR_DEDUCTION_RULES(p_rowid VARCHAR2) is

96: delete from HXT_HOUR_DEDUCTION_RULES
97: where rowid = chartorowid(p_rowid);
98: end delete_HXT_HOUR_DEDUCTION_RULE;
99:
100: procedure lock_HXT_HOUR_DEDUCTION_RULES(p_rowid VARCHAR2) is
101: vnull number;
102: begin
103: if p_rowid is not null then
104: select HDP_ID into vnull

Line 105: from HXT_HOUR_DEDUCTION_RULES

101: vnull number;
102: begin
103: if p_rowid is not null then
104: select HDP_ID into vnull
105: from HXT_HOUR_DEDUCTION_RULES
106: where rowid = p_rowid
107: for update of HXT_HOUR_DEDUCTION_RULES.HDP_ID nowait;
108:
109: end if;

Line 107: for update of HXT_HOUR_DEDUCTION_RULES.HDP_ID nowait;

103: if p_rowid is not null then
104: select HDP_ID into vnull
105: from HXT_HOUR_DEDUCTION_RULES
106: where rowid = p_rowid
107: for update of HXT_HOUR_DEDUCTION_RULES.HDP_ID nowait;
108:
109: end if;
110: end lock_HXT_HOUR_DEDUCTION_RULES;
111:

Line 110: end lock_HXT_HOUR_DEDUCTION_RULES;

106: where rowid = p_rowid
107: for update of HXT_HOUR_DEDUCTION_RULES.HDP_ID nowait;
108:
109: end if;
110: end lock_HXT_HOUR_DEDUCTION_RULES;
111:
112: end HXT_HDR;