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.WSM_LOTATTR_PVT dependencies on INV_LOT_API_PUB

Line 75: l_invattr_tbl inv_lot_api_pub.char_tbl;

71:
72: l_lot_attribute_category varchar2(30):=NULL;
73: l_attribute_category varchar2(30):=NULL;
74: l_description mtl_lot_numbers.description%TYPE:=NULL;
75: l_invattr_tbl inv_lot_api_pub.char_tbl;
76: l_Cattr_tbl inv_lot_api_pub.char_tbl;
77: l_Nattr_tbl inv_lot_api_pub.number_tbl;
78: l_Dattr_tbl inv_lot_api_pub.date_tbl;
79:

Line 76: l_Cattr_tbl inv_lot_api_pub.char_tbl;

72: l_lot_attribute_category varchar2(30):=NULL;
73: l_attribute_category varchar2(30):=NULL;
74: l_description mtl_lot_numbers.description%TYPE:=NULL;
75: l_invattr_tbl inv_lot_api_pub.char_tbl;
76: l_Cattr_tbl inv_lot_api_pub.char_tbl;
77: l_Nattr_tbl inv_lot_api_pub.number_tbl;
78: l_Dattr_tbl inv_lot_api_pub.date_tbl;
79:
80: l_grade_code mtl_lot_numbers.grade_code%TYPE:=NULL;

Line 77: l_Nattr_tbl inv_lot_api_pub.number_tbl;

73: l_attribute_category varchar2(30):=NULL;
74: l_description mtl_lot_numbers.description%TYPE:=NULL;
75: l_invattr_tbl inv_lot_api_pub.char_tbl;
76: l_Cattr_tbl inv_lot_api_pub.char_tbl;
77: l_Nattr_tbl inv_lot_api_pub.number_tbl;
78: l_Dattr_tbl inv_lot_api_pub.date_tbl;
79:
80: l_grade_code mtl_lot_numbers.grade_code%TYPE:=NULL;
81: l_origination_date DATE:=NULL;

Line 78: l_Dattr_tbl inv_lot_api_pub.date_tbl;

74: l_description mtl_lot_numbers.description%TYPE:=NULL;
75: l_invattr_tbl inv_lot_api_pub.char_tbl;
76: l_Cattr_tbl inv_lot_api_pub.char_tbl;
77: l_Nattr_tbl inv_lot_api_pub.number_tbl;
78: l_Dattr_tbl inv_lot_api_pub.date_tbl;
79:
80: l_grade_code mtl_lot_numbers.grade_code%TYPE:=NULL;
81: l_origination_date DATE:=NULL;
82: l_date_code mtl_lot_numbers.date_code%TYPE:=NULL;

Line 108: l_Sinvattr_tbl inv_lot_api_pub.char_tbl;

104: l_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
105: l_status_id number;
106:
107: -- Source lot variables
108: l_Sinvattr_tbl inv_lot_api_pub.char_tbl;
109: l_SCattr_tbl inv_lot_api_pub.char_tbl;
110: l_SNattr_tbl inv_lot_api_pub.number_tbl;
111: l_SDattr_tbl inv_lot_api_pub.date_tbl;
112:

Line 109: l_SCattr_tbl inv_lot_api_pub.char_tbl;

105: l_status_id number;
106:
107: -- Source lot variables
108: l_Sinvattr_tbl inv_lot_api_pub.char_tbl;
109: l_SCattr_tbl inv_lot_api_pub.char_tbl;
110: l_SNattr_tbl inv_lot_api_pub.number_tbl;
111: l_SDattr_tbl inv_lot_api_pub.date_tbl;
112:
113: l_Sgrade_code mtl_lot_numbers.grade_code%TYPE:=NULL;

Line 110: l_SNattr_tbl inv_lot_api_pub.number_tbl;

106:
107: -- Source lot variables
108: l_Sinvattr_tbl inv_lot_api_pub.char_tbl;
109: l_SCattr_tbl inv_lot_api_pub.char_tbl;
110: l_SNattr_tbl inv_lot_api_pub.number_tbl;
111: l_SDattr_tbl inv_lot_api_pub.date_tbl;
112:
113: l_Sgrade_code mtl_lot_numbers.grade_code%TYPE:=NULL;
114: l_Sorigination_date DATE:=NULL;

Line 111: l_SDattr_tbl inv_lot_api_pub.date_tbl;

