58: -- End of Comments
59:
60: TYPE PLL_Rec_Type IS RECORD
61: (
62: PACKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
59:
60: TYPE PLL_Rec_Type IS RECORD
61: (
62: PACKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
60: TYPE PLL_Rec_Type IS RECORD
61: (
62: PACKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
61: (
62: PACKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
62: PACKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATION_DATE DATE := FND_API.G_MISS_DATE,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
65: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
68: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
69: PACKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: BOX_ID NUMBER := FND_API.G_MISS_NUM,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: QUANTITY_PACKED NUMBER := FND_API.G_MISS_NUM,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: QUANTITY_SHIPPED NUMBER := FND_API.G_MISS_NUM,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: QUANTITY_RECEIVED NUMBER := FND_API.G_MISS_NUM,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
95: LINE_ID NUMBER := FND_API.G_MISS_NUM
88: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
95: LINE_ID NUMBER := FND_API.G_MISS_NUM
96: );
89: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
95: LINE_ID NUMBER := FND_API.G_MISS_NUM
96: );
97:
90: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
95: LINE_ID NUMBER := FND_API.G_MISS_NUM
96: );
97:
98: G_MISS_PLL_REC PLL_Rec_Type;
91: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
95: LINE_ID NUMBER := FND_API.G_MISS_NUM
96: );
97:
98: G_MISS_PLL_REC PLL_Rec_Type;
99: TYPE PLL_Tbl_Type IS TABLE OF PLL_Rec_Type
108: -- Pre-Req :
109: -- Parameters:
110: -- IN
111: -- p_api_version_number IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
113: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
115: -- P_PLL_Rec IN PLL_Rec_Type Required
116: --
109: -- Parameters:
110: -- IN
111: -- p_api_version_number IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
113: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
115: -- P_PLL_Rec IN PLL_Rec_Type Required
116: --
117: -- OUT:
110: -- IN
111: -- p_api_version_number IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
113: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
115: -- P_PLL_Rec IN PLL_Rec_Type Required
116: --
117: -- OUT:
118: -- x_return_status OUT NOCOPY VARCHAR2
125: -- End of Comments
126: --
127: PROCEDURE Create_packlist_lines(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: P_PLL_Rec IN PLL_Rec_Type := G_MISS_PLL_REC,
133: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
126: --
127: PROCEDURE Create_packlist_lines(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: P_PLL_Rec IN PLL_Rec_Type := G_MISS_PLL_REC,
133: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
134: X_PACKLIST_LINE_ID OUT NOCOPY NUMBER,
127: PROCEDURE Create_packlist_lines(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: P_PLL_Rec IN PLL_Rec_Type := G_MISS_PLL_REC,
133: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
134: X_PACKLIST_LINE_ID OUT NOCOPY NUMBER,
135: X_Return_Status OUT NOCOPY VARCHAR2,
145: -- Pre-Req :
146: -- Parameters:
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
153: -- P_PLL_Rec IN PLL_Rec_Type Required
146: -- Parameters:
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
153: -- P_PLL_Rec IN PLL_Rec_Type Required
154: --
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
153: -- P_PLL_Rec IN PLL_Rec_Type Required
154: --
155: -- OUT:
164: --
165: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
166: PROCEDURE Update_packlist_lines(
167: P_Api_Version_Number IN NUMBER,
168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: P_Identity_Salesforce_Id IN NUMBER := NULL,
172: P_PLL_Rec IN PLL_Rec_Type,
165: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
166: PROCEDURE Update_packlist_lines(
167: P_Api_Version_Number IN NUMBER,
168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: P_Identity_Salesforce_Id IN NUMBER := NULL,
172: P_PLL_Rec IN PLL_Rec_Type,
173: X_Return_Status OUT NOCOPY VARCHAR2,
166: PROCEDURE Update_packlist_lines(
167: P_Api_Version_Number IN NUMBER,
168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: P_Identity_Salesforce_Id IN NUMBER := NULL,
172: P_PLL_Rec IN PLL_Rec_Type,
173: X_Return_Status OUT NOCOPY VARCHAR2,
174: X_Msg_Count OUT NOCOPY NUMBER,
183: -- Pre-Req :
184: -- Parameters:
185: -- IN
186: -- p_api_version_number IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
188: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
189: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
190: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
191: -- P_PLL_Rec IN PLL_Rec_Type Required
184: -- Parameters:
185: -- IN
186: -- p_api_version_number IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
188: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
189: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
190: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
191: -- P_PLL_Rec IN PLL_Rec_Type Required
192: --
185: -- IN
186: -- p_api_version_number IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
188: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
189: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
190: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
191: -- P_PLL_Rec IN PLL_Rec_Type Required
192: --
193: -- OUT:
203: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
204: -- The Master delete procedure may not be needed depends on different business requirements.
205: PROCEDURE Delete_packlist_lines(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: P_identity_salesforce_id IN NUMBER := NULL,
211: P_PLL_Rec IN PLL_Rec_Type,
204: -- The Master delete procedure may not be needed depends on different business requirements.
205: PROCEDURE Delete_packlist_lines(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: P_identity_salesforce_id IN NUMBER := NULL,
211: P_PLL_Rec IN PLL_Rec_Type,
212: X_Return_Status OUT NOCOPY VARCHAR2,
205: PROCEDURE Delete_packlist_lines(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: P_identity_salesforce_id IN NUMBER := NULL,
211: P_PLL_Rec IN PLL_Rec_Type,
212: X_Return_Status OUT NOCOPY VARCHAR2,
213: X_Msg_Count OUT NOCOPY NUMBER,
226: --
227: -- End of Comments
228:
229: PROCEDURE Validate_PACKLIST_LINE_ID (
230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
231: P_Validation_mode IN VARCHAR2,
232: P_PACKLIST_LINE_ID IN NUMBER,
233: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
234: X_Return_Status OUT NOCOPY VARCHAR2,
247: --
248: -- End of Comments
249:
250: PROCEDURE Validate_ORGANIZATION_ID (
251: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
252: P_Validation_mode IN VARCHAR2,
253: P_ORGANIZATION_ID IN NUMBER,
254: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
255: X_Return_Status OUT NOCOPY VARCHAR2,
268: --
269: -- End of Comments
270:
271: PROCEDURE Validate_PACKLIST_LINE_NUMBER (
272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273: P_Validation_mode IN VARCHAR2,
274: P_PACKLIST_LINE_NUMBER IN NUMBER,
275: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
276: X_Return_Status OUT NOCOPY VARCHAR2,
289: --
290: -- End of Comments
291:
292: PROCEDURE Validate_PACKLIST_HEADER_ID (
293: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
294: P_Validation_mode IN VARCHAR2,
295: P_PACKLIST_HEADER_ID IN NUMBER,
296: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
297: X_Return_Status OUT NOCOPY VARCHAR2,
310: --
311: -- End of Comments
312:
313: PROCEDURE Validate_BOX_ID (
314: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
315: P_Validation_mode IN VARCHAR2,
316: P_BOX_ID IN NUMBER,
317: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
318: X_Return_Status OUT NOCOPY VARCHAR2,
331: --
332: -- End of Comments
333:
334: PROCEDURE Validate_PICKLIST_LINE_ID (
335: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
336: P_Validation_mode IN VARCHAR2,
337: P_PICKLIST_LINE_ID IN NUMBER,
338: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
339: X_Return_Status OUT NOCOPY VARCHAR2,
352: --
353: -- End of Comments
354:
355: PROCEDURE Validate_PACKLIST_LINE_STATUS (
356: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
357: P_Validation_mode IN VARCHAR2,
358: P_PACKLIST_LINE_STATUS IN VARCHAR2,
359: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
360: X_Return_Status OUT NOCOPY VARCHAR2,
373: --
374: -- End of Comments
375:
376: PROCEDURE Validate_INVENTORY_ITEM_ID (
377: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
378: P_Validation_mode IN VARCHAR2,
379: P_INVENTORY_ITEM_ID IN NUMBER,
380: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
381: X_Return_Status OUT NOCOPY VARCHAR2,
394: --
395: -- End of Comments
396:
397: PROCEDURE Validate_QUANTITY_PACKED (
398: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
399: P_Validation_mode IN VARCHAR2,
400: P_QUANTITY_PACKED IN NUMBER,
401: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
402: X_Return_Status OUT NOCOPY VARCHAR2,
415: --
416: -- End of Comments
417:
418: PROCEDURE Validate_QUANTITY_SHIPPED (
419: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
420: P_Validation_mode IN VARCHAR2,
421: P_QUANTITY_SHIPPED IN NUMBER,
422: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
423: X_Return_Status OUT NOCOPY VARCHAR2,
436: --
437: -- End of Comments
438:
439: PROCEDURE Validate_QUANTITY_RECEIVED (
440: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
441: P_Validation_mode IN VARCHAR2,
442: P_QUANTITY_RECEIVED IN NUMBER,
443: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
444: X_Return_Status OUT NOCOPY VARCHAR2,
457: --
458: -- End of Comments
459:
460: PROCEDURE Validate_UOM_CODE (
461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
462: P_Validation_mode IN VARCHAR2,
463: P_UOM_CODE IN VARCHAR2,
464: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
465: X_Return_Status OUT NOCOPY VARCHAR2,
478: --
479: -- End of Comments
480:
481: PROCEDURE Validate_LINE_ID (
482: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
483: P_Validation_mode IN VARCHAR2,
484: P_LINE_ID IN NUMBER,
485: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
486: X_Return_Status OUT NOCOPY VARCHAR2,
499: -- 2. Developer can manually added inter-field level validation.
500: -- End of Comments
501:
502: PROCEDURE Validate_PLL_rec(
503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
504: P_Validation_mode IN VARCHAR2,
505: P_PLL_Rec IN PLL_Rec_Type,
506: X_Return_Status OUT NOCOPY VARCHAR2,
507: X_Msg_Count OUT NOCOPY NUMBER,
519: -- 2. We can also validate table instead of record. There will be an option for user to choose.
520: -- End of Comments
521:
522: PROCEDURE Validate_packlist_lines(
523: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
524: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525: P_Validation_mode IN VARCHAR2,
526: P_PLL_Rec IN PLL_Rec_Type,
527: X_Return_Status OUT NOCOPY VARCHAR2,
520: -- End of Comments
521:
522: PROCEDURE Validate_packlist_lines(
523: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
524: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
525: P_Validation_mode IN VARCHAR2,
526: P_PLL_Rec IN PLL_Rec_Type,
527: X_Return_Status OUT NOCOPY VARCHAR2,
528: X_Msg_Count OUT NOCOPY NUMBER,