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.CSP_PACKLIST_HEADERS_PVT dependencies on FND_API

Line 63: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

59: -- End of Comments
60:
61: TYPE PLH_Rec_Type IS RECORD
62: (
63: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

60:
61: TYPE PLH_Rec_Type IS RECORD
62: (
63: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 65: CREATION_DATE DATE := FND_API.G_MISS_DATE,

61: TYPE PLH_Rec_Type IS RECORD
62: (
63: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

62: (
63: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

63: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

64: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

65: CREATION_DATE DATE := FND_API.G_MISS_DATE,
66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: DATE_CREATED DATE := FND_API.G_MISS_DATE,

Line 70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,

66: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: DATE_CREATED DATE := FND_API.G_MISS_DATE,
74: DATE_PACKED DATE := FND_API.G_MISS_DATE,

Line 71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,

67: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: DATE_CREATED DATE := FND_API.G_MISS_DATE,
74: DATE_PACKED DATE := FND_API.G_MISS_DATE,
75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,

Line 72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,

68: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: DATE_CREATED DATE := FND_API.G_MISS_DATE,
74: DATE_PACKED DATE := FND_API.G_MISS_DATE,
75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,
76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,

Line 73: DATE_CREATED DATE := FND_API.G_MISS_DATE,

69: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: DATE_CREATED DATE := FND_API.G_MISS_DATE,
74: DATE_PACKED DATE := FND_API.G_MISS_DATE,
75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,
76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,
77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 74: DATE_PACKED DATE := FND_API.G_MISS_DATE,

70: PACKLIST_NUMBER VARCHAR2(10) := FND_API.G_MISS_CHAR,
71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: DATE_CREATED DATE := FND_API.G_MISS_DATE,
74: DATE_PACKED DATE := FND_API.G_MISS_DATE,
75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,
76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,
77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,
78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,

71: SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: DATE_CREATED DATE := FND_API.G_MISS_DATE,
74: DATE_PACKED DATE := FND_API.G_MISS_DATE,
75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,
76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,
77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,
78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,

72: PACKLIST_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: DATE_CREATED DATE := FND_API.G_MISS_DATE,
74: DATE_PACKED DATE := FND_API.G_MISS_DATE,
75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,
76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,
77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,
78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,

73: DATE_CREATED DATE := FND_API.G_MISS_DATE,
74: DATE_PACKED DATE := FND_API.G_MISS_DATE,
75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,
76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,
77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,
78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,

74: DATE_PACKED DATE := FND_API.G_MISS_DATE,
75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,
76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,
77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,
78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,

75: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,
76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,
77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,
78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,

76: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,
77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,
78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

77: CARRIER VARCHAR2(60) := FND_API.G_MISS_CHAR,
78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

78: SHIPMENT_METHOD VARCHAR2(60) := FND_API.G_MISS_CHAR,
79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

79: WAYBILL VARCHAR2(60) := FND_API.G_MISS_CHAR,
80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

80: COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

81: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

82: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

83: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

84: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

85: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

86: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

87: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

88: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

89: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

90: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

91: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: );

Line 96: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

92: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: );
100:

Line 97: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

93: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: );
100:
101: G_MISS_PLH_REC PLH_Rec_Type;

Line 98: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

94: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: );
100:
101: G_MISS_PLH_REC PLH_Rec_Type;
102: TYPE PLH_Tbl_Type IS TABLE OF PLH_Rec_Type

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

111: -- Pre-Req :
112: -- Parameters:
113: -- IN
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118: -- P_PLH_Rec IN PLH_Rec_Type Required
119: --

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

112: -- Parameters:
113: -- IN
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118: -- P_PLH_Rec IN PLH_Rec_Type Required
119: --
120: -- OUT:

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

113: -- IN
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118: -- P_PLH_Rec IN PLH_Rec_Type Required
119: --
120: -- OUT:
121: -- x_return_status OUT NOCOPY VARCHAR2

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

128: -- End of Comments
129: --
130: PROCEDURE Create_packlist_headers(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: P_PLH_Rec IN PLH_Rec_Type := G_MISS_PLH_REC,
136: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

129: --
130: PROCEDURE Create_packlist_headers(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: P_PLH_Rec IN PLH_Rec_Type := G_MISS_PLH_REC,
136: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
137: X_PACKLIST_HEADER_ID OUT NOCOPY NUMBER,

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

130: PROCEDURE Create_packlist_headers(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: P_PLH_Rec IN PLH_Rec_Type := G_MISS_PLH_REC,
136: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
137: X_PACKLIST_HEADER_ID OUT NOCOPY NUMBER,
138: X_Return_Status OUT NOCOPY VARCHAR2,

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

148: -- Pre-Req :
149: -- Parameters:
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
156: -- P_PLH_Rec IN PLH_Rec_Type Required

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

149: -- Parameters:
150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
156: -- P_PLH_Rec IN PLH_Rec_Type Required
157: --

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

150: -- IN
151: -- p_api_version_number IN NUMBER Required
152: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
156: -- P_PLH_Rec IN PLH_Rec_Type Required
157: --
158: -- OUT:

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

167: --
168: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
169: PROCEDURE Update_packlist_headers(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Identity_Salesforce_Id IN NUMBER := NULL,
175: P_PLH_Rec IN PLH_Rec_Type,

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

168: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
169: PROCEDURE Update_packlist_headers(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Identity_Salesforce_Id IN NUMBER := NULL,
175: P_PLH_Rec IN PLH_Rec_Type,
176: X_Return_Status OUT NOCOPY VARCHAR2,

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

169: PROCEDURE Update_packlist_headers(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: P_Identity_Salesforce_Id IN NUMBER := NULL,
175: P_PLH_Rec IN PLH_Rec_Type,
176: X_Return_Status OUT NOCOPY VARCHAR2,
177: X_Msg_Count OUT NOCOPY NUMBER,

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

186: -- Pre-Req :
187: -- Parameters:
188: -- IN
189: -- p_api_version_number IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
194: -- P_PLH_Rec IN PLH_Rec_Type Required

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

187: -- Parameters:
188: -- IN
189: -- p_api_version_number IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
194: -- P_PLH_Rec IN PLH_Rec_Type Required
195: --

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

188: -- IN
189: -- p_api_version_number IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
194: -- P_PLH_Rec IN PLH_Rec_Type Required
195: --
196: -- OUT:

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

206: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
207: -- The Master delete procedure may not be needed depends on different business requirements.
208: PROCEDURE Delete_packlist_headers(
209: P_Api_Version_Number IN NUMBER,
210: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
211: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213: P_identity_salesforce_id IN NUMBER := NULL,
214: P_PLH_Rec IN PLH_Rec_Type,

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

207: -- The Master delete procedure may not be needed depends on different business requirements.
208: PROCEDURE Delete_packlist_headers(
209: P_Api_Version_Number IN NUMBER,
210: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
211: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213: P_identity_salesforce_id IN NUMBER := NULL,
214: P_PLH_Rec IN PLH_Rec_Type,
215: X_Return_Status OUT NOCOPY VARCHAR2,

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

208: PROCEDURE Delete_packlist_headers(
209: P_Api_Version_Number IN NUMBER,
210: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
211: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213: P_identity_salesforce_id IN NUMBER := NULL,
214: P_PLH_Rec IN PLH_Rec_Type,
215: X_Return_Status OUT NOCOPY VARCHAR2,
216: X_Msg_Count OUT NOCOPY NUMBER,

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

218: );
219:
220:
221: PROCEDURE Validate_PACKLIST_HEADER_ID (
222: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
223: P_Validation_mode IN VARCHAR2,
224: P_PACKLIST_HEADER_ID IN NUMBER,
225: -- 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.
226: X_Return_Status OUT NOCOPY VARCHAR2,

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

239: --
240: -- End of Comments
241:
242: PROCEDURE Validate_ORGANIZATION_ID (
243: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244: P_Validation_mode IN VARCHAR2,
245: P_ORGANIZATION_ID IN NUMBER,
246: -- 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.
247: X_Return_Status OUT NOCOPY VARCHAR2,

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

260: --
261: -- End of Comments
262:
263: PROCEDURE Validate_PACKLIST_NUMBER (
264: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
265: P_Validation_mode IN VARCHAR2,
266: P_PACKLIST_NUMBER IN VARCHAR2,
267: -- 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.
268: X_Return_Status OUT NOCOPY VARCHAR2,

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

281: --
282: -- End of Comments
283:
284: PROCEDURE Validate_SUBINVENTORY_CODE (
285: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
286: P_Validation_mode IN VARCHAR2,
287: P_SUBINVENTORY_CODE IN VARCHAR2,
288: -- 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.
289: X_Return_Status OUT NOCOPY VARCHAR2,

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

302: --
303: -- End of Comments
304:
305: PROCEDURE Validate_PACKLIST_STATUS (
306: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307: P_Validation_mode IN VARCHAR2,
308: P_PACKLIST_STATUS IN VARCHAR2,
309: -- 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.
310: X_Return_Status OUT NOCOPY VARCHAR2,

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

323: --
324: -- End of Comments
325:
326: PROCEDURE Validate_DATE_CREATED (
327: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
328: P_Validation_mode IN VARCHAR2,
329: P_DATE_CREATED IN DATE,
330: -- 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.
331: X_Return_Status OUT NOCOPY VARCHAR2,

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

344: --
345: -- End of Comments
346:
347: PROCEDURE Validate_DATE_PACKED (
348: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
349: P_Validation_mode IN VARCHAR2,
350: P_DATE_PACKED IN DATE,
351: -- 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.
352: X_Return_Status OUT NOCOPY VARCHAR2,

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

365: --
366: -- End of Comments
367:
368: PROCEDURE Validate_DATE_SHIPPED (
369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370: P_Validation_mode IN VARCHAR2,
371: P_DATE_SHIPPED IN DATE,
372: -- 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.
373: X_Return_Status OUT NOCOPY VARCHAR2,

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

386: --
387: -- End of Comments
388:
389: PROCEDURE Validate_DATE_RECEIVED (
390: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391: P_Validation_mode IN VARCHAR2,
392: P_DATE_RECEIVED IN DATE,
393: -- 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.
394: X_Return_Status OUT NOCOPY VARCHAR2,

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

407: --
408: -- End of Comments
409:
410: PROCEDURE Validate_CARRIER (
411: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
412: P_Validation_mode IN VARCHAR2,
413: P_CARRIER IN VARCHAR2,
414: -- 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.
415: X_Return_Status OUT NOCOPY VARCHAR2,

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

428: --
429: -- End of Comments
430:
431: PROCEDURE Validate_SHIPMENT_METHOD (
432: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
433: P_Validation_mode IN VARCHAR2,
434: P_SHIPMENT_METHOD IN VARCHAR2,
435: -- 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.
436: X_Return_Status OUT NOCOPY VARCHAR2,

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

449: --
450: -- End of Comments
451:
452: PROCEDURE Validate_WAYBILL (
453: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
454: P_Validation_mode IN VARCHAR2,
455: P_WAYBILL IN VARCHAR2,
456: -- 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.
457: X_Return_Status OUT NOCOPY VARCHAR2,

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

470: --
471: -- End of Comments
472:
473: PROCEDURE Validate_COMMENTS (
474: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
475: P_Validation_mode IN VARCHAR2,
476: P_COMMENTS IN VARCHAR2,
477: -- 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.
478: X_Return_Status OUT NOCOPY VARCHAR2,

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

491: -- 2. Developer can manually added inter-field level validation.
492: -- End of Comments
493:
494: PROCEDURE Validate_PLH_rec(
495: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
496: P_Validation_mode IN VARCHAR2,
497: P_PLH_Rec IN PLH_Rec_Type,
498: X_Return_Status OUT NOCOPY VARCHAR2,
499: X_Msg_Count OUT NOCOPY NUMBER,

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

511: -- 2. We can also validate table instead of record. There will be an option for user to choose.
512: -- End of Comments
513:
514: PROCEDURE Validate_packlist_headers(
515: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
516: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
517: P_Validation_mode IN VARCHAR2,
518: P_PLH_Rec IN PLH_Rec_Type,
519: X_Return_Status OUT NOCOPY VARCHAR2,

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

512: -- End of Comments
513:
514: PROCEDURE Validate_packlist_headers(
515: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
516: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
517: P_Validation_mode IN VARCHAR2,
518: P_PLH_Rec IN PLH_Rec_Type,
519: X_Return_Status OUT NOCOPY VARCHAR2,
520: X_Msg_Count OUT NOCOPY NUMBER,