APPS.IGC_CC_SYSTEM_OPTIONS_PKG dependencies on IGC_CC_SYSTEM_OPTIONS_ALL

Line 53: FROM IGC_CC_SYSTEM_OPTIONS_ALL

49: l_api_version CONSTANT NUMBER := 1.0;
50:
51: CURSOR cur_sys_options IS
52: SELECT ROWID
53: FROM IGC_CC_SYSTEM_OPTIONS_ALL
54: WHERE org_id = p_org_id;
55:
56: BEGIN
57:

Line 75: INSERT INTO IGC_CC_SYSTEM_OPTIONS_ALL

71: END IF;
72:
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: INSERT INTO IGC_CC_SYSTEM_OPTIONS_ALL
76: (
77: org_id,
78: cc_num_method,
79: cc_num_datatype,

Line 185: FROM IGC_CC_SYSTEM_OPTIONS_ALL

181: Counter NUMBER;
182:
183: CURSOR cur_sys_options IS
184: SELECT *
185: FROM IGC_CC_SYSTEM_OPTIONS_ALL
186: WHERE ROWID = p_row_id
187: FOR UPDATE NOWAIT;
188:
189: Recinfo cur_sys_options%ROWTYPE;

Line 347: UPDATE IGC_CC_SYSTEM_OPTIONS_ALL

343: END IF;
344:
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: UPDATE IGC_CC_SYSTEM_OPTIONS_ALL
348: SET
349: org_id = p_org_id,
350: cc_num_method = p_cc_num_method,
351: cc_num_datatype = p_cc_num_datatype,

Line 441: -- Deleting the record in igc_cc_system_options_all.

437: END IF;
438:
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: -- Deleting the record in igc_cc_system_options_all.
442:
443: DELETE FROM IGC_CC_SYSTEM_OPTIONS_ALL
444: WHERE ROWID = p_row_id;
445:

Line 443: DELETE FROM IGC_CC_SYSTEM_OPTIONS_ALL

439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: -- Deleting the record in igc_cc_system_options_all.
442:
443: DELETE FROM IGC_CC_SYSTEM_OPTIONS_ALL
444: WHERE ROWID = p_row_id;
445:
446: IF (SQL%NOTFOUND) THEN
447: RAISE NO_DATA_FOUND;

Line 514: FROM igc_cc_system_options_all

510: l_tmp VARCHAR2(1);
511:
512: CURSOR c IS
513: SELECT '1'
514: FROM igc_cc_system_options_all
515: WHERE org_id = p_org_id
516: AND (
517: p_row_id IS NULL
518: OR

Line 617: x_cc_prefix igc_cc_system_options_all.cc_prefix%TYPE;

613: l_api_name CONSTANT VARCHAR2(30) := 'Create_Auto_CC_Num';
614: l_api_version CONSTANT NUMBER := 1.0;
615:
616: -- mh: define variables
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;

Line 622: x_cc_next_num igc_cc_system_options_all.cc_next_num%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
626: CURSOR c_cc_num(l_org_id NUMBER) IS

Line 628: FROM igc_cc_system_options_all

624:
625: -- mh: define cursor to get cc_prefix and cc_num from igc_cc_number_methods
626: CURSOR c_cc_num(l_org_id NUMBER) IS
627: SELECT cc_prefix, cc_next_num
628: FROM igc_cc_system_options_all
629: WHERE org_id = l_org_id
630: FOR UPDATE NOWAIT; -- Added for bug 3329666
631:
632: -- sb: define exceptions

Line 767: UPDATE igc_cc_system_options_all

763: ELSE
764: -- ---------------------------------------------------------------
765: -- Update the numbering scheme first for the org_id given
766: -- ---------------------------------------------------------------
767: UPDATE igc_cc_system_options_all
768: SET cc_next_num = x_cc_next_num + 1
769: WHERE org_id = p_org_id;
770: -- ---------------------------------------------------------------
771: -- Make sure that ONLY one row has been updated.