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.INV_LABEL_PVT4 dependencies on INV_LABEL

Line 1: PACKAGE BODY INV_LABEL_PVT4 AS

1: PACKAGE BODY INV_LABEL_PVT4 AS
2: /* $Header: INVLAP4B.pls 120.34.12010000.4 2008/10/17 07:14:19 abaid ship $ */
3:
4: LABEL_B CONSTANT VARCHAR2(50) := ' 5: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);

Line 12: G_DATE_FORMAT_MASK VARCHAR2(100) := INV_LABEL.G_DATE_FORMAT_MASK;

8: TAG_E CONSTANT VARCHAR2(50) := '>'||fnd_global.local_chr(10);
9: l_debug number;
10:
11: -- Bug 2795525 : This mask is used to mask all date fields.
12: G_DATE_FORMAT_MASK VARCHAR2(100) := INV_LABEL.G_DATE_FORMAT_MASK;
13:
14: PROCEDURE trace(p_message IN VARCHAR2) iS
15: BEGIN
16: inv_label.trace(p_message, 'LABEL_LPN_CONT');

Line 16: inv_label.trace(p_message, 'LABEL_LPN_CONT');

12: G_DATE_FORMAT_MASK VARCHAR2(100) := INV_LABEL.G_DATE_FORMAT_MASK;
13:
14: PROCEDURE trace(p_message IN VARCHAR2) iS
15: BEGIN
16: inv_label.trace(p_message, 'LABEL_LPN_CONT');
17: END trace;
18:
19: PROCEDURE get_variable_data(
20: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type

Line 20: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type

16: inv_label.trace(p_message, 'LABEL_LPN_CONT');
17: END trace;
18:
19: PROCEDURE get_variable_data(
20: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
21: , x_msg_count OUT NOCOPY NUMBER
22: , x_msg_data OUT NOCOPY VARCHAR2
23: , x_return_status OUT NOCOPY VARCHAR2
24: , x_var_content IN LONG DEFAULT NULL

Line 25: , p_label_type_info IN INV_LABEL.label_type_rec

21: , x_msg_count OUT NOCOPY NUMBER
22: , x_msg_data OUT NOCOPY VARCHAR2
23: , x_return_status OUT NOCOPY VARCHAR2
24: , x_var_content IN LONG DEFAULT NULL
25: , p_label_type_info IN INV_LABEL.label_type_rec
26: , p_transaction_id IN NUMBER
27: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
28: , p_transaction_identifier IN NUMBER
29: ) IS

Line 1145: l_child_lpn_summary INV_LABEL.label_tbl_type;

1141: l_purchase_order PO_HEADERS_ALL.SEGMENT1%TYPE;
1142:
1143: l_content_item_data LONG;
1144: --l_child_lpn_summary LONG;
1145: l_child_lpn_summary INV_LABEL.label_tbl_type;
1146:
1147: l_selected_fields INV_LABEL.label_field_variable_tbl_type;
1148: l_selected_fields_count NUMBER;
1149:

Line 1147: l_selected_fields INV_LABEL.label_field_variable_tbl_type;

1143: l_content_item_data LONG;
1144: --l_child_lpn_summary LONG;
1145: l_child_lpn_summary INV_LABEL.label_tbl_type;
1146:
1147: l_selected_fields INV_LABEL.label_field_variable_tbl_type;
1148: l_selected_fields_count NUMBER;
1149:
1150: l_rcv_lpn_table rcv_label_tbl_type; -- Table of LPN-level info : J-DEV
1151: l_rlpn_ndx NUMBER := 0; -- Index to table of records for RCV LPN

Line 1167: l_label_type_child_lpn INV_LABEL.label_type_rec;

1163: l_msg_count NUMBER;
1164: l_api_status VARCHAR2(240);
1165: l_msg_data VARCHAR2(240);
1166:
1167: l_label_type_child_lpn INV_LABEL.label_type_rec;
1168: i NUMBER;
1169:
1170: l_summary_format_id NUMBER;
1171: l_summary_format VARCHAR2(240);

Line 1173: l_lpn_table inv_label.lpn_table_type;

1169:
1170: l_summary_format_id NUMBER;
1171: l_summary_format VARCHAR2(240);
1172:
1173: l_lpn_table inv_label.lpn_table_type;
1174:
1175: -- Added for bug 2084791.
1176: -- l_item_id_table inv_label.item_table_type;
1177: -- l_quantity_table inv_label.quantity_table_type;

Line 1176: -- l_item_id_table inv_label.item_table_type;

1172:
1173: l_lpn_table inv_label.lpn_table_type;
1174:
1175: -- Added for bug 2084791.
1176: -- l_item_id_table inv_label.item_table_type;
1177: -- l_quantity_table inv_label.quantity_table_type;
1178: -- End of bug 2084791 addition.
1179:
1180: l_lpn_table_index NUMBER;

Line 1177: -- l_quantity_table inv_label.quantity_table_type;

1173: l_lpn_table inv_label.lpn_table_type;
1174:
1175: -- Added for bug 2084791.
1176: -- l_item_id_table inv_label.item_table_type;
1177: -- l_quantity_table inv_label.quantity_table_type;
1178: -- End of bug 2084791 addition.
1179:
1180: l_lpn_table_index NUMBER;
1181:

Line 1275: l_debug := INV_LABEL.l_debug;

1271: -- package before its finally packed into the parent_lpn_id, the parent_lpn on the Content label
1272: -- should not be populated but the parent_package_id should be populated since we display the immediate
1273: -- parent of the current level.
1274:
1275: l_debug := INV_LABEL.l_debug;
1276:
1277: IF (l_debug = 1) THEN
1278: trace('**In PVT4: LPN Content label**');
1279: trace(' Business_flow='||p_label_type_info.business_flow_code ||

Line 1304: IF ( p_transaction_identifier = INV_LABEL.TRX_ID_RT) OR l_patch_level = 1 THEN

1300: i := 1;
1301:
1302: IF p_label_type_info.business_flow_code in (1,2,3,4) THEN
1303: -- Receipt, Inspection, Delivery, Putaway
1304: IF ( p_transaction_identifier = INV_LABEL.TRX_ID_RT) OR l_patch_level = 1 THEN
1305: -- New Architecture : Get LPN from RT :J-DEV
1306: -- Applicable with DM.J and IProc.J
1307: IF l_debug = 1 THEN
1308: trace(' transaction_identifier is ' || p_transaction_identifier);

Line 1395: END IF; -- p_transaction_identifier = INV_LABEL.TRX_ID_RT

1391: l_note_to_receiver := v_rti_lpn.note_to_receiver;
1392: i := i+1;
1393: END LOOP;
1394: END IF; -- p_label_type_info.business_flow_code = 2
1395: END IF; -- p_transaction_identifier = INV_LABEL.TRX_ID_RT
1396: ELSIF p_label_type_info.business_flow_code in (6) THEN
1397: -- Cross-Dock, Pick Load and Pick Drop
1398: -- The delivery_detail_id of the line in WDD which has the LPN_ID
1399: -- is passed , get lpn_id from WDD lines

Line 1424: ELSIF p_label_type_info.business_flow_code = INV_LABEL.WMS_BF_IMPORT_ASN THEN

1420: i := i+1;
1421: cartonization_flag := 0;
1422: END LOOP;
1423:
1424: ELSIF p_label_type_info.business_flow_code = INV_LABEL.WMS_BF_IMPORT_ASN THEN
1425: IF ( p_transaction_identifier = INV_LABEL.TRX_ID_RSH) THEN
1426: -- New Architecture for ASN : Get LPN details from RSH :J-DEV
1427: -- Applicable with DM.J and IProc.J
1428: -- First retrieve the header level info

Line 1425: IF ( p_transaction_identifier = INV_LABEL.TRX_ID_RSH) THEN

1421: cartonization_flag := 0;
1422: END LOOP;
1423:
1424: ELSIF p_label_type_info.business_flow_code = INV_LABEL.WMS_BF_IMPORT_ASN THEN
1425: IF ( p_transaction_identifier = INV_LABEL.TRX_ID_RSH) THEN
1426: -- New Architecture for ASN : Get LPN details from RSH :J-DEV
1427: -- Applicable with DM.J and IProc.J
1428: -- First retrieve the header level info
1429: SELECT shipment_num asn_num, shipped_date shipment_date,

Line 2245: INV_LABEL.GET_FORMAT_WITH_RULE

2241: from wms_label_request will be deleted inside following API*/
2242:
2243:
2244:
2245: INV_LABEL.GET_FORMAT_WITH_RULE
2246: ( p_document_id =>p_label_type_info.label_type_id,
2247: P_LABEL_FORMAT_ID =>p_label_type_info.manual_format_id,
2248: p_organization_id =>v_lpn_content.organization_id,
2249: p_inventory_item_id =>v_lpn_content.inventory_item_id,

Line 2325: INV_LABEL.GET_FORMAT_WITH_RULE

2321: --In R12 call this API for the format AGAIN without calling Rules ENGINE
2322: /* insert a record into wms_label_requests entity */
2323:
2324:
2325: INV_LABEL.GET_FORMAT_WITH_RULE
2326: ( p_document_id =>p_label_type_info.label_type_id,
2327: P_LABEL_FORMAT_ID =>l_label_formats_in_set.label_format_id, --considers manual printer also
2328: p_organization_id =>v_lpn_content.organization_id,
2329: p_inventory_item_id =>v_lpn_content.inventory_item_id,

Line 2431: INV_LABEL.GET_VARIABLES_FOR_FORMAT(

2427: * table to get RFID related information
2428: * Otherwise, it does not need to do that
2429: */
2430:
2431: INV_LABEL.GET_VARIABLES_FOR_FORMAT(
2432: x_variables => l_selected_fields
2433: , x_variables_count => l_selected_fields_count
2434: , x_is_variable_exist => l_is_epc_exist
2435: , p_format_id => l_label_format_id

Line 2461: INV_LABEL.IS_ITEM_GTIN_ENABLED(

2457: GOTO NextLabel;
2458: END IF;
2459:
2460: -- Added for UCC 128 J Bug #3067059
2461: INV_LABEL.IS_ITEM_GTIN_ENABLED(
2462: x_return_status => l_return_status
2463: , x_gtin_enabled => l_gtin_enabled
2464: , x_gtin => l_gtin
2465: , x_gtin_desc => l_gtin_desc

Line 2498: p_group_id => inv_label.epc_group_id,

2494:
2495: WMS_EPC_PVT.generate_epc
2496: (p_org_id => v_lpn_content.organization_id,
2497: p_label_type_id => p_label_type_info.label_type_id, -- 4
2498: p_group_id => inv_label.epc_group_id,
2499: p_label_format_id => l_label_format_id,
2500: p_label_request_id => l_label_request_id,
2501: p_business_flow_code => p_label_type_info.business_flow_code,
2502: x_epc => l_epc,

Line 2509: trace('l_label_request_id='||l_label_request_id||',p_group_id='||inv_label.epc_group_id);

2505: );
2506:
2507: IF (l_debug = 1) THEN
2508: trace('Called generate_epc with ');
2509: trace('l_label_request_id='||l_label_request_id||',p_group_id='||inv_label.epc_group_id);
2510: trace('l_label_format_id='||l_label_format_id||',p_user_id='||fnd_global.user_id);
2511: trace('business_flow_code='||p_label_type_info.business_flow_code||',p_org_id='||v_lpn_content.organization_id);
2512: trace('label_type_id='||p_label_type_info.label_type_id);
2513: trace('x_epc='||l_epc);

Line 2565: l_label_status := INV_LABEL.G_SUCCESS;

2561: END IF;
2562: END IF;
2563:
2564: /* variable header */
2565: l_label_status := INV_LABEL.G_SUCCESS;
2566: l_label_err_msg := NULL;
2567: l_content_item_data := l_content_item_data || LABEL_B;
2568: IF l_label_format <> nvl(p_label_type_info.default_format_name, '@@@') THEN
2569: l_content_item_data := l_content_item_data || ' _FORMAT="' ||l_label_format || '"';

Line 2633: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

2629: END LOOP;
2630:
2631: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2634: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2635: fnd_msg_pub.ADD;
2636: -- Fix for bug: 4179593 Start
2637: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

Line 2654: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

2650: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 3');
2651: trace('Custom Labels Trace [INVLAP4B.pls]: WARNING: No row returned by the Custom SQL query');
2652: END IF;
2653: x_return_status := FND_API.G_RET_STS_SUCCESS;
2654: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2655: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2656: fnd_msg_pub.ADD;
2657: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2658: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/

Line 2722: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;

2718: END IF;
2719: ------------------------End of this changes for Custom Labels project code--------------------
2720: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
2721: l_content_item_data := l_content_item_data || VARIABLE_B ||
2722: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
2723: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
2724: l_content_item_data := l_content_item_data || VARIABLE_B ||
2725: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
2726: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN

Line 2725: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;

2721: l_content_item_data := l_content_item_data || VARIABLE_B ||
2722: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
2723: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
2724: l_content_item_data := l_content_item_data || VARIABLE_B ||
2725: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
2726: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
2727: l_content_item_data := l_content_item_data || VARIABLE_B ||
2728: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
2729: ELSIF LOWER(l_selected_fields(i).column_name) = 'lpn' THEN

Line 2728: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;

2724: l_content_item_data := l_content_item_data || VARIABLE_B ||
2725: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
2726: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
2727: l_content_item_data := l_content_item_data || VARIABLE_B ||
2728: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
2729: ELSIF LOWER(l_selected_fields(i).column_name) = 'lpn' THEN
2730: l_content_item_data := l_content_item_data || VARIABLE_B ||
2731: l_selected_fields(i).variable_name || '">' || l_lpn_info.lpn || VARIABLE_E;
2732: ELSIF LOWER(l_selected_fields(i).column_name) = 'parent_lpn' THEN

Line 3309: l_label_status := INV_LABEL.G_ERROR;

3305: l_content_item_data := l_content_item_data || variable_b ||
3306: l_selected_fields(i).variable_name || '">' || l_epc || variable_e;
3307: l_label_err_msg := l_epc_ret_msg;
3308: IF l_epc_ret_status = 'U' THEN
3309: l_label_status := INV_LABEL.G_ERROR;
3310: ELSIF l_epc_ret_status = 'E' THEN
3311: l_label_status := INV_LABEL.G_WARNING;
3312:
3313: END IF;

Line 3311: l_label_status := INV_LABEL.G_WARNING;

3307: l_label_err_msg := l_epc_ret_msg;
3308: IF l_epc_ret_status = 'U' THEN
3309: l_label_status := INV_LABEL.G_ERROR;
3310: ELSIF l_epc_ret_status = 'E' THEN
3311: l_label_status := INV_LABEL.G_WARNING;
3312:
3313: END IF;
3314: -- INVCONV changes start
3315:

Line 3373: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3369: ------------------------Start of changes for Custom Labels project code------------------
3370:
3371: -- Fix for bug: 4179593 Start
3372: IF (l_CustSqlWarnFlagSet) THEN
3373: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3374: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3375: END IF;
3376:
3377: IF (l_CustSqlErrFlagSet) THEN

Line 3487: INV_LABEL.GET_DEFAULT_FORMAT

3483: -- get default format
3484: l_summary_format_id := null;
3485: l_summary_format := null;
3486:
3487: INV_LABEL.GET_DEFAULT_FORMAT
3488: (p_label_type_id => 5,
3489: p_label_format => l_summary_format,
3490: p_label_format_id => l_summary_format_id);
3491: IF l_summary_format_id IS NOT NULL THEN

Line 3516: trace('calling inv_label_pvt5 with lpn_id ' || v_child_lpn.lpn_id);

3512: l_label_type_child_lpn.default_no_of_copies := p_label_type_info.default_no_of_copies;
3513:
3514: FOR v_child_lpn IN c_child_lpns(l_lpn_id) LOOP
3515: IF l_debug = 1 THEN
3516: trace('calling inv_label_pvt5 with lpn_id ' || v_child_lpn.lpn_id);
3517: END IF;
3518: INV_LABEL_PVT5.get_variable_data(
3519: x_variable_content => l_child_lpn_summary
3520: , x_msg_count => l_msg_count

Line 3518: INV_LABEL_PVT5.get_variable_data(

3514: FOR v_child_lpn IN c_child_lpns(l_lpn_id) LOOP
3515: IF l_debug = 1 THEN
3516: trace('calling inv_label_pvt5 with lpn_id ' || v_child_lpn.lpn_id);
3517: END IF;
3518: INV_LABEL_PVT5.get_variable_data(
3519: x_variable_content => l_child_lpn_summary
3520: , x_msg_count => l_msg_count
3521: , x_msg_data => l_msg_data
3522: , x_return_status => l_return_status

Line 3541: g_req_cnt := inv_label.g_label_request_tbl.count();

3537: x_variable_content(l_label_index).label_content := l_child_lpn_summary(i).label_content;
3538: x_variable_content(l_label_index).label_request_id := l_child_lpn_summary(i).label_request_id;
3539: x_variable_content(l_label_index).label_status := l_child_lpn_summary(i).label_status;
3540: x_variable_content(l_label_index).error_message := l_child_lpn_summary(i).error_message;
3541: g_req_cnt := inv_label.g_label_request_tbl.count();
3542: IF l_debug = 1 THEN
3543: trace('g_req_cnt ' || g_req_cnt);
3544: END IF;
3545: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;

Line 3545: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;

3541: g_req_cnt := inv_label.g_label_request_tbl.count();
3542: IF l_debug = 1 THEN
3543: trace('g_req_cnt ' || g_req_cnt);
3544: END IF;
3545: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;
3546: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;
3547: IF l_debug = 1 THEN
3548: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);
3549: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);

Line 3546: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;

3542: IF l_debug = 1 THEN
3543: trace('g_req_cnt ' || g_req_cnt);
3544: END IF;
3545: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;
3546: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;
3547: IF l_debug = 1 THEN
3548: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);
3549: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);
3550: END IF;

Line 3548: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);

3544: END IF;
3545: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;
3546: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;
3547: IF l_debug = 1 THEN
3548: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);
3549: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);
3550: END IF;
3551:
3552: l_label_index := l_label_index + 1;

Line 3549: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);

3545: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;
3546: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;
3547: IF l_debug = 1 THEN
3548: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);
3549: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);
3550: END IF;
3551:
3552: l_label_index := l_label_index + 1;
3553: END LOOP;

Line 3739: , p_label_type_info IN INV_LABEL.label_type_rec

3735: , x_msg_count OUT NOCOPY NUMBER
3736: , x_msg_data OUT NOCOPY VARCHAR2
3737: , x_return_status OUT NOCOPY VARCHAR2
3738: , x_var_content IN LONG DEFAULT NULL
3739: , p_label_type_info IN INV_LABEL.label_type_rec
3740: , p_transaction_id IN NUMBER
3741: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
3742: , p_transaction_identifier IN NUMBER
3743: ) IS

Line 3744: l_variable_data_tbl INV_LABEL.label_tbl_type;

3740: , p_transaction_id IN NUMBER
3741: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
3742: , p_transaction_identifier IN NUMBER
3743: ) IS
3744: l_variable_data_tbl INV_LABEL.label_tbl_type;
3745: BEGIN
3746: get_variable_data(
3747: x_variable_content => l_variable_data_tbl
3748: , x_msg_count => x_msg_count

Line 3766: END INV_LABEL_PVT4;

3762: END LOOP;
3763:
3764: END get_variable_data;
3765:
3766: END INV_LABEL_PVT4;