111: L_PARENT_ID NUMBER;
112: L_ERR NUMBER := 0;
113: BEGIN
114: if p_date is null then
115: p_date := fnd_date.date_to_canonical(trunc(SYSDATE));
116: end if;
117: p_r_date := fnd_date.canonical_to_date(p_date);
118: --p_r_date:=p_date;
119:
113: BEGIN
114: if p_date is null then
115: p_date := fnd_date.date_to_canonical(trunc(SYSDATE));
116: end if;
117: p_r_date := fnd_date.canonical_to_date(p_date);
118: --p_r_date:=p_date;
119:
120: p_date_disp := fnd_date.date_to_displaydate(p_r_date , calendar_aware=>1); -- Bug#12547417
121:
116: end if;
117: p_r_date := fnd_date.canonical_to_date(p_date);
118: --p_r_date:=p_date;
119:
120: p_date_disp := fnd_date.date_to_displaydate(p_r_date , calendar_aware=>1); -- Bug#12547417
121:
122:
123: IF P_ORG_STRUCTURE_VERSION_ID IS NOT NULL THEN
124: IF P_ORG_ID IS NULL THEN