eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_COA_SEG_VAL_IMP_PKG dependencies on FND_FLEX_VALUES

Line 18: g_n_user_id fnd_flex_values.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id

14: Change History (in reverse chronological order)
15: Who When What
16: ********************************************************************************************** */
17:
18: g_n_user_id fnd_flex_values.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
19: g_n_login_id fnd_flex_values.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
20: g_n_sysdate DATE := SYSDATE;
21:
22: --PL/SQL table to store the unique flex value set ids.

Line 19: g_n_login_id fnd_flex_values.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id

15: Who When What
16: ********************************************************************************************** */
17:
18: g_n_user_id fnd_flex_values.created_by%TYPE := NVL(fnd_global.user_id,-1); -- Stores the User Id
19: g_n_login_id fnd_flex_values.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
20: g_n_sysdate DATE := SYSDATE;
21:
22: --PL/SQL table to store the unique flex value set ids.
23: TYPE flex_vl_set_id_tbl_type IS TABLE OF fnd_flex_values.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER;

Line 23: TYPE flex_vl_set_id_tbl_type IS TABLE OF fnd_flex_values.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER;

19: g_n_login_id fnd_flex_values.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
20: g_n_sysdate DATE := SYSDATE;
21:
22: --PL/SQL table to store the unique flex value set ids.
23: TYPE flex_vl_set_id_tbl_type IS TABLE OF fnd_flex_values.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER;
24: flex_vl_set_id_tab flex_vl_set_id_tbl_type;
25:
26: --Cursor to verify that the Value set name passed is valid.
27: CURSOR c_fnd_flex_values ( cp_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE) IS

Line 27: CURSOR c_fnd_flex_values ( cp_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE) IS

23: TYPE flex_vl_set_id_tbl_type IS TABLE OF fnd_flex_values.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER;
24: flex_vl_set_id_tab flex_vl_set_id_tbl_type;
25:
26: --Cursor to verify that the Value set name passed is valid.
27: CURSOR c_fnd_flex_values ( cp_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE) IS
28: SELECT ffvs.rowid,ffvs.*
29: FROM FND_FLEX_VALUE_SETS ffvs
30: WHERE FLEX_VALUE_SET_NAME = cp_flex_value_set_name;
31:

Line 32: l_cur_co c_fnd_flex_values%ROWTYPE;

28: SELECT ffvs.rowid,ffvs.*
29: FROM FND_FLEX_VALUE_SETS ffvs
30: WHERE FLEX_VALUE_SET_NAME = cp_flex_value_set_name;
31:
32: l_cur_co c_fnd_flex_values%ROWTYPE;
33:
34: FUNCTION isexists(p_flex_value_set_id IN fnd_flex_values.flex_value_set_id%TYPE,
35: p_tab_flex_value_set_id IN flex_vl_set_id_tbl_type) RETURN BOOLEAN AS
36: /***********************************************************************************************

Line 34: FUNCTION isexists(p_flex_value_set_id IN fnd_flex_values.flex_value_set_id%TYPE,

30: WHERE FLEX_VALUE_SET_NAME = cp_flex_value_set_name;
31:
32: l_cur_co c_fnd_flex_values%ROWTYPE;
33:
34: FUNCTION isexists(p_flex_value_set_id IN fnd_flex_values.flex_value_set_id%TYPE,
35: p_tab_flex_value_set_id IN flex_vl_set_id_tbl_type) RETURN BOOLEAN AS
36: /***********************************************************************************************
37: Created By : sommukhe
38: Date Created By: 01-AUG-2008.

Line 83: --Create process for fnd_flex_values

79: FND_MSG_PUB.ADD;
80:
81: END set_msg;
82:
83: --Create process for fnd_flex_values
84: PROCEDURE create_gl_coa_flex_values(
85: p_gl_flex_values_tbl IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_tbl_type,
86: p_c_rec_status OUT NOCOPY VARCHAR2,
87: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL /* DRM: Added */

