DBA Data[Home] [Help]

APPS.INV_LABEL_PVT9 dependencies on INV_LABEL

Line 1: PACKAGE BODY inv_label_pvt9 AS

1: PACKAGE BODY inv_label_pvt9 AS
2: /* $Header: INVLAP9B.pls 120.8.12010000.2 2008/07/29 13:41:16 ptkumar ship $ */
3: label_b CONSTANT VARCHAR2(50) := ' 4: label_e CONSTANT VARCHAR2(50) := '' || fnd_global.local_chr(10);
5: variable_b CONSTANT VARCHAR2(50) := '' || inv_label.g_date || variable_e;

1398: END IF;
1399: ------------------------End of this change for Custom Labels project code--------------------
1400: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
1401: l_content_item_data :=
1402: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_date || variable_e;
1403: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
1404: l_content_item_data :=
1405: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
1406: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN

Line 1405: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;

1401: l_content_item_data :=
1402: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_date || variable_e;
1403: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
1404: l_content_item_data :=
1405: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
1406: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
1407: l_content_item_data :=
1408: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;
1409: ELSIF LOWER(l_selected_fields(i).column_name) = 'job_schedule_type' THEN

Line 1408: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;

1404: l_content_item_data :=
1405: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
1406: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
1407: l_content_item_data :=
1408: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;
1409: ELSIF LOWER(l_selected_fields(i).column_name) = 'job_schedule_type' THEN
1410: l_content_item_data :=
1411: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_content.job_schedule_type
1412: || variable_e;

Line 2734: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

2730:
2731: ------------------------Start of changes for Custom Labels project code------------------
2732: -- Fix for bug: 4179593 Start
2733: IF (l_CustSqlWarnFlagSet) THEN
2734: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2735: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
2736: END IF;
2737:
2738: IF (l_CustSqlErrFlagSet) THEN

Line 2861: , p_label_type_info IN inv_label.label_type_rec

2857: x_variable_content OUT NOCOPY LONG
2858: , x_msg_count OUT NOCOPY NUMBER
2859: , x_msg_data OUT NOCOPY VARCHAR2
2860: , x_return_status OUT NOCOPY VARCHAR2
2861: , p_label_type_info IN inv_label.label_type_rec
2862: , p_transaction_id IN NUMBER
2863: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
2864: , p_transaction_identifier IN NUMBER
2865: ) IS

Line 2866: l_variable_data_tbl inv_label.label_tbl_type;

2862: , p_transaction_id IN NUMBER
2863: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
2864: , p_transaction_identifier IN NUMBER
2865: ) IS
2866: l_variable_data_tbl inv_label.label_tbl_type;
2867: BEGIN
2868: get_variable_data(
2869: x_variable_content => l_variable_data_tbl
2870: , x_msg_count => x_msg_count

Line 2884: END inv_label_pvt9;

2880: FOR i IN 1 .. l_variable_data_tbl.COUNT() LOOP
2881: x_variable_content := x_variable_content || l_variable_data_tbl(i).label_content;
2882: END LOOP;
2883: END get_variable_data;
2884: END inv_label_pvt9;