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 1860: L_Valueset_R FND_VSET.VALUESET_R;

1856: x_vsid OUT NOCOPY NUMBER,
1857: x_format_type OUT NOCOPY VARCHAR2,
1858: x_validation_type OUT NOCOPY VARCHAR2)
1859: IS
1860: L_Valueset_R FND_VSET.VALUESET_R;
1861: X_VALUESETID NUMBER;
1862: L_valueset_dr FND_VSET.VALUESET_DR;
1863: v_dflex_r fnd_dflex.dflex_r;
1864: v_segments_dr fnd_dflex.segments_dr;

Line 1862: L_valueset_dr FND_VSET.VALUESET_DR;

1858: x_validation_type OUT NOCOPY VARCHAR2)
1859: IS
1860: L_Valueset_R FND_VSET.VALUESET_R;
1861: X_VALUESETID NUMBER;
1862: L_valueset_dr FND_VSET.VALUESET_DR;
1863: v_dflex_r fnd_dflex.dflex_r;
1864: v_segments_dr fnd_dflex.segments_dr;
1865: v_context_r fnd_dflex.context_r;
1866: BEGIN

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

1878: END IF;
1879: END LOOP;
1880:
1881: IF X_VALUESETID IS NOT NULL THEN
1882: FND_VSET.GET_VALUESET(X_VALUESETID,l_valueset_r,l_valueset_dr);
1883: X_VSID :=X_VALUESETID;
1884: X_FORMAT_TYPE :=l_valueset_dr.FORMAT_TYPE;
1885: X_VALIDATION_TYPE :=l_valueset_r.VALIDATION_TYPE;
1886: ELSE

Line 1899: Vset FND_VSET.valueset_r;

1895: ,p_segment_name IN VARCHAR2
1896: ,p_attr_value IN VARCHAR2
1897: ,p_comparison_operator_code IN VARCHAR2 := NULL
1898: ) RETURN VARCHAR2 IS
1899: Vset FND_VSET.valueset_r;
1900: Fmt FND_VSET.valueset_dr;
1901: Found BOOLEAN;
1902: Row NUMBER;
1903: Value FND_VSET.value_dr;

Line 1900: Fmt FND_VSET.valueset_dr;

1896: ,p_attr_value IN VARCHAR2
1897: ,p_comparison_operator_code IN VARCHAR2 := NULL
1898: ) RETURN VARCHAR2 IS
1899: Vset FND_VSET.valueset_r;
1900: Fmt FND_VSET.valueset_dr;
1901: Found BOOLEAN;
1902: Row NUMBER;
1903: Value FND_VSET.value_dr;
1904: x_Format_Type Varchar2(1);

Line 1903: Value FND_VSET.value_dr;

1899: Vset FND_VSET.valueset_r;
1900: Fmt FND_VSET.valueset_dr;
1901: Found BOOLEAN;
1902: Row NUMBER;
1903: Value FND_VSET.value_dr;
1904: x_Format_Type Varchar2(1);
1905: x_Validation_Type Varchar2(1);
1906: x_Vsid NUMBER;
1907: x_attr_value_code VARCHAR2(240);

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

1929:
1930: IF p_comparison_operator_code <> 'BETWEEN' THEN
1931: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
1932: IF x_Validation_Type = 'I' THEN
1933: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1934: FND_VSET.get_value_init(Vset,TRUE);
1935: FND_VSET.get_value(Vset,Row,Found,Value);
1936: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1937: While(Found) Loop

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

1930: IF p_comparison_operator_code <> 'BETWEEN' THEN
1931: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
1932: IF x_Validation_Type = 'I' THEN
1933: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1934: FND_VSET.get_value_init(Vset,TRUE);
1935: FND_VSET.get_value(Vset,Row,Found,Value);
1936: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1937: While(Found) Loop
1938: If l_attr_value = Value.id Then

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

1931: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
1932: IF x_Validation_Type = 'I' THEN
1933: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1934: FND_VSET.get_value_init(Vset,TRUE);
1935: FND_VSET.get_value(Vset,Row,Found,Value);
1936: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1937: While(Found) Loop
1938: If l_attr_value = Value.id Then
1939: x_attr_value_code := Value.value;

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

1939: x_attr_value_code := Value.value;
1940: Value_Valid_In_Valueset := TRUE;
1941: EXIT;
1942: End If;
1943: FND_VSET.get_value(Vset,Row,Found,Value);
1944: End Loop;
1945: Else -- id not defined.Hence compare for value
1946: While(Found) Loop
1947: If l_attr_value = Value.value Then

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

1948: x_attr_value_code := l_attr_value;
1949: Value_Valid_In_Valueset := TRUE;
1950: EXIT;
1951: End If;
1952: FND_VSET.get_value(Vset,Row,Found,Value);
1953: End Loop;
1954: End If; ---end of Fmt.Has_Id
1955: FND_VSET.get_value_end(Vset);
1956: ELSIF X_Validation_type = 'F' THEN

Line 1955: FND_VSET.get_value_end(Vset);

1951: End If;
1952: FND_VSET.get_value(Vset,Row,Found,Value);
1953: End Loop;
1954: End If; ---end of Fmt.Has_Id
1955: FND_VSET.get_value_end(Vset);
1956: ELSIF X_Validation_type = 'F' THEN
1957: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1958: IF (OE_AUDIT_HISTORY_PVT.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
1959: IF Fmt.Has_Id Then --id is defined.Hence compare for id

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

1953: End Loop;
1954: End If; ---end of Fmt.Has_Id
1955: FND_VSET.get_value_end(Vset);
1956: ELSIF X_Validation_type = 'F' THEN
1957: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);
1958: IF (OE_AUDIT_HISTORY_PVT.value_exists_in_table(Vset.table_info,l_attr_value,l_id,l_value)) THEN
1959: IF Fmt.Has_Id Then --id is defined.Hence compare for id
1960: If l_attr_value = l_id Then
1961: x_attr_value_code := l_value;

Line 2090: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,

2086: -- the list populated by get_valueset call.
2087: -- ===========================================================================
2088:
2089:
2090: FUNCTION value_exists_in_table(p_table_r fnd_vset.table_r,
2091: p_value VARCHAR2,
2092: x_id OUT NOCOPY VARCHAR2,
2093: x_value OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
2094: v_selectstmt VARCHAR2(2000) ; --dhgupta changed length from 500 to 2000 for bug # 1888160