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.QA_SOLUTION_DISPOSITION_PKG dependencies on QA_FLEX_UTIL

Line 242: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

238:
239: -- Update the Disposition Status to 'Pending'.
240: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
241:
242: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
243: l_bill_id := qa_flex_util.get_item_id(l_organization_id, p_bill_reference);
244: l_routing_id := qa_flex_util.get_item_id(l_organization_id, p_routing_reference);
245:
246:

Line 243: l_bill_id := qa_flex_util.get_item_id(l_organization_id, p_bill_reference);

239: -- Update the Disposition Status to 'Pending'.
240: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
241:
242: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
243: l_bill_id := qa_flex_util.get_item_id(l_organization_id, p_bill_reference);
244: l_routing_id := qa_flex_util.get_item_id(l_organization_id, p_routing_reference);
245:
246:
247: -- Call the rework_int(). It returns back the concurrent request

Line 244: l_routing_id := qa_flex_util.get_item_id(l_organization_id, p_routing_reference);

240: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
241:
242: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
243: l_bill_id := qa_flex_util.get_item_id(l_organization_id, p_bill_reference);
244: l_routing_id := qa_flex_util.get_item_id(l_organization_id, p_routing_reference);
245:
246:
247: -- Call the rework_int(). It returns back the concurrent request
248: -- id of the WIP Mass Load Program that gets spawned.

Line 682: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

678: -- We may need to populate appropriate error message here before return.
679: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
683:
684: -- Get transaction_id and lookup code for the Intraoperation step.
685:
686: l_to_step := get_mfg_lookups_value(p_to_intra_step,'WIP_INTRAOPERATION_STEP');

Line 1140: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

1136: l_transaction_date := qltdate.any_to_date(p_transaction_date);
1137: END IF;
1138:
1139: -- Get the Inventory Item ID and Locator ID.
1140: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1141: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);
1142:
1143: -- Get the Disposition ID.
1144: OPEN disp;

Line 1141: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);

1137: END IF;
1138:
1139: -- Get the Inventory Item ID and Locator ID.
1140: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1141: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);
1142:
1143: -- Get the Disposition ID.
1144: OPEN disp;
1145: FETCH disp INTO l_disposition_id;

Line 1587: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

1583:
1584: -- Update the Disposition Status to 'Pending'.
1585: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
1586:
1587: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1588: l_from_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_from_locator);
1589: l_to_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_to_locator);
1590:
1591: l_project_id := qa_flex_util.get_project_id(p_project_number);

Line 1588: l_from_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_from_locator);

1584: -- Update the Disposition Status to 'Pending'.
1585: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
1586:
1587: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1588: l_from_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_from_locator);
1589: l_to_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_to_locator);
1590:
1591: l_project_id := qa_flex_util.get_project_id(p_project_number);
1592: l_task_id := qa_flex_util.get_task_id(l_project_id,p_task_number);

Line 1589: l_to_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_to_locator);

1585: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
1586:
1587: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1588: l_from_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_from_locator);
1589: l_to_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_to_locator);
1590:
1591: l_project_id := qa_flex_util.get_project_id(p_project_number);
1592: l_task_id := qa_flex_util.get_task_id(l_project_id,p_task_number);
1593:

Line 1591: l_project_id := qa_flex_util.get_project_id(p_project_number);

1587: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1588: l_from_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_from_locator);
1589: l_to_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_to_locator);
1590:
1591: l_project_id := qa_flex_util.get_project_id(p_project_number);
1592: l_task_id := qa_flex_util.get_task_id(l_project_id,p_task_number);
1593:
1594:
1595: l_status := INV_CREATE_MOVE_ORDER_INT (

Line 1592: l_task_id := qa_flex_util.get_task_id(l_project_id,p_task_number);

1588: l_from_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_from_locator);
1589: l_to_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_to_locator);
1590:
1591: l_project_id := qa_flex_util.get_project_id(p_project_number);
1592: l_task_id := qa_flex_util.get_task_id(l_project_id,p_task_number);
1593:
1594:
1595: l_status := INV_CREATE_MOVE_ORDER_INT (
1596: l_item_id ,

Line 1954: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

1950: -- Update the Disposition Status to 'Pending'.
1951: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
1952:
1953: -- Get the Inventory Item ID and Locator ID and Reason ID.
1954: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1955: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);
1956:
1957: OPEN reason_cur;
1958: FETCH reason_cur INTO l_reason_id;

Line 1955: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);

1951: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
1952:
1953: -- Get the Inventory Item ID and Locator ID and Reason ID.
1954: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1955: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);
1956:
1957: OPEN reason_cur;
1958: FETCH reason_cur INTO l_reason_id;
1959: CLOSE reason_cur;

Line 2180: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

2176: -- Update the Disposition Status to 'Pending'.
2177: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
2178:
2179: -- Get the Inventory Item ID and Locator ID and Reason ID.
2180: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
2181: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);
2182:
2183: OPEN reason_cur;
2184: FETCH reason_cur INTO l_reason_id;

Line 2181: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);

2177: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);
2178:
2179: -- Get the Inventory Item ID and Locator ID and Reason ID.
2180: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
2181: l_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_locator);
2182:
2183: OPEN reason_cur;
2184: FETCH reason_cur INTO l_reason_id;
2185: CLOSE reason_cur;

Line 2611: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

2607: -- We may need to populate appropriate error message here before return.
2608: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2609: END IF;
2610:
2611: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
2612:
2613: -- Get transaction_id and lookup code for the Intraoperation step.
2614:
2615: l_to_step := get_mfg_lookups_value(p_to_intra_step,'WIP_INTRAOPERATION_STEP');

Line 3886: l_action_fired_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_action_fired_char_id);

3882:
3883: -- Needs to get the result column names of the Seeded handshaking
3884: -- Collection elements.
3885:
3886: l_action_fired_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_action_fired_char_id);
3887: l_disp_message_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_disp_message_char_id);
3888:
3889: -- Bug 2698365. The cursor txn_head_seq is no longer required. Hence commenting
3890: -- the piece of code below. We are returning the value of txn_header_id from the

Line 3887: l_disp_message_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_disp_message_char_id);

3883: -- Needs to get the result column names of the Seeded handshaking
3884: -- Collection elements.
3885:
3886: l_action_fired_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_action_fired_char_id);
3887: l_disp_message_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_disp_message_char_id);
3888:
3889: -- Bug 2698365. The cursor txn_head_seq is no longer required. Hence commenting
3890: -- the piece of code below. We are returning the value of txn_header_id from the
3891: -- update statement. kabalakr.

Line 3929: l_move_order_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_move_order_char_id);

3925: -- using EXECUTE IMMEDIATE. This is for the SQL Bind Compliance Project.
3926: -- kabalakr
3927:
3928: IF p_move_order_number IS NOT NULL THEN
3929: l_move_order_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_move_order_char_id);
3930:
3931: l_sql_string := 'UPDATE qa_results SET '||
3932: l_move_order_column ||' = :move_order_number, ' ||
3933: l_action_fired_column||' = :action_fired, '||