APPS.IGC_CC_BC_ENABLE_PKG dependencies on IGC_CC_BC_ENABLE

Line 1: PACKAGE BODY IGC_CC_BC_ENABLE_PKG AS

1: PACKAGE BODY IGC_CC_BC_ENABLE_PKG AS
2: /*$Header: IGCCENBB.pls 120.3.12000000.1 2007/08/20 12:12:19 mbremkum ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_BC_ENABLE_PKG';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_BC_ENABLE_PKG';

1: PACKAGE BODY IGC_CC_BC_ENABLE_PKG AS
2: /*$Header: IGCCENBB.pls 120.3.12000000.1 2007/08/20 12:12:19 mbremkum ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_BC_ENABLE_PKG';
5:
6: -- The flag determines whether to print debug information or not.
7: g_debug_flag VARCHAR2(1) := 'N' ;
8:

Line 38: CURSOR C IS SELECT ROWID FROM igc_cc_bc_enable

34:
35: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
36: l_api_version CONSTANT NUMBER := 1.0;
37:
38: CURSOR C IS SELECT ROWID FROM igc_cc_bc_enable
39: WHERE set_of_books_id = p_set_of_books_id;
40:
41: BEGIN
42:

Line 60: INSERT INTO igc_cc_bc_enable

56: END IF;
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS ;
59:
60: INSERT INTO igc_cc_bc_enable
61: (
62: set_of_books_id,
63: cc_bc_enable_flag,
64: last_update_date,

Line 160: SELECT * FROM igc_cc_bc_enable

156: l_api_version CONSTANT NUMBER := 1.0;
157:
158: Counter NUMBER;
159: CURSOR C IS
160: SELECT * FROM igc_cc_bc_enable
161: WHERE rowid = p_row_id
162: FOR UPDATE NOWAIT;
163: Recinfo C%ROWTYPE;
164:

Line 307: UPDATE igc_cc_bc_enable

303:
304: x_return_status := FND_API.G_RET_STS_SUCCESS ;
305:
306:
307: UPDATE igc_cc_bc_enable
308: SET
309: set_of_books_id = p_set_of_books_id,
310: cc_bc_enable_flag = p_cc_bc_enable_flag,
311: last_update_date = p_last_update_date ,

Line 407: -- Deleting the record in igc_cc_bc_enable.

403: END IF ;
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS ;
406:
407: -- Deleting the record in igc_cc_bc_enable.
408:
409: DELETE FROM igc_cc_bc_enable
410: WHERE rowid = p_row_id;
411:

Line 409: DELETE FROM igc_cc_bc_enable

405: x_return_status := FND_API.G_RET_STS_SUCCESS ;
406:
407: -- Deleting the record in igc_cc_bc_enable.
408:
409: DELETE FROM igc_cc_bc_enable
410: WHERE rowid = p_row_id;
411:
412:
413: IF (SQL%NOTFOUND) THEN

Line 485: FROM igc_cc_bc_enable

481: l_tmp VARCHAR2(1);
482:
483: CURSOR c IS
484: SELECT '1'
485: FROM igc_cc_bc_enable
486: WHERE set_of_books_id = p_set_of_books_id
487: AND (
488: p_row_id IS NULL
489: OR

Line 512: -- Checking the igc_cc_bc_enable table for uniqueness.

508: END IF;
509:
510: x_return_status := FND_API.G_RET_STS_SUCCESS ;
511:
512: -- Checking the igc_cc_bc_enable table for uniqueness.
513: OPEN c;
514: FETCH c INTO l_tmp;
515:
516: -- p_Return_Value specifies whether unique value exists or not.

Line 565: END IGC_CC_BC_ENABLE_PKG;

561: END Check_Unique;
562: /* ----------------------------------------------------------------------- */
563:
564:
565: END IGC_CC_BC_ENABLE_PKG;