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_LINES_PUB 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 118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

114: -- Pre-Req :
115: -- Parameters:
116: -- IN
117: -- p_api_version_number IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120: -- P_PLL_Rec IN PLL_Rec_Type Required
121: --
122: -- OUT:

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

115: -- Parameters:
116: -- IN
117: -- p_api_version_number IN NUMBER Required
118: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120: -- P_PLL_Rec IN PLL_Rec_Type Required
121: --
122: -- OUT:
123: -- x_return_status OUT NOCOPY VARCHAR2

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

130: -- End of Comments
131: --
132: PROCEDURE Create_packlist_lines(
133: P_Api_Version_Number IN NUMBER,
134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136: P_PLL_Rec IN PLL_Rec_Type := G_MISS_PLL_REC,
137: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
138: X_PACKLIST_LINE_ID OUT NOCOPY NUMBER,

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

131: --
132: PROCEDURE Create_packlist_lines(
133: P_Api_Version_Number IN NUMBER,
134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
136: P_PLL_Rec IN PLL_Rec_Type := G_MISS_PLL_REC,
137: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
138: X_PACKLIST_LINE_ID OUT NOCOPY NUMBER,
139: X_Return_Status OUT NOCOPY VARCHAR2,

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

149: -- Pre-Req :
150: -- Parameters:
151: -- IN
152: -- p_api_version_number IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
154: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
155: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
156: -- P_PLL_Rec IN PLL_Rec_Type Required
157: --

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

150: -- Parameters:
151: -- IN
152: -- p_api_version_number IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
154: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
155: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
156: -- P_PLL_Rec IN PLL_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_lines(
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_Identity_Salesforce_Id IN NUMBER := NULL,
174: P_PLL_Rec IN PLL_Rec_Type,
175: X_Return_Status OUT NOCOPY VARCHAR2,

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_lines(
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_Identity_Salesforce_Id IN NUMBER := NULL,
174: P_PLL_Rec IN PLL_Rec_Type,
175: X_Return_Status OUT NOCOPY VARCHAR2,
176: X_Msg_Count OUT NOCOPY NUMBER,

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

185: -- Pre-Req :
186: -- Parameters:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
192: -- P_PLL_Rec IN PLL_Rec_Type Required
193: --

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

186: -- Parameters:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
192: -- P_PLL_Rec IN PLL_Rec_Type Required
193: --
194: -- OUT:

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

204: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
205: -- The Master delete procedure may not be needed depends on different business requirements.
206: PROCEDURE Delete_packlist_lines(
207: P_Api_Version_Number IN NUMBER,
208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
209: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
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_Commit IN VARCHAR2 := FND_API.G_FALSE,

205: -- The Master delete procedure may not be needed depends on different business requirements.
206: PROCEDURE Delete_packlist_lines(
207: P_Api_Version_Number IN NUMBER,
208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
209: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
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 226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

222: -- Pre-Req :
223: -- Parameters:
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
228: -- P_PLL_Rec IN PLL_Rec_Type Required
229: -- Hint: Add List of bind variables here
230: -- p_rec_requested IN NUMBER Optional Default = 30

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

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

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

254: -- End of Comments
255: --
256: PROCEDURE Get_packlist_lines(
257: P_Api_Version_Number IN NUMBER,
258: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
259: P_identity_salesforce_id IN NUMBER := NULL,
260: P_PLL_Rec IN CSP_packlist_lines_PUB.PLL_Rec_Type,
261: -- Hint: Add list of bind variables here
262: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

260: P_PLL_Rec IN CSP_packlist_lines_PUB.PLL_Rec_Type,
261: -- Hint: Add list of bind variables here
262: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
263: p_start_rec_prt IN NUMBER := 1,
264: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
265: -- Hint: user defined record type
266: p_order_by_rec IN CSP_packlist_lines_PUB.PLL_sort_rec_type,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,