603: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
604: x_return_status OUT NOCOPY VARCHAR2,
605: x_msg_count OUT NOCOPY NUMBER,
606: x_msg_data OUT NOCOPY VARCHAR2,
607: p_org_id IN igc_cc_headers.org_id%TYPE,
608: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
609: x_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE
610: ) IS
611: PRAGMA AUTONOMOUS_TRANSACTION; -- Added for bug 3329666
604: x_return_status OUT NOCOPY VARCHAR2,
605: x_msg_count OUT NOCOPY NUMBER,
606: x_msg_data OUT NOCOPY VARCHAR2,
607: p_org_id IN igc_cc_headers.org_id%TYPE,
608: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
609: x_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE
610: ) IS
611: PRAGMA AUTONOMOUS_TRANSACTION; -- Added for bug 3329666
612:
605: x_msg_count OUT NOCOPY NUMBER,
606: x_msg_data OUT NOCOPY VARCHAR2,
607: p_org_id IN igc_cc_headers.org_id%TYPE,
608: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
609: x_cc_num OUT NOCOPY igc_cc_headers.cc_num%TYPE
610: ) IS
611: PRAGMA AUTONOMOUS_TRANSACTION; -- Added for bug 3329666
612:
613: l_api_name CONSTANT VARCHAR2(30) := 'Create_Auto_CC_Num';
617: x_cc_prefix igc_cc_system_options_all.cc_prefix%TYPE;
618: x_cc_num_exists NUMBER;
619: x_po_num_exists NUMBER;
620: -- sb: x_cc_next_num should be a number
621: -- x_cc_next_num igc_cc_headers.cc_num%TYPE;
622: x_cc_next_num igc_cc_system_options_all.cc_next_num%TYPE;
623: -- sb: end
624:
625: -- mh: define cursor to get cc_prefix and cc_num from igc_cc_number_methods
743:
744: -- validate number is unique across both CC and PO
745: SELECT count(*)
746: INTO x_cc_num_exists
747: FROM igc_cc_headers
748: WHERE cc_num = x_cc_num;
749:
750: SELECT count(*)
751: INTO x_po_num_exists
858: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
859: x_return_status OUT NOCOPY VARCHAR2,
860: x_msg_count OUT NOCOPY NUMBER,
861: x_msg_data OUT NOCOPY VARCHAR2,
862: p_cc_num IN igc_cc_headers.cc_num%TYPE
863: )
864: IS
865:
866: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Numeric_CC_Num';