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 1820: v_valueset_r fnd_vset.valueset_r;

1816: v_context_r fnd_dflex.context_r;
1817: v_segments_dr fnd_dflex.segments_dr;
1818: v_value_set_id NUMBER;
1819: v_precedence NUMBER;
1820: v_valueset_r fnd_vset.valueset_r;
1821: v_format_dr fnd_vset.valueset_dr;
1822: v_valueset_dr fnd_vset.valueset_dr;
1823: v_dflex_dr fnd_dflex.dflex_dr;
1824: v_flexfield_val_ind NUMBER DEFAULT 0;

Line 1821: v_format_dr fnd_vset.valueset_dr;

1817: v_segments_dr fnd_dflex.segments_dr;
1818: v_value_set_id NUMBER;
1819: v_precedence NUMBER;
1820: v_valueset_r fnd_vset.valueset_r;
1821: v_format_dr fnd_vset.valueset_dr;
1822: v_valueset_dr fnd_vset.valueset_dr;
1823: v_dflex_dr fnd_dflex.dflex_dr;
1824: v_flexfield_val_ind NUMBER DEFAULT 0;
1825: l_value VARCHAR2(150);

Line 1822: v_valueset_dr fnd_vset.valueset_dr;

1818: v_value_set_id NUMBER;
1819: v_precedence NUMBER;
1820: v_valueset_r fnd_vset.valueset_r;
1821: v_format_dr fnd_vset.valueset_dr;
1822: v_valueset_dr fnd_vset.valueset_dr;
1823: v_dflex_dr fnd_dflex.dflex_dr;
1824: v_flexfield_val_ind NUMBER DEFAULT 0;
1825: l_value VARCHAR2(150);
1826: l_id VARCHAR2(150);

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

1981: RETURN;
1982: END IF;
1983:
1984: -- Get value set information and validate the value passed.
1985: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);
1986:
1987: datatype := v_valueset_dr.format_type;
1988:
1989: -- check if there is any value set attached to the segment

Line 2276: test_rec fnd_vset.valueset_r;

2272: IS
2273:
2274: flexfield fnd_dflex.dflex_r;
2275: flexinfo fnd_dflex.dflex_dr;
2276: test_rec fnd_vset.valueset_r;
2277: x_valuesetid NUMBER := null;
2278: test_frec fnd_vset.valueset_dr;
2279: contexts fnd_dflex.contexts_dr;
2280: i BINARY_INTEGER;

Line 2278: test_frec fnd_vset.valueset_dr;

2274: flexfield fnd_dflex.dflex_r;
2275: flexinfo fnd_dflex.dflex_dr;
2276: test_rec fnd_vset.valueset_r;
2277: x_valuesetid NUMBER := null;
2278: test_frec fnd_vset.valueset_dr;
2279: contexts fnd_dflex.contexts_dr;
2280: i BINARY_INTEGER;
2281: j BINARY_INTEGER;
2282: segments fnd_dflex.segments_dr;

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

2325:
2326: END IF; --if Attrmgr_Installed = 'Y'
2327:
2328: IF x_valuesetid IS NOT NULL THEN
2329: fnd_vset.get_valueset(x_valuesetid,test_rec,test_frec);
2330: x_vsid :=x_valuesetid;
2331: x_format_type :=test_frec.format_type;
2332: x_validation_type :=test_rec.validation_type;
2333: ELSE

Line 3135: v_valueset_r fnd_vset.valueset_r;

3131: v_context_r fnd_dflex.context_r;
3132: v_segments_dr fnd_dflex.segments_dr;
3133: v_value_set_id NUMBER;
3134: v_precedence NUMBER;
3135: v_valueset_r fnd_vset.valueset_r;
3136: v_format_dr fnd_vset.valueset_dr;
3137: v_valueset_dr fnd_vset.valueset_dr;
3138: v_dflex_dr fnd_dflex.dflex_dr;
3139: v_flexfield_val_ind NUMBER DEFAULT 0;

Line 3136: v_format_dr fnd_vset.valueset_dr;

3132: v_segments_dr fnd_dflex.segments_dr;
3133: v_value_set_id NUMBER;
3134: v_precedence NUMBER;
3135: v_valueset_r fnd_vset.valueset_r;
3136: v_format_dr fnd_vset.valueset_dr;
3137: v_valueset_dr fnd_vset.valueset_dr;
3138: v_dflex_dr fnd_dflex.dflex_dr;
3139: v_flexfield_val_ind NUMBER DEFAULT 0;
3140: J NUMBER := 0;

Line 3137: v_valueset_dr fnd_vset.valueset_dr;

