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 1583: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

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

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

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

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

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

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

1583: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
1584: l_from_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_from_locator);
1585: l_to_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_to_locator);
1586:
1587: l_project_id := qa_flex_util.get_project_id(p_project_number);
1588: l_task_id := qa_flex_util.get_task_id(l_project_id,p_task_number);
1589:
1590:
1591: l_status := INV_CREATE_MOVE_ORDER_INT (

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

1584: l_from_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_from_locator);
1585: l_to_locator_id := qa_flex_util.get_locator_id(l_organization_id, p_to_locator);
1586:
1587: l_project_id := qa_flex_util.get_project_id(p_project_number);
1588: l_task_id := qa_flex_util.get_task_id(l_project_id,p_task_number);
1589:
1590:
1591: l_status := INV_CREATE_MOVE_ORDER_INT (
1592: l_item_id ,

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

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

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

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

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

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

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

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

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

2600: -- We may need to populate appropriate error message here before return.
2601: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2602: END IF;
2603:
2604: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
2605:
2606: -- Get transaction_id and lookup code for the Intraoperation step.
2607:
2608: l_to_step := get_mfg_lookups_value(p_to_intra_step,'WIP_INTRAOPERATION_STEP');

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

3866:
3867: -- Needs to get the result column names of the Seeded handshaking
3868: -- Collection elements.
3869:
3870: l_action_fired_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_action_fired_char_id);
3871: l_disp_message_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_disp_message_char_id);
3872:
3873: -- Bug 2698365. The cursor txn_head_seq is no longer required. Hence commenting
3874: -- the piece of code below. We are returning the value of txn_header_id from the

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

3867: -- Needs to get the result column names of the Seeded handshaking
3868: -- Collection elements.
3869:
3870: l_action_fired_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_action_fired_char_id);
3871: l_disp_message_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_disp_message_char_id);
3872:
3873: -- Bug 2698365. The cursor txn_head_seq is no longer required. Hence commenting
3874: -- the piece of code below. We are returning the value of txn_header_id from the
3875: -- update statement. kabalakr.

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

3909: -- using EXECUTE IMMEDIATE. This is for the SQL Bind Compliance Project.
3910: -- kabalakr
3911:
3912: IF p_move_order_number IS NOT NULL THEN
3913: l_move_order_column := QA_FLEX_UTIL.qpc_result_column_name(p_plan_id, l_move_order_char_id);
3914:
3915: l_sql_string := 'UPDATE qa_results SET '||
3916: l_move_order_column ||' = :move_order_number, ' ||
3917: l_action_fired_column||' = :action_fired, '||