DBA Data[Home] [Help]

APPS.PAY_VOID_PAYMENTS dependencies on FND_DATE

Line 103: l_effective_date := trunc(fnd_date.canonical_to_date (p_effective_date));

99: hr_utility.set_location ('void_run',1);
100: --------------------------------------------------------------------------------
101: -- Convert date. NB: This will have to change to generic data format in 10.7
102: --------------------------------------------------------------------------------
103: l_effective_date := trunc(fnd_date.canonical_to_date (p_effective_date));
104: --
105: if p_start_assignment is not null then
106: l_start_cheque := null;
107: l_end_cheque := null;

Line 142: fnd_date.date_to_canonical(overlap_row.effective_date);

138: hr_utility.set_location ('void_run',31);
139: IF action_type = 'H' THEN
140: p_errmsg := 'Overlap detected. Cheque #' || overlap_row.cheque_number ||
141: ' already voided in run performed on ' ||
142: fnd_date.date_to_canonical(overlap_row.effective_date);
143: p_errcode := 2; -- Error
144: ELSIF action_type = 'M' THEN
145: p_errmsg := 'Overlap detected. MagTape Assignment Action #' ||
146: overlap_row.assignment_action_id ||

Line 148: fnd_date.date_to_canonical(overlap_row.effective_date);

144: ELSIF action_type = 'M' THEN
145: p_errmsg := 'Overlap detected. MagTape Assignment Action #' ||
146: overlap_row.assignment_action_id ||
147: ' already voided in run performed on ' ||
148: fnd_date.date_to_canonical(overlap_row.effective_date);
149: p_errcode := 2; -- Error
150: END IF;
151: RETURN;
152: END IF;