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.QP_UTIL dependencies on FND_VSET

Line 1509: v_vset fnd_vset.valueset_r;

1505: -- =======================================================================
1506:
1507:
1508: FUNCTION value_exists(p_vsid IN NUMBER,p_value IN VARCHAR2) RETURN BOOLEAN IS
1509: v_vset fnd_vset.valueset_r;
1510: v_fmt fnd_vset.valueset_dr;
1511: v_found BOOLEAN;
1512: v_row NUMBER;
1513: v_value fnd_vset.value_dr;

Line 1510: v_fmt fnd_vset.valueset_dr;

1506:
1507:
1508: FUNCTION value_exists(p_vsid IN NUMBER,p_value IN VARCHAR2) RETURN BOOLEAN IS
1509: v_vset fnd_vset.valueset_r;
1510: v_fmt fnd_vset.valueset_dr;
1511: v_found BOOLEAN;
1512: v_row NUMBER;
1513: v_value fnd_vset.value_dr;
1514: BEGIN

Line 1513: v_value fnd_vset.value_dr;

1509: v_vset fnd_vset.valueset_r;
1510: v_fmt fnd_vset.valueset_dr;
1511: v_found BOOLEAN;
1512: v_row NUMBER;
1513: v_value fnd_vset.value_dr;
1514: BEGIN
1515: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);
1516: fnd_vset.get_value_init(v_vset, TRUE);
1517: fnd_vset.get_value(v_vset, v_row, v_found, v_value);

Line 1515: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);

1511: v_found BOOLEAN;
1512: v_row NUMBER;
1513: v_value fnd_vset.value_dr;
1514: BEGIN
1515: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);
1516: fnd_vset.get_value_init(v_vset, TRUE);
1517: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
1518:
1519: WHILE(v_found) LOOP

Line 1516: fnd_vset.get_value_init(v_vset, TRUE);

1512: v_row NUMBER;
1513: v_value fnd_vset.value_dr;
1514: BEGIN
1515: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);
1516: fnd_vset.get_value_init(v_vset, TRUE);
1517: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
1518:
1519: WHILE(v_found) LOOP
1520: IF (v_value.value = p_value) THEN

Line 1517: fnd_vset.get_value(v_vset, v_row, v_found, v_value);

1513: v_value fnd_vset.value_dr;
1514: BEGIN
1515: fnd_vset.get_valueset(p_vsid, v_vset, v_fmt);
1516: fnd_vset.get_value_init(v_vset, TRUE);
1517: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
1518:
1519: WHILE(v_found) LOOP
1520: IF (v_value.value = p_value) THEN
1521: fnd_vset.get_value_end(v_vset);

Line 1521: fnd_vset.get_value_end(v_vset);

1517: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
1518:
1519: WHILE(v_found) LOOP
1520: IF (v_value.value = p_value) THEN
1521: fnd_vset.get_value_end(v_vset);
1522: RETURN TRUE;
1523: END IF;
1524: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
1525: END LOOP;

Line 1524: fnd_vset.get_value(v_vset, v_row, v_found, v_value);

1520: IF (v_value.value = p_value) THEN
1521: fnd_vset.get_value_end(v_vset);
1522: RETURN TRUE;
1523: END IF;
1524: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
1525: END LOOP;
1526: fnd_vset.get_value_end(v_vset);
1527: RETURN FALSE;
1528: END value_exists;

Line 1526: fnd_vset.get_value_end(v_vset);

1522: RETURN TRUE;
1523: END IF;
1524: fnd_vset.get_value(v_vset, v_row, v_found, v_value);
1525: END LOOP;
1526: fnd_vset.get_value_end(v_vset);
1527: RETURN FALSE;
1528: END value_exists;
1529:
1530: -- ==========================================================================

Line 1541: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,

1537: -- the list populated by get_valueset call.
1538: -- ===========================================================================
1539:
1540:
1541: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,
1542: p_value VARCHAR2,
1543: x_id OUT NOCOPY VARCHAR2,
1544: x_value OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
1545: v_selectstmt VARCHAR2(2000) ; --dhgupta changed length from 500 to 2000 for bug # 1888160

Line 1807: v_valueset_r fnd_vset.valueset_r;

1803: v_context_r fnd_dflex.context_r;
1804: v_segments_dr fnd_dflex.segments_dr;
1805: v_value_set_id NUMBER;
1806: v_precedence NUMBER;
1807: v_valueset_r fnd_vset.valueset_r;
1808: v_format_dr fnd_vset.valueset_dr;
1809: v_valueset_dr fnd_vset.valueset_dr;
1810: v_dflex_dr fnd_dflex.dflex_dr;
1811: v_flexfield_val_ind NUMBER DEFAULT 0;

