APPS.CSP_PACKLIST_HEADERS_PUB dependencies on FND_API

Line 64: ROW_ID ROWID := FND_API.G_MISS_CHAR,

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

Line 65: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 66: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 67: CREATION_DATE DATE := FND_API.G_MISS_DATE,

63: (
64: ROW_ID ROWID := FND_API.G_MISS_CHAR,
65: PACKLIST_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
66: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
67: CREATION_DATE DATE := FND_API.G_MISS_DATE,
68: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
69: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
70: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
71: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 68: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 69: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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

Line 70: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

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

Line 71: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

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

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

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

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

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

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

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

Line 75: DATE_CREATED DATE := FND_API.G_MISS_DATE,

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

Line 76: DATE_PACKED DATE := FND_API.G_MISS_DATE,

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

Line 77: DATE_SHIPPED DATE := FND_API.G_MISS_DATE,

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

Line 78: DATE_RECEIVED DATE := FND_API.G_MISS_DATE,

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

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

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

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

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

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

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

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

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

Line 83: LOCATION_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 84: PARTY_SITE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

119: -- Pre-Req :
120: -- Parameters:
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- P_PLH_Rec IN PLH_Rec_Type Required
126: --
127: -- OUT:

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

120: -- Parameters:
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- P_PLH_Rec IN PLH_Rec_Type Required
126: --
127: -- OUT:
128: -- x_return_status OUT NOCOPY VARCHAR2

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

135: -- End of Comments
136: --
137: PROCEDURE Create_packlist_headers(
138: P_Api_Version_Number IN NUMBER,
139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
140: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
141: P_PLH_Rec IN PLH_Rec_Type := G_MISS_PLH_REC,
142: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
143: X_PACKLIST_HEADER_ID OUT NOCOPY NUMBER,

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

136: --
137: PROCEDURE Create_packlist_headers(
138: P_Api_Version_Number IN NUMBER,
139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
140: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
141: P_PLH_Rec IN PLH_Rec_Type := G_MISS_PLH_REC,
142: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
143: X_PACKLIST_HEADER_ID OUT NOCOPY NUMBER,
144: X_Return_Status OUT NOCOPY VARCHAR2,

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

154: -- Pre-Req :
155: -- Parameters:
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
161: -- P_PLH_Rec IN PLH_Rec_Type Required
162: --

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

155: -- Parameters:
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
161: -- P_PLH_Rec IN PLH_Rec_Type Required
162: --
163: -- OUT:

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

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

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

173: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
174: PROCEDURE Update_packlist_headers(
175: P_Api_Version_Number IN NUMBER,
176: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
177: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
178: P_Identity_Salesforce_Id IN NUMBER := NULL,
179: P_PLH_Rec IN PLH_Rec_Type,
180: X_Return_Status OUT NOCOPY VARCHAR2,
181: X_Msg_Count OUT NOCOPY NUMBER,

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

190: -- Pre-Req :
191: -- Parameters:
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
197: -- P_PLH_Rec IN PLH_Rec_Type Required
198: --

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

191: -- Parameters:
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
197: -- P_PLH_Rec IN PLH_Rec_Type Required
198: --
199: -- OUT:

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

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

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

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

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

227: -- Pre-Req :
228: -- Parameters:
229: -- IN
230: -- p_api_version_number IN NUMBER Required
231: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
232: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
233: -- P_PLH_Rec IN PLH_Rec_Type Required
234: -- Hint: Add List of bind variables here
235: -- p_rec_requested IN NUMBER Optional Default = 30

Line 241: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

237: --
238: -- Return Total Records Count Flag. This flag controls whether the total record count
239: -- and total record amount is returned.
240: --
241: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
242: -- Hint: User defined record type
243: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
244: --
245: -- OUT:

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

259: -- End of Comments
260: --
261: PROCEDURE Get_packlist_headers(
262: P_Api_Version_Number IN NUMBER,
263: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
264: P_identity_salesforce_id IN NUMBER := NULL,
265: P_PLH_Rec IN CSP_packlist_headers_PUB.PLH_Rec_Type,
266: -- Hint: Add list of bind variables here
267: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 269: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

265: P_PLH_Rec IN CSP_packlist_headers_PUB.PLH_Rec_Type,
266: -- Hint: Add list of bind variables here
267: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
268: p_start_rec_prt IN NUMBER := 1,
269: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
270: -- Hint: user defined record type
271: p_order_by_rec IN CSP_packlist_headers_PUB.PLH_sort_rec_type,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,