Line 98: SOMMUKHE 28-JAN-2009 Bug#8208641 Included manual updates to fnd_flex_values as suugested by ATG in 7668121/7528069

94:
95: Known limitations,enhancements,remarks:
96: Change History (in reverse chronological order)
97: Who When What
98: SOMMUKHE 28-JAN-2009 Bug#8208641 Included manual updates to fnd_flex_values as suugested by ATG in 7668121/7528069
99: SOMMUKHE 10-Nov-2011 Bug#13249707 Included checks to avoid nullifying of the DFF data during update operation.
100: ********************************************************************************************** */
101: l_insert_update VARCHAR2(1);
102: v_message_name VARCHAR2(30);

Line 109: CURSOR c_fnd_flex_val ( cp_flex_value_set_id fnd_flex_values.flex_value_set_id%TYPE,

105: result BOOLEAN;
106: row_count NUMBER;
107: vsid NUMBER;
108: --cursor to fetch the existing data
109: CURSOR c_fnd_flex_val ( cp_flex_value_set_id fnd_flex_values.flex_value_set_id%TYPE,
110: cp_flex_value fnd_flex_values.flex_value%TYPE) IS
111: SELECT ffvs.rowid,ffvs.*
112: FROM fnd_flex_values ffvs
113: WHERE flex_value_set_id = cp_flex_value_set_id

Line 110: cp_flex_value fnd_flex_values.flex_value%TYPE) IS

106: row_count NUMBER;
107: vsid NUMBER;
108: --cursor to fetch the existing data
109: CURSOR c_fnd_flex_val ( cp_flex_value_set_id fnd_flex_values.flex_value_set_id%TYPE,
110: cp_flex_value fnd_flex_values.flex_value%TYPE) IS
111: SELECT ffvs.rowid,ffvs.*
112: FROM fnd_flex_values ffvs
113: WHERE flex_value_set_id = cp_flex_value_set_id
114: AND flex_value = cp_flex_value;

Line 112: FROM fnd_flex_values ffvs

108: --cursor to fetch the existing data
109: CURSOR c_fnd_flex_val ( cp_flex_value_set_id fnd_flex_values.flex_value_set_id%TYPE,
110: cp_flex_value fnd_flex_values.flex_value%TYPE) IS
111: SELECT ffvs.rowid,ffvs.*
112: FROM fnd_flex_values ffvs
113: WHERE flex_value_set_id = cp_flex_value_set_id
114: AND flex_value = cp_flex_value;
115:
116: rec_fnd_flex_val c_fnd_flex_val%ROWTYPE;

Line 143: OPEN c_fnd_flex_values(gl_coa_flex_values_rec.value_set_name);

139:
140: --Check the validity of the Value set name and derive the Flex_value_set_id
141: PROCEDURE validate_derivations ( gl_coa_flex_values_rec IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_rec_type ) AS
142: BEGIN
143: OPEN c_fnd_flex_values(gl_coa_flex_values_rec.value_set_name);
144: FETCH c_fnd_flex_values INTO l_cur_co;
145: IF c_fnd_flex_values%NOTFOUND THEN
146: CLOSE c_fnd_flex_values;
147: set_msg('GL_COA_SVI_INV_VSET', gl_coa_flex_values_rec.value_set_name);

Line 144: FETCH c_fnd_flex_values INTO l_cur_co;

140: --Check the validity of the Value set name and derive the Flex_value_set_id
141: PROCEDURE validate_derivations ( gl_coa_flex_values_rec IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_rec_type ) AS
142: BEGIN
143: OPEN c_fnd_flex_values(gl_coa_flex_values_rec.value_set_name);
144: FETCH c_fnd_flex_values INTO l_cur_co;
145: IF c_fnd_flex_values%NOTFOUND THEN
146: CLOSE c_fnd_flex_values;
147: set_msg('GL_COA_SVI_INV_VSET', gl_coa_flex_values_rec.value_set_name);
148: gl_coa_flex_values_rec.status := 'E';

Line 145: IF c_fnd_flex_values%NOTFOUND THEN

141: PROCEDURE validate_derivations ( gl_coa_flex_values_rec IN OUT NOCOPY gl_coa_seg_val_imp_pub.gl_flex_values_rec_type ) AS
142: BEGIN
143: OPEN c_fnd_flex_values(gl_coa_flex_values_rec.value_set_name);
144: FETCH c_fnd_flex_values INTO l_cur_co;
145: IF c_fnd_flex_values%NOTFOUND THEN
146: CLOSE c_fnd_flex_values;
147: set_msg('GL_COA_SVI_INV_VSET', gl_coa_flex_values_rec.value_set_name);
148: gl_coa_flex_values_rec.status := 'E';
149: ELSE

Line 146: CLOSE c_fnd_flex_values;

142: BEGIN
143: OPEN c_fnd_flex_values(gl_coa_flex_values_rec.value_set_name);
144: FETCH c_fnd_flex_values INTO l_cur_co;
145: IF c_fnd_flex_values%NOTFOUND THEN
146: CLOSE c_fnd_flex_values;
147: set_msg('GL_COA_SVI_INV_VSET', gl_coa_flex_values_rec.value_set_name);
148: gl_coa_flex_values_rec.status := 'E';
149: ELSE
150: CLOSE c_fnd_flex_values;

Line 150: CLOSE c_fnd_flex_values;

146: CLOSE c_fnd_flex_values;
147: set_msg('GL_COA_SVI_INV_VSET', gl_coa_flex_values_rec.value_set_name);
148: gl_coa_flex_values_rec.status := 'E';
149: ELSE
150: CLOSE c_fnd_flex_values;
151: END IF;
152:
153: END validate_derivations;
154:

Line 188: CLOSE c_fnd_flex_values;

184: RETURN 'U';
185: END IF;
186: EXCEPTION
187: WHEN E_RESOURCE_BUSY THEN
188: CLOSE c_fnd_flex_values;
189: fnd_message.set_name( 'GL', 'GL_COA_SVI_REC_LOCK');
190: fnd_msg_pub.add;
191: gl_coa_flex_values_rec.status := 'E';
192:

Line 287: IF c_fnd_flex_values%NOTFOUND THEN

283:
284: IF gl_coa_flex_values_rec.roll_up_group IS NOT NULL THEN
285: OPEN c_roll_up_group(l_cur_co.flex_value_set_id,gl_coa_flex_values_rec.roll_up_group);
286: FETCH c_roll_up_group INTO rec_roll_up_group;
287: IF c_fnd_flex_values%NOTFOUND THEN
288: CLOSE c_roll_up_group;
289: set_msg('GL_COA_SVI_INVALID_VALUE', 'ROLL_UP_GROUP');
290: gl_coa_flex_values_rec.status := 'E';
291: ELSE

Line 374: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.start_logging_for','Fnd Flex Values');

370: BEGIN
371:
372: v_compiled_value_attribute_s := NULL;
373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
374: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.start_logging_for','Fnd Flex Values');
375: END IF;
376:
377: p_c_rec_status := 'S';
378: FOR I in 1..p_gl_flex_values_tbl.LAST LOOP

Line 578: UPDATE fnd_flex_values

574: p_description => p_gl_flex_values_tbl(I).flex_desc);
575: ---As suggested by the Flex team in the bug 7668121 going ahead with the direct update on the LUD
576: ---As approved by Flex Dev team in the bug 13345598
577: IF l_insert_update = 'U' THEN
578: UPDATE fnd_flex_values
579: SET last_update_date = sysdate,
580: last_updated_by = g_n_user_id,
581: last_update_login = g_n_login_id
582: WHERE rowid = rec_fnd_flex_val.rowid ;

Line 584: UPDATE fnd_flex_values

580: last_updated_by = g_n_user_id,
581: last_update_login = g_n_login_id
582: WHERE rowid = rec_fnd_flex_val.rowid ;
583: ELSE
584: UPDATE fnd_flex_values
585: SET last_update_date = sysdate ,
586: last_updated_by = g_n_user_id,
587: created_by = g_n_user_id,
588: creation_date = sysdate

Line 722: OPEN c_fnd_flex_values(gl_coa_flex_values_nh_rec.value_set_name);

718: rec_fnd_flex_value_nh_exists c_fnd_flex_value_nh_exists%ROWTYPE;
719:
720: BEGIN
721: --Validate the Value set name
722: OPEN c_fnd_flex_values(gl_coa_flex_values_nh_rec.value_set_name);
723: FETCH c_fnd_flex_values INTO l_cur_co;
724: IF c_fnd_flex_values%NOTFOUND THEN
725: CLOSE c_fnd_flex_values;
726: fnd_message.set_name('GL','GL_COA_SVI_INVALID_VALUE');

Line 723: FETCH c_fnd_flex_values INTO l_cur_co;

719:
720: BEGIN
721: --Validate the Value set name
722: OPEN c_fnd_flex_values(gl_coa_flex_values_nh_rec.value_set_name);
723: FETCH c_fnd_flex_values INTO l_cur_co;
724: IF c_fnd_flex_values%NOTFOUND THEN
725: CLOSE c_fnd_flex_values;
726: fnd_message.set_name('GL','GL_COA_SVI_INVALID_VALUE');
727: fnd_msg_pub.add;

Line 724: IF c_fnd_flex_values%NOTFOUND THEN

720: BEGIN
721: --Validate the Value set name
722: OPEN c_fnd_flex_values(gl_coa_flex_values_nh_rec.value_set_name);
723: FETCH c_fnd_flex_values INTO l_cur_co;
724: IF c_fnd_flex_values%NOTFOUND THEN
725: CLOSE c_fnd_flex_values;
726: fnd_message.set_name('GL','GL_COA_SVI_INVALID_VALUE');
727: fnd_msg_pub.add;
728: gl_coa_flex_values_nh_rec.status := 'E';

Line 725: CLOSE c_fnd_flex_values;

721: --Validate the Value set name
722: OPEN c_fnd_flex_values(gl_coa_flex_values_nh_rec.value_set_name);
723: FETCH c_fnd_flex_values INTO l_cur_co;
724: IF c_fnd_flex_values%NOTFOUND THEN
725: CLOSE c_fnd_flex_values;
726: fnd_message.set_name('GL','GL_COA_SVI_INVALID_VALUE');
727: fnd_msg_pub.add;
728: gl_coa_flex_values_nh_rec.status := 'E';
729: ELSE

Line 730: CLOSE c_fnd_flex_values;

726: fnd_message.set_name('GL','GL_COA_SVI_INVALID_VALUE');
727: fnd_msg_pub.add;
728: gl_coa_flex_values_nh_rec.status := 'E';
729: ELSE
730: CLOSE c_fnd_flex_values;
731: END IF;
732:
733: OPEN c_fnd_flex_value_nh_exists(l_cur_co.flex_value_set_id);/* DRM removed: ,gl_coa_flex_values_nh_rec.parent_flex_value);*/
734: FETCH c_fnd_flex_value_nh_exists INTO rec_fnd_flex_value_nh_exists;

Line 782: FROM fnd_flex_values

778: --Cursor to validate the parent flex value
779: CURSOR c_fnd_flex_value_exists(cp_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE,
780: cp_parent_flex_value fnd_flex_value_norm_hierarchy.parent_flex_value%TYPE ) IS
781: SELECT summary_flag
782: FROM fnd_flex_values
783: WHERE flex_value_set_id = cp_flex_value_set_id
784: AND flex_value = cp_parent_flex_value;
785:
786: rec_fnd_flex_value_exists c_fnd_flex_value_exists%ROWTYPE;