APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on FND_DATE

Line 84: return replace(p_src, p_old, fnd_date.date_to_canonical(p_new));

80: p_old in varchar2,
81: p_new in date) return varchar2
82: is
83: begin
84: return replace(p_src, p_old, fnd_date.date_to_canonical(p_new));
85: end my_replace;
86: -- ----------------------------------------------------------------------------
87: -- |------------------------------< my_replace >------------------------------|
88: -- ----------------------------------------------------------------------------

Line 148: fnd_message.set_token('RESET_DATE', fnd_date.date_to_chardt(p_reset_date));

144: end if;
145: --
146: if p_reset_date <> trunc(p_reset_date) then
147: fnd_message.set_name('PAY', 'PAY_JP_DIM_INVALID_RESET_DATE');
148: fnd_message.set_token('RESET_DATE', fnd_date.date_to_chardt(p_reset_date));
149: fnd_message.raise_error;
150: end if;
151: --
152: if p_frequency_type not in ('DAY', 'SMONTH', 'MONTH') then

Line 754: p_reset_date => fnd_date.canonical_to_date(p_reset_date),

750: p_dimension_name => p_dimension_name,
751: p_database_item_suffix => p_database_item_suffix,
752: p_business_group_id => p_business_group_id,
753: p_date_type => p_date_type,
754: p_reset_date => fnd_date.canonical_to_date(p_reset_date),
755: p_frequency_type => p_frequency_type,
756: p_frequency => fnd_number.canonical_to_number(p_frequency),
757: p_exclude_reversal => (p_exclude_reversal = 'Y'),
758: p_balance_dimension_id => l_balance_dimension_id);

Line 1009: p_reset_date => fnd_date.canonical_to_date(p_reset_date),

1005: --
1006: update_balance_dimension(
1007: p_balance_dimension_id => fnd_number.canonical_to_number(p_balance_dimension_id),
1008: p_date_type => p_date_type,
1009: p_reset_date => fnd_date.canonical_to_date(p_reset_date),
1010: p_frequency_type => p_frequency_type,
1011: p_frequency => fnd_number.canonical_to_number(p_frequency),
1012: p_exclude_reversal => (p_exclude_reversal = 'Y'));
1013: exception

Line 1212: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),

1208: --
1209: update_balance_dimension(
1210: p_balance_dimension_id => l_rec.balance_dimension_id,
1211: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1212: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1213: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1214: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1215: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1216: p_rebuild_package => false);

Line 1251: add_body(' if start_date(p_user_effective_date, fnd_date.canonical_to_date(''' ||

1247: add_body(' p_dimension_name in varchar2,');
1248: add_body(' p_expiry_information out nocopy number)');
1249: add_body('is');
1250: add_body('begin');
1251: add_body(' if start_date(p_user_effective_date, fnd_date.canonical_to_date(''' ||
1252: l_reset_date || '''), ''' || l_frequency_type || ''', ' || l_frequency || ') > p_owner_effective_date then');
1253: add_body(' p_expiry_information := 1;');
1254: add_body(' else');
1255: add_body(' p_expiry_information := 0;');

Line 1282: add_body(' p_expiry_information := end_date(p_owner_effective_date, fnd_date.canonical_to_date(''' ||

1278: add_body(' p_dimension_name in varchar2,');
1279: add_body(' p_expiry_information out nocopy date)');
1280: add_body('is');
1281: add_body('begin');
1282: add_body(' p_expiry_information := end_date(p_owner_effective_date, fnd_date.canonical_to_date(''' ||
1283: l_reset_date || '''), ''' || l_frequency_type || ''', ' || l_frequency || ');');
1284: add_body('end ' || l_rec.expiry_checking_code || ';');
1285: end if;
1286: --

Line 1307: add_body(' p_start_date := start_date(p_effective_date, fnd_date.canonical_to_date(''' ||

1303: add_body(' p_bus_grp in number,');
1304: add_body(' p_asg_action in number)');
1305: add_body('is');
1306: add_body('begin');
1307: add_body(' p_start_date := start_date(p_effective_date, fnd_date.canonical_to_date(''' ||
1308: l_reset_date || '''), ''' || l_frequency_type || ''', ' || l_frequency || ');');
1309: add_body('end ' || l_rec.start_date_code || ';');
1310: end if;
1311: end loop;