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_PICKLIST_LINES_PVT dependencies on FND_API

Line 58: picklist_line_id NUMBER := FND_API.G_MISS_NUM,

54: -- End of Comments
55:
56: TYPE picklist_line_Rec_Type IS RECORD
57: (
58: picklist_line_id NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

55:
56: TYPE picklist_line_Rec_Type IS RECORD
57: (
58: picklist_line_id NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 60: CREATION_DATE DATE := FND_API.G_MISS_DATE,

56: TYPE picklist_line_Rec_Type IS RECORD
57: (
58: picklist_line_id NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,

Line 61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

57: (
58: picklist_line_id NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,

Line 62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

58: picklist_line_id NUMBER := FND_API.G_MISS_NUM,
59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66: LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

59: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66: LINE_ID NUMBER := FND_API.G_MISS_NUM,
67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

Line 64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,

60: CREATION_DATE DATE := FND_API.G_MISS_DATE,
61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66: LINE_ID NUMBER := FND_API.G_MISS_NUM,
67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,

61: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66: LINE_ID NUMBER := FND_API.G_MISS_NUM,
67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 66: LINE_ID NUMBER := FND_API.G_MISS_NUM,

62: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66: LINE_ID NUMBER := FND_API.G_MISS_NUM,
67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,

Line 67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

63: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66: LINE_ID NUMBER := FND_API.G_MISS_NUM,
67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,

Line 68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,

64: PICKLIST_LINE_NUMBER NUMBER := FND_API.G_MISS_NUM,
65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66: LINE_ID NUMBER := FND_API.G_MISS_NUM,
67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,

65: picklist_header_id NUMBER := FND_API.G_MISS_NUM,
66: LINE_ID NUMBER := FND_API.G_MISS_NUM,
67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,

66: LINE_ID NUMBER := FND_API.G_MISS_NUM,
67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,

67: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

68: UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

69: REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

70: QUANTITY_PICKED NUMBER := FND_API.G_MISS_NUM,
71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

71: TRANSACTION_TEMP_ID NUMBER := FND_API.G_MISS_NUM,
72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

72: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

73: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

74: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

75: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

76: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

77: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

78: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

79: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

80: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: );

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

81: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: );
89:

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

82: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: );
89:
90: G_MISS_picklist_line_REC picklist_line_Rec_Type;

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

83: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: );
89:
90: G_MISS_picklist_line_REC picklist_line_Rec_Type;
91: TYPE picklist_line_Tbl_Type IS TABLE OF picklist_line_Rec_Type

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

100: -- Pre-Req :
101: -- Parameters:
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
108: --

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

101: -- Parameters:
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
108: --
109: -- OUT:

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

102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
108: --
109: -- OUT:
110: -- x_return_status OUT NOCOPY VARCHAR2

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

117: -- End of Comments
118: --
119: PROCEDURE Create_picklist_lines(
120: P_Api_Version_Number IN NUMBER,
121: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: P_picklist_line_Rec IN picklist_line_Rec_Type := G_MISS_picklist_line_REC,
125: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

118: --
119: PROCEDURE Create_picklist_lines(
120: P_Api_Version_Number IN NUMBER,
121: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: P_picklist_line_Rec IN picklist_line_Rec_Type := G_MISS_picklist_line_REC,
125: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
126: X_picklist_line_id OUT NOCOPY NUMBER,

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

119: PROCEDURE Create_picklist_lines(
120: P_Api_Version_Number IN NUMBER,
121: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: P_picklist_line_Rec IN picklist_line_Rec_Type := G_MISS_picklist_line_REC,
125: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
126: X_picklist_line_id OUT NOCOPY NUMBER,
127: X_Return_Status OUT NOCOPY VARCHAR2,

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

137: -- Pre-Req :
138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
145: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required

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

138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
145: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
146: --

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

139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
145: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
146: --
147: -- OUT:

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

156: --
157: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
158: PROCEDURE Update_picklist_lines(
159: P_Api_Version_Number IN NUMBER,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: --P_Identity_Salesforce_Id IN NUMBER := NULL,
164: P_picklist_line_Rec IN picklist_line_Rec_Type,

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

157: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
158: PROCEDURE Update_picklist_lines(
159: P_Api_Version_Number IN NUMBER,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: --P_Identity_Salesforce_Id IN NUMBER := NULL,
164: P_picklist_line_Rec IN picklist_line_Rec_Type,
165: X_Return_Status OUT NOCOPY VARCHAR2,

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

158: PROCEDURE Update_picklist_lines(
159: P_Api_Version_Number IN NUMBER,
160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: --P_Identity_Salesforce_Id IN NUMBER := NULL,
164: P_picklist_line_Rec IN picklist_line_Rec_Type,
165: X_Return_Status OUT NOCOPY VARCHAR2,
166: X_Msg_Count OUT NOCOPY NUMBER,

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

175: -- Pre-Req :
176: -- Parameters:
177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
183: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required

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

176: -- Parameters:
177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
183: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
184: --

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

177: -- IN
178: -- p_api_version_number IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
182: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
183: -- P_picklist_line_Rec IN picklist_line_Rec_Type Required
184: --
185: -- OUT:

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

195: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
196: -- The Master delete procedure may not be needed depends on different business requirements.
197: PROCEDURE Delete_picklist_lines(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: --P_identity_salesforce_id IN NUMBER := NULL,
203: P_picklist_line_Rec IN picklist_line_Rec_Type,

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

196: -- The Master delete procedure may not be needed depends on different business requirements.
197: PROCEDURE Delete_picklist_lines(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: --P_identity_salesforce_id IN NUMBER := NULL,
203: P_picklist_line_Rec IN picklist_line_Rec_Type,
204: X_Return_Status OUT NOCOPY VARCHAR2,

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

197: PROCEDURE Delete_picklist_lines(
198: P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: --P_identity_salesforce_id IN NUMBER := NULL,
203: P_picklist_line_Rec IN picklist_line_Rec_Type,
204: X_Return_Status OUT NOCOPY VARCHAR2,
205: X_Msg_Count OUT NOCOPY NUMBER,

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

217: --
218: -- End of Comments
219:
220: PROCEDURE Validate_picklist_line_id (
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Validation_mode IN VARCHAR2,
223: P_picklist_line_id IN NUMBER,
224: -- 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.
225: X_Return_Status OUT NOCOPY VARCHAR2,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

406: -- 2. Developer can manually added inter-field level validation.
407: -- End of Comments
408:
409: PROCEDURE Validate_picklist_line_rec(
410: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
411: P_Validation_mode IN VARCHAR2,
412: P_picklist_line_Rec IN picklist_line_Rec_Type,
413: X_Return_Status OUT NOCOPY VARCHAR2,
414: X_Msg_Count OUT NOCOPY NUMBER,

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

426: -- 2. We can also validate table instead of record. There will be an option for user to choose.
427: -- End of Comments
428:
429: PROCEDURE Validate_picklist_lines(
430: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
431: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: P_Validation_mode IN VARCHAR2,
433: P_picklist_line_Rec IN picklist_line_Rec_Type,
434: X_Return_Status OUT NOCOPY VARCHAR2,

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

427: -- End of Comments
428:
429: PROCEDURE Validate_picklist_lines(
430: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
431: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
432: P_Validation_mode IN VARCHAR2,
433: P_picklist_line_Rec IN picklist_line_Rec_Type,
434: X_Return_Status OUT NOCOPY VARCHAR2,
435: X_Msg_Count OUT NOCOPY NUMBER,