138: WHERE source_task_id=p_source_task_id
139: AND activity_type_id=p_activity_id;
140:
141:
142: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
143: l_module_name VARCHAR2(30) := 'Init_OP_Plan_Instance';
144: l_progress NUMBER;
145:
146: l_inbound_doc_rec inbound_document_details%ROWTYPE :=NULL;
748: p_activity_type_id IN NUMBER,
749: p_inventory_item_id IN NUMBER
750: ) IS
751:
752: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
753: l_module_name VARCHAR2(30) := 'Determine_Attributes';
754: l_progress VARCHAR2(30) := '0';
755:
756: l_attributes WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;
1761: l_sug_to_lpn_id NUMBER;
1762: l_dest_param_rec WMS_OP_INBOUND_PVT.DEST_PARAM_REC_TYPE;
1763: l_operation_type_id NUMBER;
1764:
1765: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1766: l_module_name VARCHAR2(30) := 'Activate_Operation_Instance';
1767: l_progress NUMBER;
1768:
1769: l_return_status VARCHAR2(1);
2548: ,p_activity_id IN NUMBER
2549: ,p_operation_type_id IN NUMBER )
2550: IS
2551:
2552: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2553: l_module_name VARCHAR2(30) := 'Complete_Operation_Instance';
2554: l_progress NUMBER;
2555: l_return_status VARCHAR2(1);
2556: l_msg_count NUMBER;
4148: AND organization_id = p_organization_id
4149: GROUP BY lpn_id,inventory_item_id,lot_number,revision;
4150:
4151:
4152: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4153: l_module_name VARCHAR2(30) := 'Validate_Operation';
4154: l_progress NUMBER ;
4155:
4156: l_inspection_status NUMBER:=-1;
5124: l_n_return_status NUMBER;
5125: l_lot_trx_id NUMBER;
5126: l_proc_msg VARCHAR2(500);
5127: l_progress NUMBER;
5128: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5129: l_module_name VARCHAR2(30) := 'Split_operation_instance';
5130:
5131:
5132: /* BEGIN GRACE11_02_2003 */
6451: x_error_code OUT NOCOPY NUMBER,
6452: p_source_task_id IN NUMBER,
6453: p_activity_type_id IN NUMBER )IS
6454:
6455: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6456: l_module_name VARCHAR2(30) := 'Cleanup_operation_instance';
6457: l_progress NUMBER;
6458: l_return_status VARCHAR2(1);
6459: l_msg_count NUMBER;
6957: l_wopi_update_rec WMS_OP_PLAN_INSTANCES%ROWTYPE;
6958: l_parent_source_task_id NUMBER;
6959:
6960:
6961: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6962: l_module_name VARCHAR2(30) := 'Cancel_operation_Plan';
6963: l_progress NUMBER;
6964:
6965: BEGIN
7420: l_document_rec mtl_material_transactions_temp%ROWTYPE;
7421:
7422:
7423:
7424: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7425: l_module_name VARCHAR2(30) := 'Abort_operation_Plan';
7426: l_return_status VARCHAR2(1);
7427: l_msg_count NUMBER;
7428: l_msg_data VARCHAR2(400);
8007: l_first_opertn_seq NUMBER;
8008: l_wopi_rec wms_op_plan_instances%ROWTYPE;
8009: l_op_plan_id NUMBER;
8010:
8011: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8012: l_module_name VARCHAR2(30) := 'Rollback_operation_Plan';
8013: l_progress NUMBER ;
8014:
8015: BEGIN
8549: p_source_task_id IN NUMBER,
8550: p_activity_type_id IN NUMBER
8551: ) IS
8552:
8553: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'),0);
8554: l_module_name VARCHAR2(30) := 'Check_Plan_Status';
8555: l_progress VARCHAR2(30);
8556:
8557: l_status NUMBER := -1;