APPS.GCS_DIMENSION_SET_LINES_PKG dependencies on GCS_DIMENSION_SET_LINES

Line 1: PACKAGE BODY GCS_DIMENSION_SET_LINES_PKG AS

1: PACKAGE BODY GCS_DIMENSION_SET_LINES_PKG AS
2: /* $Header: gcsdmslb.pls 120.1 2005/10/30 05:17:31 appldev noship $ */
3:
4: --
5: -- PRIVATE GLOBAL VARIABLES

Line 7: g_api VARCHAR2(40) := 'gcs.plsql.GCS_DIMENSION_SET_LINES_PKG';

3:
4: --
5: -- PRIVATE GLOBAL VARIABLES
6: --
7: g_api VARCHAR2(40) := 'gcs.plsql.GCS_DIMENSION_SET_LINES_PKG';
8:
9: --
10: -- PUBLIC FUNCTIONS
11: --

Line 121: DELETE FROM GCS_DIMENSION_SET_LINES

117: || to_char(l_num_of_dimensions) || ' dimension(s)');
118: END IF;
119:
120: -- Delete existing assignments
121: DELETE FROM GCS_DIMENSION_SET_LINES
122: WHERE dimension_set_id = p_dimension_set_id;
123:
124: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
125: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 137: 'INSERT INTO GCS_DIMENSION_SET_LINES

133: END IF;
134:
135: -- build the insert statement
136: stmt :=
137: 'INSERT INTO GCS_DIMENSION_SET_LINES
138: (dimension_set_id,' ||
139: insert_clause || '
140: creation_date, created_by,
141: last_update_date, last_updated_by,

Line 203: END GCS_DIMENSION_SET_LINES_PKG;

199: p_errbuf := 'GCS_DMSL_UNHANDLED_EXCEPTION';
200: p_retcode := '2';
201: END Assign_Dimension_Combinations;
202:
203: END GCS_DIMENSION_SET_LINES_PKG;