DBA Data[Home] [Help]

APPS.HR_CONTINGENT_WORKER_BE2 dependencies on FND_NUMBER

Line 56: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

52: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
53: l_text:=l_text||'';
54: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
55: l_text:='';
56: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
57: l_text:=l_text||'
';
58: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
59: l_text:='';
60: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

Line 60: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

56: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
57: l_text:=l_text||'';
58: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
59: l_text:='';
60: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
61: l_text:=l_text||'
';
62: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
63: l_text:='';
64: l_text:=l_text||irc_utilities_pkg.removeTags(p_npw_number);

Line 72: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);

68: l_text:=l_text||fnd_date.date_to_canonical(p_projected_placement_end);
69: l_text:=l_text||'';
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: l_text:='';
72: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
73: l_text:=l_text||'
';
74: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
75: l_text:='';
76: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);

Line 88: l_text:=l_text||fnd_number.number_to_canonical(p_pdp_object_version_number);

84: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
85: l_text:=l_text||'';
86: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
87: l_text:='';
88: l_text:=l_text||fnd_number.number_to_canonical(p_pdp_object_version_number);
89: l_text:=l_text||'
';
90: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
91: l_text:='';
92: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

Line 92: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

88: l_text:=l_text||fnd_number.number_to_canonical(p_pdp_object_version_number);
89: l_text:=l_text||'';
90: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
91: l_text:='';
92: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
93: l_text:=l_text||'
';
94: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
95: l_text:='';
96: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);

Line 96: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);

92: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
93: l_text:=l_text||'';
94: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
95: l_text:='';
96: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
97: l_text:=l_text||'
';
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: l_text:='';
100: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);

Line 100: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);

96: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
97: l_text:=l_text||'';
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: l_text:='';
100: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
101: l_text:=l_text||'
';
102: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
103: l_text:='';
104: --