DBA Data[Home] [Help]

APPS.CSP_PACKLIST_LINES_PVT dependencies on FND_API

Line 62: PACKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 63: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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,

Line 64: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 65: LAST_UPDATED_BY 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,

Line 66: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 67: LAST_UPDATE_LOGIN 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,

Line 68: ORGANIZATION_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,

Line 69: PACKLIST_LINE_NUMBER 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,

Line 70: PACKLIST_HEADER_ID 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,
74: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

Line 71: BOX_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,

Line 72: PICKLIST_LINE_ID 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,

Line 73: PACKLIST_LINE_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 74: INVENTORY_ITEM_ID 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,

Line 75: QUANTITY_PACKED 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,
79: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 76: QUANTITY_SHIPPED 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,
80: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 77: QUANTITY_RECEIVED 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,
81: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 78: ATTRIBUTE_CATEGORY 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,
82: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 79: ATTRIBUTE1 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,

Line 80: ATTRIBUTE2 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,

Line 81: ATTRIBUTE3 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,

Line 82: ATTRIBUTE4 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,

Line 83: ATTRIBUTE5 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,

Line 84: ATTRIBUTE6 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,

Line 85: ATTRIBUTE7 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,

Line 86: ATTRIBUTE8 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,

Line 87: ATTRIBUTE9 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,

Line 88: ATTRIBUTE10 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,

Line 89: ATTRIBUTE11 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,

Line 90: ATTRIBUTE12 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,

Line 91: ATTRIBUTE13 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,
95: LINE_ID NUMBER := FND_API.G_MISS_NUM

Line 92: ATTRIBUTE14 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
96: );

Line 93: ATTRIBUTE15 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: );
97:

Line 94: UOM_CODE VARCHAR2(3) := 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:
98: G_MISS_PLL_REC PLL_Rec_Type;

Line 95: LINE_ID NUMBER := FND_API.G_MISS_NUM

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

Line 112: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 113: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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:

Line 114: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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.

Line 130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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: --

Line 151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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:

Line 168: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 169: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 187: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 188: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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: --

Line 189: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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:

Line 207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 208: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 230: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 251: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 272: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 293: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 314: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 335: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 356: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 377: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 398: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 419: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 440: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 482: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 523: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 524: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,