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

Line 1489: L_Valueset_R FND_VSET.VALUESET_R;

1485: x_vsid OUT NOCOPY NUMBER,
1486: x_format_type OUT NOCOPY VARCHAR2,
1487: x_validation_type OUT NOCOPY VARCHAR2)
1488: IS
1489: L_Valueset_R FND_VSET.VALUESET_R;
1490: X_VALUESETID NUMBER;
1491: L_valueset_dr FND_VSET.VALUESET_DR;
1492: v_dflex_r fnd_dflex.dflex_r;
1493: v_segments_dr fnd_dflex.segments_dr;

Line 1491: L_valueset_dr FND_VSET.VALUESET_DR;

1487: x_validation_type OUT NOCOPY VARCHAR2)
1488: IS
1489: L_Valueset_R FND_VSET.VALUESET_R;
1490: X_VALUESETID NUMBER;
1491: L_valueset_dr FND_VSET.VALUESET_DR;
1492: v_dflex_r fnd_dflex.dflex_r;
1493: v_segments_dr fnd_dflex.segments_dr;
1494: v_context_r fnd_dflex.context_r;
1495: BEGIN

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

1507: END IF;
1508: END LOOP;
1509:
1510: IF X_VALUESETID IS NOT NULL THEN
1511: FND_VSET.GET_VALUESET(X_VALUESETID,l_valueset_r,l_valueset_dr);
1512: X_VSID :=X_VALUESETID;
1513: X_FORMAT_TYPE :=l_valueset_dr.FORMAT_TYPE;
1514: X_VALIDATION_TYPE :=l_valueset_r.VALIDATION_TYPE;
1515: ELSE

Line 1528: Vset FND_VSET.valueset_r;

1524: ,p_segment_name IN VARCHAR2
1525: ,p_attr_value IN VARCHAR2
1526: ,p_comparison_operator_code IN VARCHAR2 := NULL
1527: ) RETURN VARCHAR2 IS
1528: Vset FND_VSET.valueset_r;
1529: Fmt FND_VSET.valueset_dr;
1530: Found BOOLEAN;
1531: Row NUMBER;
1532: Value FND_VSET.value_dr;

Line 1529: Fmt FND_VSET.valueset_dr;

1525: ,p_attr_value IN VARCHAR2
1526: ,p_comparison_operator_code IN VARCHAR2 := NULL
1527: ) RETURN VARCHAR2 IS
1528: Vset FND_VSET.valueset_r;
1529: Fmt FND_VSET.valueset_dr;
1530: Found BOOLEAN;
1531: Row NUMBER;
1532: Value FND_VSET.value_dr;
1533: x_Format_Type Varchar2(1);

Line 1532: Value FND_VSET.value_dr;

1528: Vset FND_VSET.valueset_r;
1529: Fmt FND_VSET.valueset_dr;
1530: Found BOOLEAN;
1531: Row NUMBER;
1532: Value FND_VSET.value_dr;
1533: x_Format_Type Varchar2(1);
1534: x_Validation_Type Varchar2(1);
1535: x_Vsid NUMBER;
1536: x_attr_value_code VARCHAR2(240);

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

1558:
1559: IF p_comparison_operator_code <> 'BETWEEN' THEN
1560: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
1561: IF x_Validation_Type = 'I' THEN
1562: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1563: FND_VSET.get_value_init(Vset,TRUE);
1564: FND_VSET.get_value(Vset,Row,Found,Value);
1565: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1566: While(Found) Loop

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

1559: IF p_comparison_operator_code <> 'BETWEEN' THEN
1560: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
1561: IF x_Validation_Type = 'I' THEN
1562: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1563: FND_VSET.get_value_init(Vset,TRUE);
1564: FND_VSET.get_value(Vset,Row,Found,Value);
1565: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1566: While(Found) Loop
1567: If l_attr_value = Value.id Then

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

1560: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
1561: IF x_Validation_Type = 'I' THEN
1562: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1563: FND_VSET.get_value_init(Vset,TRUE);
1564: FND_VSET.get_value(Vset,Row,Found,Value);
1565: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1566: While(Found) Loop
1567: If l_attr_value = Value.id Then
1568: x_attr_value_code := Value.value;

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

1568: x_attr_value_code := Value.value;
1569: Value_Valid_In_Valueset := TRUE;
1570: EXIT;
1571: End If;
1572: FND_VSET.get_value(Vset,Row,Found,Value);
1573: End Loop;
1574: Else -- id not defined.Hence compare for value
1575: While(Found) Loop
1576: If l_attr_value = Value.value Then

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

1577: x_attr_value_code := l_attr_value;
1578: Value_Valid_In_Valueset := TRUE;
1579: EXIT;
1580: End If;
1581: FND_VSET.get_value(Vset,Row,Found,Value);
1582: End Loop;
1583: End If; ---end of Fmt.Has_Id
1584: FND_VSET.get_value_end(Vset);
1585: ELSIF X_Validation_type = 'F' THEN

Line 1584: FND_VSET.get_value_end(Vset);

1580: End If;
1581: FND_VSET.get_value(Vset,Row,Found,Value);
1582: End Loop;
1583: End If; ---end of Fmt.Has_Id
1584: FND_VSET.get_value_end(Vset);
1585: ELSIF X_Validation_type = 'F' THEN
1586: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1587: IF (OE_AUDIT_HISTORY_PVT.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
1588: IF Fmt.Has_Id Then --id is defined.Hence compare for id

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

1582: End Loop;
1583: End If; ---end of Fmt.Has_Id
1584: FND_VSET.get_value_end(Vset);
1585: ELSIF X_Validation_type = 'F' THEN
1586: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1587: IF (OE_AUDIT_HISTORY_PVT.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
1588: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1589: If l_attr_value = l_id Then
1590: x_attr_value_code := l_value;

Line 1719: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,

1715: -- the list populated by get_valueset call.
1716: -- ===========================================================================
1717:
1718:
1719: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,
1720: p_value VARCHAR2,
1721: x_id OUT NOCOPY VARCHAR2,
1722: x_value OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
1723: v_selectstmt VARCHAR2(2000) ; --dhgupta changed length from 500 to 2000 for bug # 1888160