107: -- Source lot variables
108: l_Sinvattr_tbl inv_lot_api_pub.char_tbl;
109: l_SCattr_tbl inv_lot_api_pub.char_tbl;
110: l_SNattr_tbl inv_lot_api_pub.number_tbl;
111: l_SDattr_tbl inv_lot_api_pub.date_tbl;
112:
113: l_Sgrade_code mtl_lot_numbers.grade_code%TYPE:=NULL;
114: l_Sorigination_date DATE:=NULL;
115: l_Sdate_code mtl_lot_numbers.date_code%TYPE:=NULL;

Line 160: l_temp_Cattr_tbl inv_lot_api_pub.char_tbl;

156: wms_context_index NUMBER;
157:
158: l_temp_lot_attribute_category varchar2(30):=NULL;
159:
160: l_temp_Cattr_tbl inv_lot_api_pub.char_tbl;
161: l_temp_Nattr_tbl inv_lot_api_pub.number_tbl;
162: l_temp_Dattr_tbl inv_lot_api_pub.date_tbl;
163:
164: l_temp_description mtl_lot_numbers.description%type:=null;

Line 161: l_temp_Nattr_tbl inv_lot_api_pub.number_tbl;

157:
158: l_temp_lot_attribute_category varchar2(30):=NULL;
159:
160: l_temp_Cattr_tbl inv_lot_api_pub.char_tbl;
161: l_temp_Nattr_tbl inv_lot_api_pub.number_tbl;
162: l_temp_Dattr_tbl inv_lot_api_pub.date_tbl;
163:
164: l_temp_description mtl_lot_numbers.description%type:=null;
165: l_temp_grade_code mtl_lot_numbers.grade_code%type:=null;

Line 162: l_temp_Dattr_tbl inv_lot_api_pub.date_tbl;

158: l_temp_lot_attribute_category varchar2(30):=NULL;
159:
160: l_temp_Cattr_tbl inv_lot_api_pub.char_tbl;
161: l_temp_Nattr_tbl inv_lot_api_pub.number_tbl;
162: l_temp_Dattr_tbl inv_lot_api_pub.date_tbl;
163:
164: l_temp_description mtl_lot_numbers.description%type:=null;
165: l_temp_grade_code mtl_lot_numbers.grade_code%type:=null;
166: l_temp_origination_date date:=null;

Line 1092: pdebug('Before Calling inv_lot_api_pub.Update_inv_lot lot attrcat ' ||

1088: if l_call_inv_lotapi THEN
1089: if x_lot_exists='Y' THEN
1090: if g_debug then
1091: pdebug('x_lot_exists=Y');
1092: pdebug('Before Calling inv_lot_api_pub.Update_inv_lot lot attrcat ' ||
1093: l_lot_attribute_category ||
1094: ' attr_category='|| l_attribute_category);
1095: end if;
1096: inv_lot_api_pub.Update_inv_lot(

Line 1096: inv_lot_api_pub.Update_inv_lot(

1092: pdebug('Before Calling inv_lot_api_pub.Update_inv_lot lot attrcat ' ||
1093: l_lot_attribute_category ||
1094: ' attr_category='|| l_attribute_category);
1095: end if;
1096: inv_lot_api_pub.Update_inv_lot(
1097: x_return_status => x_return_status,
1098: x_msg_count => x_msg_count,
1099: x_msg_data => x_err_msg,
1100: p_inventory_item_id => p_inv_item_id,

Line 1139: pdebug('Before Calling inv_lot_api_pub.Update_inv_lot lot attrcat ' ||

1135: p_source => 2);
1136: ELSE -- x_lot_exists='N'
1137: if g_debug then
1138: pdebug('x_lot_exists=N');
1139: pdebug('Before Calling inv_lot_api_pub.Update_inv_lot lot attrcat ' ||
1140: l_lot_attribute_category ||
1141: 'attr_category=' || l_attribute_category);
1142: end if;
1143: inv_lot_api_pub.create_inv_lot(

Line 1143: inv_lot_api_pub.create_inv_lot(

1139: pdebug('Before Calling inv_lot_api_pub.Update_inv_lot lot attrcat ' ||
1140: l_lot_attribute_category ||
1141: 'attr_category=' || l_attribute_category);
1142: end if;
1143: inv_lot_api_pub.create_inv_lot(
1144: x_return_status => x_return_status,
1145: x_msg_count => x_msg_count,
1146: x_msg_data => x_err_msg,
1147: p_inventory_item_id => p_inv_item_id,