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 745: p_reset_date => fnd_date.canonical_to_date(p_reset_date),

741: p_dimension_name => p_dimension_name,
742: p_database_item_suffix => p_database_item_suffix,
743: p_business_group_id => p_business_group_id,
744: p_date_type => p_date_type,
745: p_reset_date => fnd_date.canonical_to_date(p_reset_date),
746: p_frequency_type => p_frequency_type,
747: p_frequency => fnd_number.canonical_to_number(p_frequency),
748: p_exclude_reversal => (p_exclude_reversal = 'Y'),
749: p_balance_dimension_id => l_balance_dimension_id);

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

987: --
988: update_balance_dimension(
989: p_balance_dimension_id => fnd_number.canonical_to_number(p_balance_dimension_id),
990: p_date_type => p_date_type,
991: p_reset_date => fnd_date.canonical_to_date(p_reset_date),
992: p_frequency_type => p_frequency_type,
993: p_frequency => fnd_number.canonical_to_number(p_frequency),
994: p_exclude_reversal => (p_exclude_reversal = 'Y'));
995: exception

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

1190: --
1191: update_balance_dimension(
1192: p_balance_dimension_id => l_rec.balance_dimension_id,
1193: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1194: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1195: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1196: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1197: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1198: p_rebuild_package => false);

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

1229: add_body(' p_dimension_name in varchar2,');
1230: add_body(' p_expiry_information out nocopy number)');
1231: add_body('is');
1232: add_body('begin');
1233: add_body(' if start_date(p_user_effective_date, fnd_date.canonical_to_date(''' ||
1234: l_reset_date || '''), ''' || l_frequency_type || ''', ' || l_frequency || ') > p_owner_effective_date then');
1235: add_body(' p_expiry_information := 1;');
1236: add_body(' else');
1237: add_body(' p_expiry_information := 0;');

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

1260: add_body(' p_dimension_name in varchar2,');
1261: add_body(' p_expiry_information out nocopy date)');
1262: add_body('is');
1263: add_body('begin');
1264: add_body(' p_expiry_information := end_date(p_owner_effective_date, fnd_date.canonical_to_date(''' ||
1265: l_reset_date || '''), ''' || l_frequency_type || ''', ' || l_frequency || ');');
1266: add_body('end ' || l_rec.expiry_checking_code || ';');
1267: end if;
1268: --

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

1285: add_body(' p_bus_grp in number,');
1286: add_body(' p_asg_action in number)');
1287: add_body('is');
1288: add_body('begin');
1289: add_body(' p_start_date := start_date(p_effective_date, fnd_date.canonical_to_date(''' ||
1290: l_reset_date || '''), ''' || l_frequency_type || ''', ' || l_frequency || ');');
1291: add_body('end ' || l_rec.start_date_code || ';');
1292: end if;
1293: end loop;