DBA Data[Home] [Help]

APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_API

Line 418: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));

414:
415: l_note_msg VARCHAR2(240);
416: BEGIN
417: fnd_message.set_name('CN', 'CN_PAYEE_UPD_NOTE');
418: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
419: fnd_message.set_token('OLD', p_old_value);
420: fnd_message.set_token('NEW', p_new_value);
421: l_note_msg := fnd_message.get;
422:

Line 716: l_date_range_action_tbl cn_api.date_range_action_tbl_type;

712: AND p.org_id = ps.org_id
713: AND spa.srp_payee_assign_id = l_srp_payee_assign_id
714: AND spa.org_id = l_old_rec.org_id;
715:
716: l_date_range_action_tbl cn_api.date_range_action_tbl_type;
717: l_count number;
718:
719: l_key VARCHAR2(80);
720: l_list wf_parameter_list_t;

Line 793: cn_api.get_date_range_diff_action

789: Nvl(l_old_rec.end_date, l_end_of_time))
790: THEN
791: -- make sure no worksheets in any part of the shrunk range
792: -- this is for bug fix 3390199
793: cn_api.get_date_range_diff_action
794: (start_date_new => p_start_date
795: ,end_date_new => Nvl(p_end_date, l_end_of_time)
796: ,start_date_old => l_old_rec.start_date
797: ,end_date_old => Nvl(l_old_rec.end_date, l_end_of_time)

Line 802: IF CN_API.date_range_overlap

798: ,x_date_range_action_tbl => l_date_range_action_tbl );
799: FOR d IN 1..l_date_range_action_tbl.COUNT LOOP
800: if l_date_range_action_tbl(d).action_flag = 'D' THEN
801: for w in get_worksheets(p_srp_payee_assign_id) loop
802: IF CN_API.date_range_overlap
803: (l_date_range_action_tbl(d).start_date,
804: l_date_range_action_tbl(d).end_date,
805: w.start_date,
806: w.end_date) = true then

Line 1015: IF CN_API.date_range_overlap

1011: WHERE srp_payee_assign_id = p_srp_payee_assign_id;
1012:
1013: -- check payee has no worksheet for bug 3390199
1014: FOR w IN get_worksheets loop
1015: IF CN_API.date_range_overlap
1016: (l_start_date,
1017: l_end_date,
1018: w.start_date,
1019: w.end_date) = true THEN