3133: v_value_set_id NUMBER;
3134: v_precedence NUMBER;
3135: v_valueset_r fnd_vset.valueset_r;
3136: v_format_dr fnd_vset.valueset_dr;
3137: v_valueset_dr fnd_vset.valueset_dr;
3138: v_dflex_dr fnd_dflex.dflex_dr;
3139: v_flexfield_val_ind NUMBER DEFAULT 0;
3140: J NUMBER := 0;
3141:

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

3197: x_segs_upg_t(J).datatype := 'C';
3198:
3199: ELSE
3200:
3201: fnd_vset.get_valueset(v_segments_dr.value_set(K),v_valueset_r,v_valueset_dr);
3202: x_segs_upg_t(J).datatype := v_valueset_dr.format_type;
3203:
3204: END IF;
3205:

Line 3301: L_Valueset_R FND_VSET.VALUESET_R;

3297: X_FORMAT_TYPE OUT NOCOPY VARCHAR2,
3298: X_VALIDATION_TYPE OUT NOCOPY VARCHAR2
3299: )IS
3300:
3301: L_Valueset_R FND_VSET.VALUESET_R;
3302: X_VALUESETID NUMBER;
3303: L_valueset_dr FND_VSET.VALUESET_DR;
3304:
3305: CURSOR Cur_get_application_id(app_short_name VARCHAR2) IS

Line 3303: L_valueset_dr FND_VSET.VALUESET_DR;

3299: )IS
3300:
3301: L_Valueset_R FND_VSET.VALUESET_R;
3302: X_VALUESETID NUMBER;
3303: L_valueset_dr FND_VSET.VALUESET_DR;
3304:
3305: CURSOR Cur_get_application_id(app_short_name VARCHAR2) IS
3306: SELECT application_id
3307: FROM fnd_application

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

3329: END IF;
3330: END LOOP;
3331:
3332: IF X_VALUESETID IS NOT NULL THEN
3333: FND_VSET.GET_VALUESET(X_VALUESETID,l_valueset_r,l_valueset_dr);
3334: X_VSID :=X_VALUESETID;
3335: X_FORMAT_TYPE :=l_valueset_dr.FORMAT_TYPE;
3336: X_VALIDATION_TYPE :=l_valueset_r.VALIDATION_TYPE;
3337: ELSE

Line 3352: Vset FND_VSET.valueset_r;

3348: ,p_attr_value IN VARCHAR2
3349: ,p_comparison_operator_code IN VARCHAR2 := NULL
3350: ) RETURN VARCHAR2 IS
3351:
3352: Vset FND_VSET.valueset_r;
3353: Fmt FND_VSET.valueset_dr;
3354:
3355: Found BOOLEAN;
3356: Row NUMBER;

Line 3353: Fmt FND_VSET.valueset_dr;

3349: ,p_comparison_operator_code IN VARCHAR2 := NULL
3350: ) RETURN VARCHAR2 IS
3351:
3352: Vset FND_VSET.valueset_r;
3353: Fmt FND_VSET.valueset_dr;
3354:
3355: Found BOOLEAN;
3356: Row NUMBER;
3357: Value FND_VSET.value_dr;

Line 3357: Value FND_VSET.value_dr;

3353: Fmt FND_VSET.valueset_dr;
3354:
3355: Found BOOLEAN;
3356: Row NUMBER;
3357: Value FND_VSET.value_dr;
3358:
3359:
3360:
3361: x_Format_Type Varchar2(1);

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

3398:
3399: IF x_Validation_Type = 'I' THEN
3400: --dbms_output.put_line('validation type = I');
3401:
3402: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3403: FND_VSET.get_value_init(Vset,TRUE);
3404: FND_VSET.get_value(Vset,Row,Found,Value);
3405:
3406:

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

3399: IF x_Validation_Type = 'I' THEN
3400: --dbms_output.put_line('validation type = I');
3401:
3402: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3403: FND_VSET.get_value_init(Vset,TRUE);
3404: FND_VSET.get_value(Vset,Row,Found,Value);
3405:
3406:
3407: IF Fmt.Has_Id Then --id is defined.Hence compare for id

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

3400: --dbms_output.put_line('validation type = I');
3401:
3402: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3403: FND_VSET.get_value_init(Vset,TRUE);
3404: FND_VSET.get_value(Vset,Row,Found,Value);
3405:
3406:
3407: IF Fmt.Has_Id Then --id is defined.Hence compare for id
3408: While(Found) Loop

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

3417: --dbms_output.put_line('1 x_attr_meaning = ' || x_attr_meaning);
3418: Value_Valid_In_Valueset := TRUE;
3419: EXIT;
3420: End If;
3421: FND_VSET.get_value(Vset,Row,Found,Value);
3422:
3423: End Loop;
3424:
3425: Else -- id not defined.Hence compare for value

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