Line 1808: v_format_dr fnd_vset.valueset_dr;

1804: v_segments_dr fnd_dflex.segments_dr;
1805: v_value_set_id NUMBER;
1806: v_precedence NUMBER;
1807: v_valueset_r fnd_vset.valueset_r;
1808: v_format_dr fnd_vset.valueset_dr;
1809: v_valueset_dr fnd_vset.valueset_dr;
1810: v_dflex_dr fnd_dflex.dflex_dr;
1811: v_flexfield_val_ind NUMBER DEFAULT 0;
1812: l_value VARCHAR2(150);

Line 1809: v_valueset_dr fnd_vset.valueset_dr;

1805: v_value_set_id NUMBER;
1806: v_precedence NUMBER;
1807: v_valueset_r fnd_vset.valueset_r;
1808: v_format_dr fnd_vset.valueset_dr;
1809: v_valueset_dr fnd_vset.valueset_dr;
1810: v_dflex_dr fnd_dflex.dflex_dr;
1811: v_flexfield_val_ind NUMBER DEFAULT 0;
1812: l_value VARCHAR2(150);
1813: l_id VARCHAR2(150);

Line 1972: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);

1968: RETURN;
1969: END IF;
1970:
1971: -- Get value set information and validate the value passed.
1972: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);
1973:
1974: datatype := v_valueset_dr.format_type;
1975:
1976: -- check if there is any value set attached to the segment

Line 2263: test_rec fnd_vset.valueset_r;

2259: IS
2260:
2261: flexfield fnd_dflex.dflex_r;
2262: flexinfo fnd_dflex.dflex_dr;
2263: test_rec fnd_vset.valueset_r;
2264: x_valuesetid NUMBER := null;
2265: test_frec fnd_vset.valueset_dr;
2266: contexts fnd_dflex.contexts_dr;
2267: i BINARY_INTEGER;

Line 2265: test_frec fnd_vset.valueset_dr;

2261: flexfield fnd_dflex.dflex_r;
2262: flexinfo fnd_dflex.dflex_dr;
2263: test_rec fnd_vset.valueset_r;
2264: x_valuesetid NUMBER := null;
2265: test_frec fnd_vset.valueset_dr;
2266: contexts fnd_dflex.contexts_dr;
2267: i BINARY_INTEGER;
2268: j BINARY_INTEGER;
2269: segments fnd_dflex.segments_dr;

Line 2316: fnd_vset.get_valueset(x_valuesetid,test_rec,test_frec);

2312:
2313: END IF; --if Attrmgr_Installed = 'Y'
2314:
2315: IF x_valuesetid IS NOT NULL THEN
2316: fnd_vset.get_valueset(x_valuesetid,test_rec,test_frec);
2317: x_vsid :=x_valuesetid;
2318: x_format_type :=test_frec.format_type;
2319: x_validation_type :=test_rec.validation_type;
2320: ELSE

Line 3122: v_valueset_r fnd_vset.valueset_r;

3118: v_context_r fnd_dflex.context_r;
3119: v_segments_dr fnd_dflex.segments_dr;
3120: v_value_set_id NUMBER;
3121: v_precedence NUMBER;
3122: v_valueset_r fnd_vset.valueset_r;
3123: v_format_dr fnd_vset.valueset_dr;
3124: v_valueset_dr fnd_vset.valueset_dr;
3125: v_dflex_dr fnd_dflex.dflex_dr;
3126: v_flexfield_val_ind NUMBER DEFAULT 0;

Line 3123: v_format_dr fnd_vset.valueset_dr;

3119: v_segments_dr fnd_dflex.segments_dr;
3120: v_value_set_id NUMBER;
3121: v_precedence NUMBER;
3122: v_valueset_r fnd_vset.valueset_r;
3123: v_format_dr fnd_vset.valueset_dr;
3124: v_valueset_dr fnd_vset.valueset_dr;
3125: v_dflex_dr fnd_dflex.dflex_dr;
3126: v_flexfield_val_ind NUMBER DEFAULT 0;
3127: J NUMBER := 0;

Line 3124: v_valueset_dr fnd_vset.valueset_dr;

3120: v_value_set_id NUMBER;
3121: v_precedence NUMBER;
3122: v_valueset_r fnd_vset.valueset_r;
3123: v_format_dr fnd_vset.valueset_dr;
3124: v_valueset_dr fnd_vset.valueset_dr;
3125: v_dflex_dr fnd_dflex.dflex_dr;
3126: v_flexfield_val_ind NUMBER DEFAULT 0;
3127: J NUMBER := 0;
3128:

Line 3188: fnd_vset.get_valueset(v_segments_dr.value_set(K),v_valueset_r,v_valueset_dr);

