APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on QA_RESULTS

Line 343: X_from_entity_name => 'QA_RESULTS',

339: -- Bug 2656461. Once the Action is successful, we also need to copy
340: -- the attachments to the new Job created.
341:
342: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
343: X_from_entity_name => 'QA_RESULTS',
344: X_from_pk1_value => to_char(p_occurrence),
345: X_from_pk2_value => to_char(p_collection_id),
346: X_from_pk3_value => to_char(l_plan_id),
347: X_to_entity_name => 'WIP_DISCRETE_JOBS',

Line 3149: X_from_entity_name => 'QA_RESULTS',

3145: -- Bug 2656461. Once the Action is successful, we also need to copy
3146: -- the attachments to the new Operation added.
3147:
3148: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
3149: X_from_entity_name => 'QA_RESULTS',
3150: X_from_pk1_value => to_char(p_occurrence),
3151: X_from_pk2_value => to_char(p_collection_id),
3152: X_from_pk3_value => to_char(l_plan_id),
3153: X_to_entity_name => 'WIP_DISCRETE_OPERATIONS',

Line 3751: UPDATE qa_results

3747: BEGIN
3748:
3749: -- Update the Dispostion_Status to 'Pending'.
3750:
3751: UPDATE qa_results
3752: SET disposition_status = 'PENDING',
3753: txn_header_id = mtl_material_transactions_s.nextval
3754: WHERE collection_id = p_collection_id AND occurrence = p_occurrence
3755: RETURNING txn_header_id INTO l_txnheader_id;

Line 3890: UPDATE qa_results

3886:
3887: -- Bug 2698365. Added txn_header_id in the update statement below and
3888: -- returning its value to the variable l_txnheader_id. kabalakr.
3889:
3890: UPDATE qa_results
3891: SET disposition_status = p_status,
3892: wip_rework_id = NVL(p_job_id, 0),
3893: wjsi_group_id = NVL(p_wjsi_group_id, 0),
3894: mti_transaction_header_id = NVL(p_mti_transaction_header_id, 0),

Line 3915: l_sql_string := 'UPDATE qa_results SET '||

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, '||
3918: l_disp_message_column||' = :message '||
3919: ' WHERE collection_id = :coll_id AND occurrence = :occ';

Line 3926: l_sql_string := 'UPDATE qa_results SET ' ||

3922:
3923: ELSE
3924:
3925:
3926: l_sql_string := 'UPDATE qa_results SET ' ||
3927: l_action_fired_column||' = :action_fired, '||
3928: l_disp_message_column||' = :message '||
3929: ' WHERE collection_id = :coll_id AND occurrence = :occ';
3930: