APPS.OE_ORDER_PUB dependencies on FND_API

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

1966:
1967: -- Line Reservation record type
1968:
1969: TYPE Reservation_Rec_Type IS RECORD
1970: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1971: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1972: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1974: , locator_id NUMBER := FND_API.G_MISS_NUM

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

1967: -- Line Reservation record type
1968:
1969: TYPE Reservation_Rec_Type IS RECORD
1970: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1971: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1972: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1974: , locator_id NUMBER := FND_API.G_MISS_NUM
1975: , quantity NUMBER := FND_API.G_MISS_NUM

Line 1972: , lot_number_id NUMBER := FND_API.G_MISS_NUM

1968:
1969: TYPE Reservation_Rec_Type IS RECORD
1970: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1971: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1972: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1974: , locator_id NUMBER := FND_API.G_MISS_NUM
1975: , quantity NUMBER := FND_API.G_MISS_NUM
1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM

1969: TYPE Reservation_Rec_Type IS RECORD
1970: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1971: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1972: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1974: , locator_id NUMBER := FND_API.G_MISS_NUM
1975: , quantity NUMBER := FND_API.G_MISS_NUM
1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1974: , locator_id NUMBER := FND_API.G_MISS_NUM

1970: ( orig_sys_reservation_ref VARCHAR2(50) := FND_API.G_MISS_CHAR
1971: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1972: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1974: , locator_id NUMBER := FND_API.G_MISS_NUM
1975: , quantity NUMBER := FND_API.G_MISS_NUM
1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 1975: , quantity NUMBER := FND_API.G_MISS_NUM

1971: , revision VARCHAR2(3) := FND_API.G_MISS_CHAR
1972: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1974: , locator_id NUMBER := FND_API.G_MISS_NUM
1975: , quantity NUMBER := FND_API.G_MISS_NUM
1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1972: , lot_number_id NUMBER := FND_API.G_MISS_NUM
1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1974: , locator_id NUMBER := FND_API.G_MISS_NUM
1975: , quantity NUMBER := FND_API.G_MISS_NUM
1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1973: , subinventory_id NUMBER := FND_API.G_MISS_NUM
1974: , locator_id NUMBER := FND_API.G_MISS_NUM
1975: , quantity NUMBER := FND_API.G_MISS_NUM
1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1974: , locator_id NUMBER := FND_API.G_MISS_NUM
1975: , quantity NUMBER := FND_API.G_MISS_NUM
1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1975: , quantity NUMBER := FND_API.G_MISS_NUM
1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1976: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1977: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1978: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1979: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1980: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1981: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1982: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1983: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

1984: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

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

1985: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1993: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

1986: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1993: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1994: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

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

1987: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1993: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1994: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1995: , line_index NUMBER := FND_API.G_MISS_NUM

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

1988: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1993: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1994: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1995: , line_index NUMBER := FND_API.G_MISS_NUM
1996: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV

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

1989: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1993: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1994: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1995: , line_index NUMBER := FND_API.G_MISS_NUM
1996: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV
1997: );

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

1990: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1993: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1994: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1995: , line_index NUMBER := FND_API.G_MISS_NUM
1996: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV
1997: );
1998:

Line 1995: , line_index NUMBER := FND_API.G_MISS_NUM

1991: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1993: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1994: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1995: , line_index NUMBER := FND_API.G_MISS_NUM
1996: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV
1997: );
1998:
1999: TYPE Reservation_Tbl_Type IS TABLE OF Reservation_Rec_Type

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

1992: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
1993: , status_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
1994: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
1995: , line_index NUMBER := FND_API.G_MISS_NUM
1996: , quantity2 NUMBER := FND_API.G_MISS_NUM -- INVCONV
1997: );
1998:
1999: TYPE Reservation_Tbl_Type IS TABLE OF Reservation_Rec_Type
2000: INDEX BY BINARY_INTEGER;

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

2001:
2002: -- Line Reservation value record type
2003:
2004: TYPE Reservation_Val_Rec_Type IS RECORD
2005: ( lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
2006: , subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
2007: );
2008:
2009: TYPE Reservation_Val_Tbl_Type IS TABLE OF Reservation_Val_Rec_Type

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

2002: -- Line Reservation value record type
2003:
2004: TYPE Reservation_Val_Rec_Type IS RECORD
2005: ( lot_number VARCHAR2(30) := FND_API.G_MISS_CHAR
2006: , subinventory_code VARCHAR2(10) := FND_API.G_MISS_CHAR
2007: );
2008:
2009: TYPE Reservation_Val_Tbl_Type IS TABLE OF Reservation_Val_Rec_Type
2010: INDEX BY BINARY_INTEGER;

Line 2016: (SET_ID NUMBER := FND_API.G_MISS_NUM

2012:
2013: -- Set Records
2014:
2015: TYPE Set_Rec_Type IS RECORD
2016: (SET_ID NUMBER := FND_API.G_MISS_NUM
2017: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
2018: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
2019: ,SET_DATE DATE := FND_API.G_MISS_DATE
2020: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM

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

2013: -- Set Records
2014:
2015: TYPE Set_Rec_Type IS RECORD
2016: (SET_ID NUMBER := FND_API.G_MISS_NUM
2017: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
2018: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
2019: ,SET_DATE DATE := FND_API.G_MISS_DATE
2020: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
2021: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR

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

2014:
2015: TYPE Set_Rec_Type IS RECORD
2016: (SET_ID NUMBER := FND_API.G_MISS_NUM
2017: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
2018: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
2019: ,SET_DATE DATE := FND_API.G_MISS_DATE
2020: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
2021: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
2022: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 2019: ,SET_DATE DATE := FND_API.G_MISS_DATE

2015: TYPE Set_Rec_Type IS RECORD
2016: (SET_ID NUMBER := FND_API.G_MISS_NUM
2017: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
2018: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
2019: ,SET_DATE DATE := FND_API.G_MISS_DATE
2020: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
2021: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
2022: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
2023: );

Line 2020: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM

2016: (SET_ID NUMBER := FND_API.G_MISS_NUM
2017: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
2018: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
2019: ,SET_DATE DATE := FND_API.G_MISS_DATE
2020: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
2021: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
2022: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
2023: );
2024:

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

2017: ,SET_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
2018: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
2019: ,SET_DATE DATE := FND_API.G_MISS_DATE
2020: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
2021: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
2022: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
2023: );
2024:
2025: -- Line Set Record

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

2018: ,SET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
2019: ,SET_DATE DATE := FND_API.G_MISS_DATE
2020: ,SET_LOCATION NUMBER := FND_API.G_MISS_NUM
2021: ,COMPLETE_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
2022: ,SYSTEM_REQUIRED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
2023: );
2024:
2025: -- Line Set Record
2026:

Line 2028: (SET_ID NUMBER := FND_API.G_MISS_NUM

2024:
2025: -- Line Set Record
2026:
2027: TYPE Line_Set_Rec_Type IS RECORD
2028: (SET_ID NUMBER := FND_API.G_MISS_NUM
2029: ,LINE_ID NUMBER := FND_API.G_MISS_NUM
2030: );
2031:
2032:

Line 2029: ,LINE_ID NUMBER := FND_API.G_MISS_NUM

2025: -- Line Set Record
2026:
2027: TYPE Line_Set_Rec_Type IS RECORD
2028: (SET_ID NUMBER := FND_API.G_MISS_NUM
2029: ,LINE_ID NUMBER := FND_API.G_MISS_NUM
2030: );
2031:
2032:
2033: -- API request record type.

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

2047: -- Function / Procedure indentifier ie 'PRICE_LINE'
2048: -- 'RECORD_HISTORY'
2049: request_type Varchar2(30) := NULL,
2050:
2051: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
2052:
2053: -- Keys to identify a unique request.
2054: request_unique_key1 VARCHAR2(30) := NULL,
2055: request_unique_key2 VARCHAR2(30) := NULL,

Line 2131: , Cancel_by_quantity NUMBER := FND_API.G_MISS_NUM

2127: ,Header_id Number := Null
2128: ,Cancellation_type VARCHAR2(1) := OE_GLOBALS.G_FULL
2129: -- G_FULL for Completely Cancelling the line
2130: -- G_PARTAIL Partially cancelling the line
2131: , Cancel_by_quantity NUMBER := FND_API.G_MISS_NUM
2132: -- Cancellation quantity for Partial Cancellation
2133: , Cancellation_reason_code VARCHAR2(30) := NULL
2134: -- Cancellation Reason
2135: , Cancellation_comments VARCHAR2(2000) := NULL

Line 2147: , User_resp_id NUMBER := FND_API.G_MISS_NUM

2143: , Business_object VARCHAR2(30) := 'SALES_ORDER'
2144: , Wf_item_type VARCHAR2(30) := 'OEOL'
2145: , User_app_id NUMBER := 300
2146: -- User requesting cancellation
2147: , User_resp_id NUMBER := FND_API.G_MISS_NUM
2148: -- Responbisilbity requesting cancellation
2149: , Cancellation_result VARCHAR2(10) := NULL
2150: -- OE_GLOBALS.G_CANCELED cancelled sucessfully
2151: -- OE_GLOBALS.G_CANNOT_CANCEL could not cancel

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

2620: PROCEDURE Process_Order
2621: ( p_org_id IN NUMBER := NULL --MOAC
2622: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2623: , p_api_version_number IN NUMBER
2624: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2625: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2626: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
2627: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2628: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

2621: ( p_org_id IN NUMBER := NULL --MOAC
2622: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2623: , p_api_version_number IN NUMBER
2624: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2625: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2626: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
2627: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2628: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2629: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

2622: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2623: , p_api_version_number IN NUMBER
2624: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2625: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2626: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
2627: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2628: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2629: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2630: , p_header_rec IN Header_Rec_Type :=

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

2759:
2760:
2761: PROCEDURE Lock_Order
2762: ( p_api_version_number IN NUMBER
2763: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2764: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2765: , p_org_id IN NUMBER := NULL --MOAC
2766: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2767: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

2760:
2761: PROCEDURE Lock_Order
2762: ( p_api_version_number IN NUMBER
2763: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2764: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2765: , p_org_id IN NUMBER := NULL --MOAC
2766: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2767: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2768: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

2845: -- End of Comments
2846:
2847: PROCEDURE Get_Order
2848: ( p_api_version_number IN NUMBER
2849: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2850: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2851: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2852: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2853: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

2846:
2847: PROCEDURE Get_Order
2848: ( p_api_version_number IN NUMBER
2849: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2850: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
2851: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2852: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2853: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2854: , p_header_id IN NUMBER :=

Line 2855: FND_API.G_MISS_NUM

2851: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2852: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2853: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2854: , p_header_id IN NUMBER :=
2855: FND_API.G_MISS_NUM
2856: , p_header IN VARCHAR2 :=
2857: FND_API.G_MISS_CHAR
2858: , p_org_id IN NUMBER := NULL --MOAC
2859: , p_operating_unit IN VARCHAR2 := NULL -- MOAC

Line 2857: FND_API.G_MISS_CHAR

2853: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2854: , p_header_id IN NUMBER :=
2855: FND_API.G_MISS_NUM
2856: , p_header IN VARCHAR2 :=
2857: FND_API.G_MISS_CHAR
2858: , p_org_id IN NUMBER := NULL --MOAC
2859: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
2860: , x_header_rec OUT NOCOPY /* file.sql.39 change */ Header_Rec_Type
2861: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ Header_Val_Rec_Type

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

3277: PROCEDURE Process_Order
3278: ( p_org_id IN NUMBER := NULL --MOAC
3279: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3280: , p_api_version_number IN NUMBER
3281: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3282: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3283: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
3284: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3285: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

3278: ( p_org_id IN NUMBER := NULL --MOAC
3279: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3280: , p_api_version_number IN NUMBER
3281: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3282: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3283: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
3284: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3285: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3286: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

3279: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3280: , p_api_version_number IN NUMBER
3281: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3282: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3283: , p_action_commit IN VARCHAR2 := FND_API.G_FALSE
3284: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3285: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3286: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3287: , p_header_rec IN Header_Rec_Type :=

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

3484: * @rep:displayname Lock Sales Order
3485: */
3486: PROCEDURE Lock_Order
3487: ( p_api_version_number IN NUMBER
3488: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3489: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3490: , p_org_id IN NUMBER := NULL --MOAC
3491: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3492: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

3485: */
3486: PROCEDURE Lock_Order
3487: ( p_api_version_number IN NUMBER
3488: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3489: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3490: , p_org_id IN NUMBER := NULL --MOAC
3491: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3492: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3493: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

3611: * @rep:displayname Get Sales Order
3612: */
3613: PROCEDURE Get_Order
3614: ( p_api_version_number IN NUMBER
3615: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3616: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3617: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3618: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3619: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

3612: */
3613: PROCEDURE Get_Order
3614: ( p_api_version_number IN NUMBER
3615: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3616: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
3617: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3618: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3619: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3620: , p_header_id IN NUMBER :=

Line 3621: FND_API.G_MISS_NUM

3617: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3618: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
3619: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3620: , p_header_id IN NUMBER :=
3621: FND_API.G_MISS_NUM
3622: , p_header IN VARCHAR2 :=
3623: FND_API.G_MISS_CHAR
3624: , p_org_id IN NUMBER := NULL --MOAC
3625: , p_operating_unit IN VARCHAR2 := NULL -- MOAC

Line 3623: FND_API.G_MISS_CHAR

3619: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3620: , p_header_id IN NUMBER :=
3621: FND_API.G_MISS_NUM
3622: , p_header IN VARCHAR2 :=
3623: FND_API.G_MISS_CHAR
3624: , p_org_id IN NUMBER := NULL --MOAC
3625: , p_operating_unit IN VARCHAR2 := NULL -- MOAC
3626:
3627: , x_header_rec OUT NOCOPY /* file.sql.39 change */ Header_Rec_Type