3184: x_segs_upg_t(J).datatype := 'C';
3185:
3186: ELSE
3187:
3188: fnd_vset.get_valueset(v_segments_dr.value_set(K),v_valueset_r,v_valueset_dr);
3189: x_segs_upg_t(J).datatype := v_valueset_dr.format_type;
3190:
3191: END IF;
3192:

Line 3288: L_Valueset_R FND_VSET.VALUESET_R;

3284: X_FORMAT_TYPE OUT NOCOPY VARCHAR2,
3285: X_VALIDATION_TYPE OUT NOCOPY VARCHAR2
3286: )IS
3287:
3288: L_Valueset_R FND_VSET.VALUESET_R;
3289: X_VALUESETID NUMBER;
3290: L_valueset_dr FND_VSET.VALUESET_DR;
3291:
3292: CURSOR Cur_get_application_id(app_short_name VARCHAR2) IS

Line 3290: L_valueset_dr FND_VSET.VALUESET_DR;

3286: )IS
3287:
3288: L_Valueset_R FND_VSET.VALUESET_R;
3289: X_VALUESETID NUMBER;
3290: L_valueset_dr FND_VSET.VALUESET_DR;
3291:
3292: CURSOR Cur_get_application_id(app_short_name VARCHAR2) IS
3293: SELECT application_id
3294: FROM fnd_application

Line 3320: FND_VSET.GET_VALUESET(X_VALUESETID,l_valueset_r,l_valueset_dr);

3316: END IF;
3317: END LOOP;
3318:
3319: IF X_VALUESETID IS NOT NULL THEN
3320: FND_VSET.GET_VALUESET(X_VALUESETID,l_valueset_r,l_valueset_dr);
3321: X_VSID :=X_VALUESETID;
3322: X_FORMAT_TYPE :=l_valueset_dr.FORMAT_TYPE;
3323: X_VALIDATION_TYPE :=l_valueset_r.VALIDATION_TYPE;
3324: ELSE

Line 3339: Vset FND_VSET.valueset_r;

3335: ,p_attr_value IN VARCHAR2
3336: ,p_comparison_operator_code IN VARCHAR2 := NULL
3337: ) RETURN VARCHAR2 IS
3338:
3339: Vset FND_VSET.valueset_r;
3340: Fmt FND_VSET.valueset_dr;
3341:
3342: Found BOOLEAN;
3343: Row NUMBER;

Line 3340: Fmt FND_VSET.valueset_dr;

3336: ,p_comparison_operator_code IN VARCHAR2 := NULL
3337: ) RETURN VARCHAR2 IS
3338:
3339: Vset FND_VSET.valueset_r;
3340: Fmt FND_VSET.valueset_dr;
3341:
3342: Found BOOLEAN;
3343: Row NUMBER;
3344: Value FND_VSET.value_dr;

Line 3344: Value FND_VSET.value_dr;

3340: Fmt FND_VSET.valueset_dr;
3341:
3342: Found BOOLEAN;
3343: Row NUMBER;
3344: Value FND_VSET.value_dr;
3345:
3346:
3347:
3348: x_Format_Type Varchar2(1);

Line 3389: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

3385:
3386: IF x_Validation_Type = 'I' THEN
3387: --dbms_output.put_line('validation type = I');
3388:
3389: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3390: FND_VSET.get_value_init(Vset,TRUE);
3391: FND_VSET.get_value(Vset,Row,Found,Value);
3392:
3393:

Line 3390: FND_VSET.get_value_init(Vset,TRUE);

3386: IF x_Validation_Type = 'I' THEN
3387: --dbms_output.put_line('validation type = I');
3388:
3389: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3390: FND_VSET.get_value_init(Vset,TRUE);
3391: FND_VSET.get_value(Vset,Row,Found,Value);
3392:
3393:
3394: IF Fmt.Has_Id Then --id is defined.Hence compare for id

Line 3391: FND_VSET.get_value(Vset,Row,Found,Value);

3387: --dbms_output.put_line('validation type = I');
3388:
3389: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3390: FND_VSET.get_value_init(Vset,TRUE);
3391: FND_VSET.get_value(Vset,Row,Found,Value);
3392:
3393:
3394: IF Fmt.Has_Id Then --id is defined.Hence compare for id
3395: While(Found) Loop

Line 3408: FND_VSET.get_value(Vset,Row,Found,Value);

3404: --dbms_output.put_line('1 x_attr_meaning = ' || x_attr_meaning);
3405: Value_Valid_In_Valueset := TRUE;
3406: EXIT;
3407: End If;
3408: FND_VSET.get_value(Vset,Row,Found,Value);
3409:
3410: End Loop;
3411:
3412: Else -- id not defined.Hence compare for value

Line 3426: FND_VSET.get_value(Vset,Row,Found,Value);

