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_ORDER_PUB dependencies on FND_API

Line 1906: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR

1902:
1903: -- Line Reservation record type
1904:
1905: TYPE Reservation_Rec_Type IS RECORD
1906: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1907: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1908: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1910: , locator_id NUMBER := FND_API.G_MISS_NUM

Line 1907: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR

1903: -- Line Reservation record type
1904:
1905: TYPE Reservation_Rec_Type IS RECORD
1906: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1907: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1908: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1910: , locator_id NUMBER := FND_API.G_MISS_NUM
1911: , quantity NUMBER := FND_API.G_MISS_NUM

Line 1908: , lot_number_id NUMBER := FND_API.G_MISS_NUM

1904:
1905: TYPE Reservation_Rec_Type IS RECORD
1906: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1907: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1908: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1910: , locator_id NUMBER := FND_API.G_MISS_NUM
1911: , quantity NUMBER := FND_API.G_MISS_NUM
1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM

1905: TYPE Reservation_Rec_Type IS RECORD
1906: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1907: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1908: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1910: , locator_id NUMBER := FND_API.G_MISS_NUM
1911: , quantity NUMBER := FND_API.G_MISS_NUM
1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1910: , locator_id NUMBER := FND_API.G_MISS_NUM

1906: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1907: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1908: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1910: , locator_id NUMBER := FND_API.G_MISS_NUM
1911: , quantity NUMBER := FND_API.G_MISS_NUM
1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1911: , quantity NUMBER := FND_API.G_MISS_NUM

1907: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1908: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1910: , locator_id NUMBER := FND_API.G_MISS_NUM
1911: , quantity NUMBER := FND_API.G_MISS_NUM
1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

1908: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1910: , locator_id NUMBER := FND_API.G_MISS_NUM
1911: , quantity NUMBER := FND_API.G_MISS_NUM
1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

1909: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1910: , locator_id NUMBER := FND_API.G_MISS_NUM
1911: , quantity NUMBER := FND_API.G_MISS_NUM
1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

1910: , locator_id NUMBER := FND_API.G_MISS_NUM
1911: , quantity NUMBER := FND_API.G_MISS_NUM
1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

1911: , quantity NUMBER := FND_API.G_MISS_NUM
1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

1912: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

1913: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

1914: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

1915: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

1916: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

1917: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

1918: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

1919: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

1920: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

1921: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

1922: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1930: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

1923: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1930: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1931: , line_index NUMBER := FND_API.G_MISS_NUM

Line 1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

1924: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1930: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1931: , line_index NUMBER := FND_API.G_MISS_NUM
1932: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV

Line 1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

1925: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1930: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1931: , line_index NUMBER := FND_API.G_MISS_NUM
1932: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV
1933: );

Line 1930: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

1926: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1930: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1931: , line_index NUMBER := FND_API.G_MISS_NUM
1932: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV
1933: );
1934:

Line 1931: , line_index NUMBER := FND_API.G_MISS_NUM

1927: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1930: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1931: , line_index NUMBER := FND_API.G_MISS_NUM
1932: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV
1933: );
1934:
1935: TYPE Reservation_Tbl_Type IS TABLE OF Reservation_Rec_Type

Line 1932: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV

1928: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1929: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1930: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1931: , line_index NUMBER := FND_API.G_MISS_NUM
1932: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV
1933: );
1934:
1935: TYPE Reservation_Tbl_Type IS TABLE OF Reservation_Rec_Type
1936: INDEX BY BINARY_INTEGER;

Line 1941: ( lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR

1937:
1938: -- Line Reservation value record type
1939:
1940: TYPE Reservation_Val_Rec_Type IS RECORD
1941: ( lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
1942: , subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
1943: );
1944:
1945: TYPE Reservation_Val_Tbl_Type IS TABLE OF Reservation_Val_Rec_Type

Line 1942: , subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR

1938: -- Line Reservation value record type
1939:
1940: TYPE Reservation_Val_Rec_Type IS RECORD
1941: ( lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
1942: , subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
1943: );
1944:
1945: TYPE Reservation_Val_Tbl_Type IS TABLE OF Reservation_Val_Rec_Type
1946: INDEX BY BINARY_INTEGER;

Line 1952: (SET_ID NUMBER := FND_API.G_MISS_NUM

1948:
1949: -- Set Records
1950:
1951: TYPE Set_Rec_Type IS RECORD
1952: (SET_ID NUMBER := FND_API.G_MISS_NUM
1953: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
1954: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
1955: ,SET_DATE DATE := FND_API.G_MISS_DATE
1956: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM

Line 1953: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR

1949: -- Set Records
1950:
1951: TYPE Set_Rec_Type IS RECORD
1952: (SET_ID NUMBER := FND_API.G_MISS_NUM
1953: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
1954: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
1955: ,SET_DATE DATE := FND_API.G_MISS_DATE
1956: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
1957: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 1954: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR

1950:
1951: TYPE Set_Rec_Type IS RECORD
1952: (SET_ID NUMBER := FND_API.G_MISS_NUM
1953: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
1954: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
1955: ,SET_DATE DATE := FND_API.G_MISS_DATE
1956: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
1957: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
1958: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 1955: ,SET_DATE DATE := FND_API.G_MISS_DATE

1951: TYPE Set_Rec_Type IS RECORD
1952: (SET_ID NUMBER := FND_API.G_MISS_NUM
1953: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
1954: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
1955: ,SET_DATE DATE := FND_API.G_MISS_DATE
1956: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
1957: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
1958: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
1959: );

Line 1956: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM

1952: (SET_ID NUMBER := FND_API.G_MISS_NUM
1953: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
1954: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
1955: ,SET_DATE DATE := FND_API.G_MISS_DATE
1956: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
1957: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
1958: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
1959: );
1960:

Line 1957: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR

1953: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
1954: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
1955: ,SET_DATE DATE := FND_API.G_MISS_DATE
1956: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
1957: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
1958: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
1959: );
1960:
1961: -- Line Set Record

Line 1958: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

1954: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
1955: ,SET_DATE DATE := FND_API.G_MISS_DATE
1956: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
1957: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
1958: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
1959: );
1960:
1961: -- Line Set Record
1962:

Line 1964: (SET_ID NUMBER := FND_API.G_MISS_NUM

1960:
1961: -- Line Set Record
1962:
1963: TYPE Line_Set_Rec_Type IS RECORD
1964: (SET_ID NUMBER := FND_API.G_MISS_NUM
1965: ,LINE_ID NUMBER := FND_API.G_MISS_NUM
1966: );
1967:
1968:

Line 1965: ,LINE_ID NUMBER := FND_API.G_MISS_NUM

1961: -- Line Set Record
1962:
1963: TYPE Line_Set_Rec_Type IS RECORD
1964: (SET_ID NUMBER := FND_API.G_MISS_NUM
1965: ,LINE_ID NUMBER := FND_API.G_MISS_NUM
1966: );
1967:
1968:
1969: -- API request record type.

Line 1987: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,

1983: -- Function / Procedure indentifier ie 'PRICE_LINE'
1984: -- 'RECORD_HISTORY'
1985: request_type Varchar2(30) := NULL,
1986:
1987: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
1988:
1989: -- Keys to identify a unique request.
1990: request_unique_key1 VARCHAR2(30) := NULL,
1991: request_unique_key2 VARCHAR2(30) := NULL,

Line 2067: , Cancel_by_quantity NUMBER := FND_API.G_MISS_NUM

2063: ,Header_id Number := Null
2064: ,Cancellation_type VARCHAR2(1) := OE_GLOBALS.G_FULL
2065: -- G_FULL for Completely Cancelling the line
2066: -- G_PARTAIL Partially cancelling the line
2067: , Cancel_by_quantity NUMBER := FND_API.G_MISS_NUM
2068: -- Cancellation quantity for Partial Cancellation
2069: , Cancellation_reason_code VARCHAR2(30) := NULL
2070: -- Cancellation Reason
2071: , Cancellation_comments VARCHAR2(2000) := NULL

Line 2083: , User_resp_id NUMBER := FND_API.G_MISS_NUM

2079: , Business_object VARCHAR2(30) := 'SALES_ORDER'
2080: , Wf_item_type VARCHAR2(30) := 'OEOL'
2081: , User_app_id NUMBER := 300
2082: -- User requesting cancellation
2083: , User_resp_id NUMBER := FND_API.G_MISS_NUM
2084: -- Responbisilbity requesting cancellation
2085: , Cancellation_result VARCHAR2(10) := NULL
2086: -- OE_GLOBALS.G_CANCELED cancelled sucessfully
2087: -- OE_GLOBALS.G_CANNOT_CANCEL could not cancel

Line 2456: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2452: PROCEDURE Process_Order
2453: ( p_org_id IN NUMBER := NULL --MOAC
2454: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2455: , p_api_version_number IN NUMBER
2456: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2457: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2458: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
2459: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2460: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 2457: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

2453: ( p_org_id IN NUMBER := NULL --MOAC
2454: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2455: , p_api_version_number IN NUMBER
2456: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2457: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2458: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
2459: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2460: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2461: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2458: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE

2454: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2455: , p_api_version_number IN NUMBER
2456: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2457: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2458: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
2459: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2460: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2461: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2462: , p_header_rec IN Header_Rec_Type :=

Line 2589: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2585:
2586:
2587: PROCEDURE Lock_Order
2588: ( p_api_version_number IN NUMBER
2589: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2590: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2591: , p_org_id IN NUMBER := NULL --MOAC
2592: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2593: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2590: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

2586:
2587: PROCEDURE Lock_Order
2588: ( p_api_version_number IN NUMBER
2589: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2590: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2591: , p_org_id IN NUMBER := NULL --MOAC
2592: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2593: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2594: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 2675: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2671: -- End of Comments
2672:
2673: PROCEDURE Get_Order
2674: ( p_api_version_number IN NUMBER
2675: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2676: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2677: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2678: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2679: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2676: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

2672:
2673: PROCEDURE Get_Order
2674: ( p_api_version_number IN NUMBER
2675: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2676: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2677: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2678: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2679: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2680: , p_header_id IN NUMBER :=

Line 2681: FND_API.G_MISS_NUM

2677: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2678: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2679: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2680: , p_header_id IN NUMBER :=
2681: FND_API.G_MISS_NUM
2682: , p_header IN VARCHAR2 :=
2683: FND_API.G_MISS_CHAR
2684: , p_org_id IN NUMBER := NULL --MOAC
2685: , p_operating_unit IN VARCHAR2 := NULL -- MOAC

Line 2683: FND_API.G_MISS_CHAR

2679: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2680: , p_header_id IN NUMBER :=
2681: FND_API.G_MISS_NUM
2682: , p_header IN VARCHAR2 :=
2683: FND_API.G_MISS_CHAR
2684: , p_org_id IN NUMBER := NULL --MOAC
2685: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2686: , x_header_rec OUT NOCOPY /* file.sql.39 change */ Header_Rec_Type
2687: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ Header_Val_Rec_Type

Line 3085: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3081: PROCEDURE Process_Order
3082: ( p_org_id IN NUMBER := NULL --MOAC
3083: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3084: , p_api_version_number IN NUMBER
3085: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3086: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3087: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
3088: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3089: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 3086: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

3082: ( p_org_id IN NUMBER := NULL --MOAC
3083: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3084: , p_api_version_number IN NUMBER
3085: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3086: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3087: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
3088: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3089: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3090: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 3087: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE

3083: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3084: , p_api_version_number IN NUMBER
3085: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3086: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3087: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
3088: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3089: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3090: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3091: , p_header_rec IN Header_Rec_Type :=

Line 3284: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3280: * @rep:displayname Lock Sales Order
3281: */
3282: PROCEDURE Lock_Order
3283: ( p_api_version_number IN NUMBER
3284: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3285: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3286: , p_org_id IN NUMBER := NULL --MOAC
3287: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3288: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 3285: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

3281: */
3282: PROCEDURE Lock_Order
3283: ( p_api_version_number IN NUMBER
3284: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3285: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3286: , p_org_id IN NUMBER := NULL --MOAC
3287: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3288: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3289: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 3408: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3404: * @rep:displayname Get Sales Order
3405: */
3406: PROCEDURE Get_Order
3407: ( p_api_version_number IN NUMBER
3408: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3409: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3410: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3411: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3412: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 3409: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

3405: */
3406: PROCEDURE Get_Order
3407: ( p_api_version_number IN NUMBER
3408: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3409: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3410: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3411: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3412: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3413: , p_header_id IN NUMBER :=

Line 3414: FND_API.G_MISS_NUM

3410: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3411: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3412: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3413: , p_header_id IN NUMBER :=
3414: FND_API.G_MISS_NUM
3415: , p_header IN VARCHAR2 :=
3416: FND_API.G_MISS_CHAR
3417: , p_org_id IN NUMBER := NULL --MOAC
3418: , p_operating_unit IN VARCHAR2 := NULL -- MOAC

Line 3416: FND_API.G_MISS_CHAR

3412: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3413: , p_header_id IN NUMBER :=
3414: FND_API.G_MISS_NUM
3415: , p_header IN VARCHAR2 :=
3416: FND_API.G_MISS_CHAR
3417: , p_org_id IN NUMBER := NULL --MOAC
3418: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3419:
3420: , x_header_rec OUT NOCOPY /* file.sql.39 change */ Header_Rec_Type