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

Line 41: ROW_ID ROWID := FND_API.G_MISS_CHAR,

37: -- End of Comments
38:
39: TYPE psl_Rec_Type IS RECORD
40: (
41: ROW_ID ROWID := FND_API.G_MISS_CHAR,
42: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 42: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,

38:
39: TYPE psl_Rec_Type IS RECORD
40: (
41: ROW_ID ROWID := FND_API.G_MISS_CHAR,
42: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

39: TYPE psl_Rec_Type IS RECORD
40: (
41: ROW_ID ROWID := FND_API.G_MISS_CHAR,
42: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 44: CREATION_DATE DATE := FND_API.G_MISS_DATE,

40: (
41: ROW_ID ROWID := FND_API.G_MISS_CHAR,
42: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

41: ROW_ID ROWID := FND_API.G_MISS_CHAR,
42: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

42: PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

Line 47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

43: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
51: QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,

44: CREATION_DATE DATE := FND_API.G_MISS_DATE,
45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
51: QUANTITY NUMBER := FND_API.G_MISS_NUM,
52: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

45: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
51: QUANTITY NUMBER := FND_API.G_MISS_NUM,
52: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
53: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

46: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
51: QUANTITY NUMBER := FND_API.G_MISS_NUM,
52: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
53: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
54: );

Line 51: QUANTITY NUMBER := FND_API.G_MISS_NUM,

47: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
51: QUANTITY NUMBER := FND_API.G_MISS_NUM,
52: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
53: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
54: );
55:

Line 52: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,

48: PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
51: QUANTITY NUMBER := FND_API.G_MISS_NUM,
52: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
53: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
54: );
55:
56: G_MISS_psl_REC psl_Rec_Type;

Line 53: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR

49: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
51: QUANTITY NUMBER := FND_API.G_MISS_NUM,
52: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
53: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
54: );
55:
56: G_MISS_psl_REC psl_Rec_Type;
57: TYPE psl_Tbl_Type IS TABLE OF psl_Rec_Type

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

72: -- Pre-Req :
73: -- Parameters:
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- P_psl_Rec IN psl_Rec_Type Required
79: --
80: -- OUT:

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

73: -- Parameters:
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- P_psl_Rec IN psl_Rec_Type Required
79: --
80: -- OUT:
81: -- x_return_status OUT NOCOPY VARCHAR2

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

88: -- End of Comments
89: --
90: PROCEDURE Create_pick_serial_lots(
91: P_Api_Version_Number IN NUMBER,
92: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
93: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
94: P_psl_Rec IN psl_Rec_Type := G_MISS_psl_REC,
95: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
96: X_PICKLIST_SERIAL_LOT_ID OUT NOCOPY NUMBER,

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

89: --
90: PROCEDURE Create_pick_serial_lots(
91: P_Api_Version_Number IN NUMBER,
92: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
93: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
94: P_psl_Rec IN psl_Rec_Type := G_MISS_psl_REC,
95: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
96: X_PICKLIST_SERIAL_LOT_ID OUT NOCOPY NUMBER,
97: X_Return_Status OUT NOCOPY VARCHAR2,

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

107: -- Pre-Req :
108: -- Parameters:
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
114: -- P_psl_Rec IN psl_Rec_Type Required
115: --

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

108: -- Parameters:
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
114: -- P_psl_Rec IN psl_Rec_Type Required
115: --
116: -- OUT:

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

125: --
126: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
127: PROCEDURE Update_pick_serial_lots(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: P_Identity_Salesforce_Id IN NUMBER := NULL,
132: P_psl_Rec IN psl_Rec_Type,
133: X_Return_Status OUT NOCOPY VARCHAR2,

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

126: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
127: PROCEDURE Update_pick_serial_lots(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: P_Identity_Salesforce_Id IN NUMBER := NULL,
132: P_psl_Rec IN psl_Rec_Type,
133: X_Return_Status OUT NOCOPY VARCHAR2,
134: X_Msg_Count OUT NOCOPY NUMBER,

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

143: -- Pre-Req :
144: -- Parameters:
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150: -- P_psl_Rec IN psl_Rec_Type Required
151: --

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

144: -- Parameters:
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150: -- P_psl_Rec IN psl_Rec_Type Required
151: --
152: -- OUT:

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

162: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
163: -- The Master delete procedure may not be needed depends on different business requirements.
164: PROCEDURE Delete_pick_serial_lots(
165: P_Api_Version_Number IN NUMBER,
166: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
167: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
168: P_identity_salesforce_id IN NUMBER := NULL,
169: P_psl_Rec IN psl_Rec_Type,
170: X_Return_Status OUT NOCOPY VARCHAR2,

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

163: -- The Master delete procedure may not be needed depends on different business requirements.
164: PROCEDURE Delete_pick_serial_lots(
165: P_Api_Version_Number IN NUMBER,
166: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
167: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
168: P_identity_salesforce_id IN NUMBER := NULL,
169: P_psl_Rec IN psl_Rec_Type,
170: X_Return_Status OUT NOCOPY VARCHAR2,
171: X_Msg_Count OUT NOCOPY NUMBER,

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

180: -- Pre-Req :
181: -- Parameters:
182: -- IN
183: -- p_api_version_number IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
186: -- P_psl_Rec IN psl_Rec_Type Required
187: -- Hint: Add List of bind variables here
188: -- p_rec_requested IN NUMBER Optional Default = 30

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

190: --
191: -- Return Total Records Count Flag. This flag controls whether the total record count
192: -- and total record amount is returned.
193: --
194: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
195: -- Hint: User defined record type
196: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
197: --
198: -- OUT:

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

212: -- End of Comments
213: --
214: PROCEDURE Get_pick_serial_lots(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_identity_salesforce_id IN NUMBER := NULL,
218: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,
219: -- Hint: Add list of bind variables here
220: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

218: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,
219: -- Hint: Add list of bind variables here
220: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
221: p_start_rec_prt IN NUMBER := 1,
222: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
223: -- Hint: user defined record type
224: p_order_by_rec IN csp_pick_serial_lots_PUB.psl_sort_rec_type,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,