3422: --dbms_output.put_line('2 x_attr_meaning = ' || x_attr_meaning);
3423: Value_Valid_In_Valueset := TRUE;
3424: EXIT;
3425: End If;
3426: FND_VSET.get_value(Vset,Row,Found,Value);
3427:
3428: End Loop;
3429:
3430: End If; ---end of Fmt.Has_Id

Line 3432: FND_VSET.get_value_end(Vset);

3428: End Loop;
3429:
3430: End If; ---end of Fmt.Has_Id
3431:
3432: FND_VSET.get_value_end(Vset);
3433:
3434: ELSIF X_Validation_type = 'F' THEN
3435: --dbms_output.put_line('validation type = F');
3436:

Line 3437: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

3433:
3434: ELSIF X_Validation_type = 'F' THEN
3435: --dbms_output.put_line('validation type = F');
3436:
3437: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3438:
3439: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value,l_meaning)) THEN
3440:
3441:

Line 3501: Vset FND_VSET.valueset_r;

3497: ,p_attr_value IN VARCHAR2
3498: ,p_comparison_operator_code IN VARCHAR2 := NULL
3499: ) RETURN VARCHAR2 IS
3500:
3501: Vset FND_VSET.valueset_r;
3502: Fmt FND_VSET.valueset_dr;
3503:
3504: Found BOOLEAN;
3505: Row NUMBER;

Line 3502: Fmt FND_VSET.valueset_dr;

3498: ,p_comparison_operator_code IN VARCHAR2 := NULL
3499: ) RETURN VARCHAR2 IS
3500:
3501: Vset FND_VSET.valueset_r;
3502: Fmt FND_VSET.valueset_dr;
3503:
3504: Found BOOLEAN;
3505: Row NUMBER;
3506: Value FND_VSET.value_dr;

Line 3506: Value FND_VSET.value_dr;

3502: Fmt FND_VSET.valueset_dr;
3503:
3504: Found BOOLEAN;
3505: Row NUMBER;
3506: Value FND_VSET.value_dr;
3507:
3508:
3509:
3510: x_Format_Type Varchar2(1);

Line 3557: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

3553:
3554:
3555: IF x_Validation_Type = 'I' THEN
3556:
3557: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3558: FND_VSET.get_value_init(Vset,TRUE);
3559: FND_VSET.get_value(Vset,Row,Found,Value);
3560:
3561:

Line 3558: FND_VSET.get_value_init(Vset,TRUE);

3554:
3555: IF x_Validation_Type = 'I' THEN
3556:
3557: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3558: FND_VSET.get_value_init(Vset,TRUE);
3559: FND_VSET.get_value(Vset,Row,Found,Value);
3560:
3561:
3562: IF Fmt.Has_Id Then --id is defined.Hence compare for id

Line 3559: FND_VSET.get_value(Vset,Row,Found,Value);

3555: IF x_Validation_Type = 'I' THEN
3556:
3557: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3558: FND_VSET.get_value_init(Vset,TRUE);
3559: FND_VSET.get_value(Vset,Row,Found,Value);
3560:
3561:
3562: IF Fmt.Has_Id Then --id is defined.Hence compare for id
3563: While(Found) Loop

Line 3572: FND_VSET.get_value(Vset,Row,Found,Value);

3568: x_attr_value_code := Value.value;
3569: Value_Valid_In_Valueset := TRUE;
3570: EXIT;
3571: End If;
3572: FND_VSET.get_value(Vset,Row,Found,Value);
3573:
3574: End Loop;
3575:
3576: Else -- id not defined.Hence compare for value

Line 3586: FND_VSET.get_value(Vset,Row,Found,Value);

3582: x_attr_value_code := l_attr_value;
3583: Value_Valid_In_Valueset := TRUE;
3584: EXIT;
3585: End If;
3586: FND_VSET.get_value(Vset,Row,Found,Value);
3587:
3588: End Loop;
3589:
3590: End If; ---end of Fmt.Has_Id

Line 3592: FND_VSET.get_value_end(Vset);

3588: End Loop;
3589:
3590: End If; ---end of Fmt.Has_Id
3591:
3592: FND_VSET.get_value_end(Vset);
3593:
3594: ELSIF X_Validation_type = 'F' THEN
3595:
3596: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

Line 3596: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

3592: FND_VSET.get_value_end(Vset);
3593:
3594: ELSIF X_Validation_type = 'F' THEN
3595:
3596: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3597:
3598: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
3599:
3600:

Line 3707: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,

3703: -- the list populated by get_valueset call.
3704: -- ===========================================================================
3705:
3706:
3707: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,
3708: p_value VARCHAR2,
3709: x_id OUT NOCOPY VARCHAR2,
3710: x_value OUT NOCOPY VARCHAR2,
3711: x_meaning OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS