DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PVT dependencies on CSI_MASS_EDIT_ENTRIES_VL

Line 494: l_mass_edit_rec csi_mass_edit_entries_vl%rowtype;

490: x_mass_edit_rec OUT NOCOPY csi_mass_edit_pub.mass_edit_rec)
491: RETURN BOOLEAN
492: IS
493:
494: l_mass_edit_rec csi_mass_edit_entries_vl%rowtype;
495: l_dup_batch_name NUMBER := NULL;
496:
497: CURSOR dup_batch_name (p_batch_id IN NUMBER, p_batch_name IN VARCHAR2) IS
498: SELECT 1

Line 510: FROM csi_mass_edit_entries_vl

506: IF nvl(p_batch_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
507:
508: SELECT *
509: INTO l_mass_edit_rec
510: FROM csi_mass_edit_entries_vl
511: WHERE entry_id = p_batch_id;
512:
513: -- to validate duplicate batch name in an update scenaio...
514:

Line 546: FROM csi_mass_edit_entries_vl

542: ,l_mass_edit_rec.txn_line_id
543: ,l_mass_edit_rec.batch_type
544: ,l_mass_edit_rec.status_code
545: ,l_mass_edit_rec.schedule_date
546: FROM csi_mass_edit_entries_vl
547: WHERE name = p_batch_name;
548:
549: END IF;
550:

Line 587: FROM csi_mass_edit_entries_vl

583: p_api_name => p_api_name);
584:
585: BEGIN
586: SELECT 'X' INTO l_found
587: FROM csi_mass_edit_entries_vl
588: WHERE name = p_batch_name;
589:
590: EXCEPTION
591: WHEN NO_DATA_FOUND THEN