[Home] [Help]
44: l_retValue VARCHAR2(10);
45: l_msgCount NUMBER;
46: l_errMsg VARCHAR2(240);
47: l_msgData VARCHAR2(4000);
48: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
49: l_serialStartOp NUMBER;
50:
51: /* Bug 5708242 */
52: l_primaryCostMethod NUMBER;
282: l_msgTxt VARCHAR2(2000);
283: l_returnStatus VARCHAR2(1);
284: l_qtyAvailToComplete NUMBER;
285: l_nullObj system.wip_component_tbl_t := null;
286: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
287: l_docType NUMBER;
288: oc_primary_qty NUMBER; -- Fix BUG 4869979 (FP 5107900)
289: -- Fixed bug 3678776. We should allow user to overreturn assembly back
290: -- to non-standard job.
532: l_nullObj system.wip_component_tbl_t := null;
533: --the following field is used to store values for a final update to MMTA if not enough open qty can be found
534: --in the existing schedules and we need to allocate more qty to the first/last schedule after the main loop is done
535: l_finalRepSchedID NUMBER;
536: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
537: l_scrapQty NUMBER;
538:
539: --type for below cursor
540: type schedule_recTbl_t is record(schedID num_tbl_t,
782: l_returnStatus VARCHAR2(1);
783: l_firstSchedID NUMBER;
784: l_lastSchedID NUMBER;
785: l_firstOpSeq NUMBER;
786: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
787: --use the cursors only to lock the relavent wro rows
788: cursor c_repRows(v_schedID NUMBER) is
789: select required_quantity
790: from wip_requirement_operations
1038: priQty num_tbl_t,
1039: txnQty num_tbl_t,
1040: overCplQty num_tbl_t,
1041: orgID num_tbl_t);
1042: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1043: l_params wip_logger.param_tbl_t;
1044: l_lastOpSeq NUMBER;
1045: l_schedQty NUMBER;
1046: l_returnStatus VARCHAR2(1);
1395:
1396: l_schedID NUMBER;
1397: l_errMsg VARCHAR2(2000);
1398: l_returnStatus VARCHAR2(1);
1399: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1400: l_params wip_logger.param_tbl_t;
1401: begin
1402: --need to find the first open schedule. if we have pre-allocated completions, we have to see
1403: --which ones will be completed by the time this return is processed.
1548: p_tblName IN VARCHAR2,
1549: p_endDebug IN VARCHAR2,
1550: x_returnStatus OUT NOCOPY VARCHAR2) IS
1551:
1552: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1553: l_params wip_logger.param_tbl_t;
1554: l_returnStatus VARCHAR2(1);
1555: l_errMsg VARCHAR2(2000);
1556: begin
1707: WHERE transaction_temp_id = p_interface_id;
1708:
1709:
1710: l_cmp_txn c_cmp_txn%ROWTYPE;
1711: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1712: l_cost_method NUMBER;
1713: l_err_num NUMBER;
1714: l_msg_count NUMBER;
1715: l_ret_value NUMBER;