DBA Data[Home] [Help]

APPS.WMS_EPC_PVT dependencies on WMS_LABEL_REQUESTS

Line 2195: p_txn_uom : need TO pass fpr Material Label: 1 only (since uom is not in wms_label_requests table)

2191: p_group_id : groun_id per invocation
2192: p_label_format_id : label_format_id for this transaction that should have has epc field
2193: p_item_id : need TO pass fpr Material Label: 1 only
2194: p_txn_qty : need TO pass fpr Material Label: 1 only
2195: p_txn_uom : need TO pass fpr Material Label: 1 only (since uom is not in wms_label_requests table)
2196: p_label_request_id: the id from wms_label_requests foe which label will be generated
2197: p_business_flow_code : business flow code value
2198: x_epc : returns generated EPC
2199: x_return_status :-

Line 2196: p_label_request_id: the id from wms_label_requests foe which label will be generated

2192: p_label_format_id : label_format_id for this transaction that should have has epc field
2193: p_item_id : need TO pass fpr Material Label: 1 only
2194: p_txn_qty : need TO pass fpr Material Label: 1 only
2195: p_txn_uom : need TO pass fpr Material Label: 1 only (since uom is not in wms_label_requests table)
2196: p_label_request_id: the id from wms_label_requests foe which label will be generated
2197: p_business_flow_code : business flow code value
2198: x_epc : returns generated EPC
2199: x_return_status :-
2200: S : success : EPC generated E : error : EPC could not be generated for valid reason

Line 2336: FROM wms_label_requests

2332:
2333: --Get required information about the current transaction
2334: SELECT lpn_id,serial_number,inventory_item_id,revision
2335: INTO l_lpn_id,l_serial_number,l_item_id, l_rev
2336: FROM wms_label_requests
2337: WHERE label_request_id = p_label_request_id;
2338:
2339:
2340: IF l_debug = 1 THEN

Line 3712: p_txn_uom : need TO pass fpr Material Label: 1 only (since uom is not in wms_label_requests table)

3708: p_group_id : groun_id per invocation
3709: p_label_format_id : label_format_id for this transaction that should have has epc field
3710: p_item_id : need TO pass fpr Material Label: 1 only
3711: p_txn_qty : need TO pass fpr Material Label: 1 only
3712: p_txn_uom : need TO pass fpr Material Label: 1 only (since uom is not in wms_label_requests table)
3713: p_label_request_id: the id from wms_label_requests foe which label will be generated
3714: p_business_flow_code : business flow code value
3715: x_epc : returns generated EPC
3716: x_return_status :-

Line 3713: p_label_request_id: the id from wms_label_requests foe which label will be generated

3709: p_label_format_id : label_format_id for this transaction that should have has epc field
3710: p_item_id : need TO pass fpr Material Label: 1 only
3711: p_txn_qty : need TO pass fpr Material Label: 1 only
3712: p_txn_uom : need TO pass fpr Material Label: 1 only (since uom is not in wms_label_requests table)
3713: p_label_request_id: the id from wms_label_requests foe which label will be generated
3714: p_business_flow_code : business flow code value
3715: x_epc : returns generated EPC
3716: x_return_status :-
3717: S : success : EPC generated E : error : EPC could not be generated for valid reason

Line 3841: FROM wms_label_requests

3837:
3838: --Get required information about the current transaction
3839: SELECT lpn_id,serial_number,inventory_item_id,revision
3840: INTO l_lpn_id,l_serial_number,l_item_id, l_rev
3841: FROM wms_label_requests
3842: WHERE label_request_id = p_label_request_id;
3843:
3844:
3845: IF l_debug = 1 THEN