3435: --dbms_output.put_line('2 x_attr_meaning = ' || x_attr_meaning);
3436: Value_Valid_In_Valueset := TRUE;
3437: EXIT;
3438: End If;
3439: FND_VSET.get_value(Vset,Row,Found,Value);
3440:
3441: End Loop;
3442:
3443: End If; ---end of Fmt.Has_Id

Line 3445: FND_VSET.get_value_end(Vset);

3441: End Loop;
3442:
3443: End If; ---end of Fmt.Has_Id
3444:
3445: FND_VSET.get_value_end(Vset);
3446:
3447: ELSIF X_Validation_type = 'F' THEN
3448: --dbms_output.put_line('validation type = F');
3449:

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

3446:
3447: ELSIF X_Validation_type = 'F' THEN
3448: --dbms_output.put_line('validation type = F');
3449:
3450: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3451:
3452: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value,l_meaning)) THEN
3453:
3454:

Line 3514: Vset FND_VSET.valueset_r;

3510: ,p_attr_value IN VARCHAR2
3511: ,p_comparison_operator_code IN VARCHAR2 := NULL
3512: ) RETURN VARCHAR2 IS
3513:
3514: Vset FND_VSET.valueset_r;
3515: Fmt FND_VSET.valueset_dr;
3516:
3517: Found BOOLEAN;
3518: Row NUMBER;

Line 3515: Fmt FND_VSET.valueset_dr;

3511: ,p_comparison_operator_code IN VARCHAR2 := NULL
3512: ) RETURN VARCHAR2 IS
3513:
3514: Vset FND_VSET.valueset_r;
3515: Fmt FND_VSET.valueset_dr;
3516:
3517: Found BOOLEAN;
3518: Row NUMBER;
3519: Value FND_VSET.value_dr;

Line 3519: Value FND_VSET.value_dr;

3515: Fmt FND_VSET.valueset_dr;
3516:
3517: Found BOOLEAN;
3518: Row NUMBER;
3519: Value FND_VSET.value_dr;
3520:
3521:
3522:
3523: x_Format_Type Varchar2(1);

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

3566:
3567:
3568: IF x_Validation_Type = 'I' THEN
3569:
3570: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3571: FND_VSET.get_value_init(Vset,TRUE);
3572: FND_VSET.get_value(Vset,Row,Found,Value);
3573:
3574:

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

3567:
3568: IF x_Validation_Type = 'I' THEN
3569:
3570: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3571: FND_VSET.get_value_init(Vset,TRUE);
3572: FND_VSET.get_value(Vset,Row,Found,Value);
3573:
3574:
3575: IF Fmt.Has_Id Then --id is defined.Hence compare for id

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

3568: IF x_Validation_Type = 'I' THEN
3569:
3570: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3571: FND_VSET.get_value_init(Vset,TRUE);
3572: FND_VSET.get_value(Vset,Row,Found,Value);
3573:
3574:
3575: IF Fmt.Has_Id Then --id is defined.Hence compare for id
3576: While(Found) Loop

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

3581: x_attr_value_code := Value.value;
3582: Value_Valid_In_Valueset := TRUE;
3583: EXIT;
3584: End If;
3585: FND_VSET.get_value(Vset,Row,Found,Value);
3586:
3587: End Loop;
3588:
3589: Else -- id not defined.Hence compare for value

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

3595: x_attr_value_code := l_attr_value;
3596: Value_Valid_In_Valueset := TRUE;
3597: EXIT;
3598: End If;
3599: FND_VSET.get_value(Vset,Row,Found,Value);
3600:
3601: End Loop;
3602:
3603: End If; ---end of Fmt.Has_Id

Line 3605: FND_VSET.get_value_end(Vset);

3601: End Loop;
3602:
3603: End If; ---end of Fmt.Has_Id
3604:
3605: FND_VSET.get_value_end(Vset);
3606:
3607: ELSIF X_Validation_type = 'F' THEN
3608:
3609: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

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

3605: FND_VSET.get_value_end(Vset);
3606:
3607: ELSIF X_Validation_type = 'F' THEN
3608:
3609: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
3610:
3611: IF (QP_UTIL.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
3612:
3613:

Line 3720: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,

3716: -- the list populated by get_valueset call.
3717: -- ===========================================================================
3718:
3719:
3720: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,
3721: p_value VARCHAR2,
3722: x_id OUT NOCOPY VARCHAR2,
3723: x_value OUT NOCOPY VARCHAR2,
3724: x_meaning OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS