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.EGO_VS_BULKLOAD_PVT dependencies on FND_FLEX_VALUE_SETS

Line 238: FROM fnd_flex_value_sets

234: -- Cursor to get Value Set id
235: CURSOR cur_value_set_id( cp_value_set_name VARCHAR2)
236: IS
237: SELECT flex_value_set_id
238: FROM fnd_flex_value_sets
239: WHERE flex_value_set_name = cp_value_set_name;
240:
241:
242: -- Cursor to get Value id

Line 248: FROM fnd_flex_value_sets vs,

244: cp_flex_value VARCHAR2)
245: IS
246:
247: SELECT val.flex_value_id value_id
248: FROM fnd_flex_value_sets vs,
249: fnd_flex_values val
250: WHERE vs.flex_value_set_id = val.flex_value_set_id
251: AND vs.flex_value_set_id = cp_value_set_id
252: AND val.flex_value = cp_flex_value;

Line 319: FROM fnd_flex_value_sets

315: -- Cursor to get value_set_name for a passed in value set id
316: CURSOR cur_value_set_name(cp_value_set_id NUMBER)
317: IS
318: SELECT flex_value_set_name
319: FROM fnd_flex_value_sets
320: WHERE flex_value_set_id = cp_value_set_id;
321:
322:
323: -- Cursor to find out if value already exist in system.

Line 1413: FROM fnd_flex_value_sets ffvs

1409: )
1410: AND NOT EXISTS
1411: (
1412: SELECT 1
1413: FROM fnd_flex_value_sets ffvs
1414: WHERE ffvs.flex_value_set_name = efvsi.value_set_name
1415: )
1416: AND Upper(efvsi.transaction_type) =G_SYNC;
1417:

Line 1431: FROM fnd_flex_value_sets ffvs

1427: )
1428: AND EXISTS
1429: (
1430: SELECT 1
1431: FROM fnd_flex_value_sets ffvs
1432: WHERE ffvs.flex_value_set_name = efvsi.value_set_name
1433: )
1434: AND Upper(efvsi.transaction_type) =G_SYNC;
1435:

Line 1457: FROM fnd_flex_value_sets FVS,

1453: )
1454: AND NOT EXISTS --evsvi.flex_value NOT IN
1455: (
1456: SELECT flex_value
1457: FROM fnd_flex_value_sets FVS,
1458: fnd_flex_values FVSV
1459: --Ego_Flex_Value_Set_Intf EVS
1460: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1461: AND fvs.flex_value_set_name = evsvi.value_set_name

Line 1481: FROM fnd_flex_value_sets FVS,

1477: )
1478: AND EVSV.flex_value IN
1479: (
1480: SELECT FVSV.flex_value
1481: FROM fnd_flex_value_sets FVS,
1482: fnd_flex_values FVSV
1483: --Ego_Flex_Value_Set_Intf EVS
1484: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id
1485: AND fvs.flex_value_set_name = evsv.value_set_name

Line 1507: FROM fnd_flex_value_sets FVS,

1503: )
1504: AND flex_value NOT IN
1505: (
1506: SELECT fvsv.flex_value
1507: FROM fnd_flex_value_sets FVS,
1508: fnd_flex_values FVSV,
1509: fnd_flex_values_tl FVSTV,
1510: Ego_Flex_Value_Set_Intf EVS,
1511: Ego_Flex_Value_Intf EVSV

Line 1536: FROM fnd_flex_value_sets FVS,

1532: )
1533: AND EVSTV.flex_value IN
1534: (
1535: SELECT fvsv.flex_value
1536: FROM fnd_flex_value_sets FVS,
1537: fnd_flex_values FVSV,
1538: fnd_flex_values_tl FVSTV,
1539: Ego_Flex_Value_Set_Intf EVS
1540: WHERE fvs.flex_value_set_id= fvsv.flex_value_set_id

Line 2527: FROM fnd_flex_value_sets

2523:
2524: CURSOR cur_value
2525: IS
2526: SELECT validation_type, format_type, maximum_value,minimum_value,longlist_flag,maximum_size,description
2527: FROM fnd_flex_value_sets
2528: WHERE flex_value_set_id = p_value_set_id;
2529:
2530:
2531: CURSOR cur_value_set_name

Line 2534: FROM fnd_flex_value_sets

2530:
2531: CURSOR cur_value_set_name
2532: IS
2533: SELECT flex_value_set_name
2534: FROM fnd_flex_value_sets
2535: WHERE flex_value_set_id = p_value_set_id;
2536:
2537:
2538: BEGIN

Line 3951: FROM Fnd_Flex_Value_Sets ffvs

3947:
3948: UNION
3949:
3950: SELECT 1
3951: FROM Fnd_Flex_Value_Sets ffvs
3952: WHERE (ffvs.flex_value_set_name= evsvi.value_set_name
3953: OR ffvs.flex_value_set_id= evsvi.value_set_id
3954: )
3955: AND NOT EXISTS

Line 4035: Fnd_Flex_Value_Sets ffvs

4031: UNION
4032:
4033: SELECT 1
4034: FROM Ego_Flex_Value_Intf evsvi,
4035: Fnd_Flex_Value_Sets ffvs
4036: WHERE
4037: ( (p_set_process_id IS NULL
4038: OR evsvi.set_process_id = null
4039: )

Line 4317: FROM Fnd_Flex_Value_Sets ffvs

4313: )
4314:
4315: UNION
4316: SELECT 1
4317: FROM Fnd_Flex_Value_Sets ffvs
4318: WHERE
4319: ( ( ffvs.flex_value_set_name= evsvi.value_set_name
4320: OR ffvs.flex_value_set_id= evsvi.value_set_id
4321: )

Line 4508: FROM Fnd_Flex_Value_Sets ffvs

4504: )
4505: AND NOT EXISTS
4506: (
4507: SELECT 1
4508: FROM Fnd_Flex_Value_Sets ffvs
4509: WHERE (ffvs.flex_value_set_name= evsvi.value_set_name
4510: OR ffvs.flex_value_set_id= evsvi.value_set_id
4511: )
4512: AND NOT EXISTS

Line 4565: FROM Fnd_Flex_Value_Sets ffvs

4561: )
4562: AND NOT EXISTS
4563: (
4564: SELECT 1
4565: FROM Fnd_Flex_Value_Sets ffvs
4566: WHERE (ffvs.flex_value_set_name= evsvi.value_set_name
4567: OR ffvs.flex_value_set_id= evsvi.value_set_id
4568: )
4569: AND NOT EXISTS

Line 5618: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);

5614: --if we change required parameters, version goes from n.x to (n+1).x, if we change optional parameters, version goes from x.n to x.(n+1)
5615: l_api_version NUMBER := 1.0;
5616: l_owner NUMBER := G_USER_ID;
5617:
5618: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
5619: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
5620: l_description FND_FLEX_VALUE_SETS.description%TYPE;
5621: l_version_description VARCHAR2(2000);
5622:

Line 5619: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

5615: l_api_version NUMBER := 1.0;
5616: l_owner NUMBER := G_USER_ID;
5617:
5618: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
5619: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
5620: l_description FND_FLEX_VALUE_SETS.description%TYPE;
5621: l_version_description VARCHAR2(2000);
5622:
5623: l_longlist_flag VARCHAR2(1);

Line 5620: l_description FND_FLEX_VALUE_SETS.description%TYPE;

5616: l_owner NUMBER := G_USER_ID;
5617:
5618: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
5619: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
5620: l_description FND_FLEX_VALUE_SETS.description%TYPE;
5621: l_version_description VARCHAR2(2000);
5622:
5623: l_longlist_flag VARCHAR2(1);
5624: l_format_code VARCHAR2(1);

Line 5627: l_parent_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);

5623: l_longlist_flag VARCHAR2(1);
5624: l_format_code VARCHAR2(1);
5625: l_validation_code VARCHAR2(1);
5626:
5627: l_parent_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
5628: l_version_seq_id NUMBER(10,0);
5629: l_start_active_date DATE;
5630: l_end_active_date DATE;
5631:

Line 5632: l_maximum_size FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE; --NUMBER;

5628: l_version_seq_id NUMBER(10,0);
5629: l_start_active_date DATE;
5630: l_end_active_date DATE;
5631:
5632: l_maximum_size FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE; --NUMBER;
5633: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
5634: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
5635:
5636: l_transaction_type VARCHAR2(20);

Line 5633: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;

5629: l_start_active_date DATE;
5630: l_end_active_date DATE;
5631:
5632: l_maximum_size FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE; --NUMBER;
5633: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
5634: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
5635:
5636: l_transaction_type VARCHAR2(20);
5637: l_process_status NUMBER;

Line 5634: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;

5630: l_end_active_date DATE;
5631:
5632: l_maximum_size FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE; --NUMBER;
5633: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
5634: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
5635:
5636: l_transaction_type VARCHAR2(20);
5637: l_process_status NUMBER;
5638: l_request_id NUMBER;

Line 5697: FROM fnd_flex_value_sets

5693:
5694: -- Cursor to get value_set_id for a passed in value set name
5695: CURSOR cur_value_set_id(cp_value_set_name VARCHAR2) IS
5696: SELECT flex_value_set_id
5697: FROM fnd_flex_value_sets
5698: WHERE flex_value_set_name = cp_value_set_name;
5699:
5700:
5701:

Line 7124: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);

7120: l_api_version NUMBER := 1.0;
7121: l_owner NUMBER := G_User_Id;
7122: -- l_owner_name VARCHAR2(40):='ANONYMOUS';
7123:
7124: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
7125: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;
7126:
7127: l_flex_value fnd_flex_values.flex_value%TYPE;
7128: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;

Line 7185: --l_description FND_FLEX_VALUE_SETS.description%TYPE;

7181: l_trans_val_ver_exist NUMBER;
7182: l_seq_exist NUMBER := NULL;
7183: l_valid_type NUMBER := NULL;
7184: l_return_msg VARCHAR2(1000);
7185: --l_description FND_FLEX_VALUE_SETS.description%TYPE;
7186:
7187: l_vs_maximum_size NUMBER := NULL;
7188: l_val_int_name_size NUMBER := NULL;
7189: l_val_disp_name_size NUMBER := NULL;

Line 7198: FROM fnd_flex_value_sets

7194:
7195: -- Cursor to get value_set_id for a passed in value set name
7196: CURSOR cur_value_set_id(cp_value_set_name VARCHAR2) IS
7197: SELECT flex_value_set_id
7198: FROM fnd_flex_value_sets
7199: WHERE flex_value_set_name = cp_value_set_name;
7200:
7201: -- Cursor to find out if value already exist in system.
7202: CURSOR cur_value( cp_flex_value_set_id NUMBER,

Line 7223: FROM fnd_flex_value_sets

7219:
7220: CURSOR Cur_Validation (cp_value_set_id IN NUMBER )
7221: IS
7222: SELECT validation_type, format_type ,maximum_size
7223: FROM fnd_flex_value_sets
7224: WHERE flex_Value_set_id = cp_value_set_id;
7225:
7226: -- Cursor to get value_set_name for a passed in value set id
7227: CURSOR cur_value_set_name(cp_value_set_id NUMBER)

Line 7230: FROM fnd_flex_value_sets

7226: -- Cursor to get value_set_name for a passed in value set id
7227: CURSOR cur_value_set_name(cp_value_set_id NUMBER)
7228: IS
7229: SELECT flex_value_set_name
7230: FROM fnd_flex_value_sets
7231: WHERE flex_value_set_id = cp_value_set_id;
7232:
7233:
7234:

Line 9028: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);

9024: l_api_version NUMBER := 1.0;
9025: l_owner NUMBER := G_User_Id;
9026: -- l_owner_name VARCHAR2(40):='ANONYMOUS';
9027:
9028: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
9029: l_value_set_id FND_FLEX_VALUES.FLEX_VALUE_SET_ID%TYPE;
9030:
9031: l_flex_value fnd_flex_values.flex_value%TYPE;
9032: l_flex_value_id fnd_flex_values.flex_value_id%TYPE;

Line 9107: FROM fnd_flex_value_sets fvs

9103: --
9104: CURSOR Cur_Validation (cp_value_set_id IN NUMBER )
9105: IS
9106: SELECT validation_type, format_type,maximum_size
9107: FROM fnd_flex_value_sets fvs
9108: WHERE fvs.flex_Value_set_id = cp_value_set_id; -- bug 12394675
9109:
9110:
9111: -- Cursor to get display sequence.

Line 10566: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);

10562: l_api_version NUMBER := 1.0;
10563: l_owner NUMBER := G_User_Id;
10564: -- l_owner_name VARCHAR2(40):='ANONYMOUS';
10565:
10566: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
10567: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
10568: l_description FND_FLEX_VALUE_SETS.description%TYPE;
10569:
10570: l_longlist_flag VARCHAR2(1);

Line 10567: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;

10563: l_owner NUMBER := G_User_Id;
10564: -- l_owner_name VARCHAR2(40):='ANONYMOUS';
10565:
10566: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
10567: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
10568: l_description FND_FLEX_VALUE_SETS.description%TYPE;
10569:
10570: l_longlist_flag VARCHAR2(1);
10571: l_format_code VARCHAR2(1);

Line 10568: l_description FND_FLEX_VALUE_SETS.description%TYPE;

10564: -- l_owner_name VARCHAR2(40):='ANONYMOUS';
10565:
10566: l_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
10567: l_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
10568: l_description FND_FLEX_VALUE_SETS.description%TYPE;
10569:
10570: l_longlist_flag VARCHAR2(1);
10571: l_format_code VARCHAR2(1);
10572: l_validation_code VARCHAR2(1);

Line 10574: l_parent_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);

10570: l_longlist_flag VARCHAR2(1);
10571: l_format_code VARCHAR2(1);
10572: l_validation_code VARCHAR2(1);
10573:
10574: l_parent_value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE; -- VARCHAR2(60);
10575: l_version_seq_id NUMBER(10,0);
10576: l_start_active_date DATE;
10577: l_end_active_date DATE;
10578:

Line 10579: l_maximum_size FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE; --NUMBER;

10575: l_version_seq_id NUMBER(10,0);
10576: l_start_active_date DATE;
10577: l_end_active_date DATE;
10578:
10579: l_maximum_size FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE; --NUMBER;
10580: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
10581: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
10582:
10583: l_transaction_type VARCHAR2(10);

Line 10580: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;

10576: l_start_active_date DATE;
10577: l_end_active_date DATE;
10578:
10579: l_maximum_size FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE; --NUMBER;
10580: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
10581: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
10582:
10583: l_transaction_type VARCHAR2(10);
10584: l_transaction_id NUMBER;

Line 10581: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;

10577: l_end_active_date DATE;
10578:
10579: l_maximum_size FND_FLEX_VALUE_SETS.MAXIMUM_SIZE%TYPE; --NUMBER;
10580: l_maximum_value FND_FLEX_VALUE_SETS.MAXIMUM_VALUE%TYPE;
10581: l_minimum_value FND_FLEX_VALUE_SETS.MINIMUM_VALUE%TYPE;
10582:
10583: l_transaction_type VARCHAR2(10);
10584: l_transaction_id NUMBER;
10585:

Line 10630: FROM fnd_flex_value_sets vs, fnd_flex_values val

10626: CURSOR cur_value_id(cp_value_set_name VARCHAR2,
10627: cp_flex_value VARCHAR2)
10628: IS
10629: SELECT flex_value_id
10630: FROM fnd_flex_value_sets vs, fnd_flex_values val
10631: WHERE vs.flex_value_set_id= val.flex_value_set_id
10632: AND vs.flex_value_set_name= cp_value_set_name
10633: AND flex_value=cp_flex_value;
10634:

Line 10638: FROM fnd_flex_value_sets

10634:
10635: -- Cursor to get value_set_id for a passed in value set name
10636: CURSOR cur_value_set_id(cp_value_set_name VARCHAR2) IS
10637: SELECT flex_value_set_id
10638: FROM fnd_flex_value_sets
10639: WHERE flex_value_set_name = cp_value_set_name;
10640:
10641:
10642:

Line 10655: FROM fnd_flex_value_sets

10651:
10652: -- Cursor to get parent vs validation code
10653: CURSOR cur_parent_vs_validation (cp_value_set_id NUMBER) IS
10654: SELECT validation_type
10655: FROM fnd_flex_value_sets
10656: WHERE flex_value_set_id = cp_value_set_id;
10657:
10658:
10659: