[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.
507: l_nullObj system.wip_component_tbl_t := null;
508: --the following field is used to store values for a final update to MMTA if not enough open qty can be found
509: --in the existing schedules and we need to allocate more qty to the first/last schedule after the main loop is done
510: l_finalRepSchedID NUMBER;
511: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
512: l_scrapQty NUMBER;
513:
514: --type for below cursor
515: type schedule_recTbl_t is record(schedID num_tbl_t,
756: l_returnStatus VARCHAR2(1);
757: l_firstSchedID NUMBER;
758: l_lastSchedID NUMBER;
759: l_firstOpSeq NUMBER;
760: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
761: --use the cursors only to lock the relavent wro rows
762: cursor c_repRows(v_schedID NUMBER) is
763: select required_quantity
764: from wip_requirement_operations
1012: priQty num_tbl_t,
1013: txnQty num_tbl_t,
1014: overCplQty num_tbl_t,
1015: orgID num_tbl_t);
1016: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1017: l_params wip_logger.param_tbl_t;
1018: l_lastOpSeq NUMBER;
1019: l_schedQty NUMBER;
1020: l_returnStatus VARCHAR2(1);
1369:
1370: l_schedID NUMBER;
1371: l_errMsg VARCHAR2(2000);
1372: l_returnStatus VARCHAR2(1);
1373: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1374: l_params wip_logger.param_tbl_t;
1375: begin
1376: --need to find the first open schedule. if we have pre-allocated completions, we have to see
1377: --which ones will be completed by the time this return is processed.
1522: p_tblName IN VARCHAR2,
1523: p_endDebug IN VARCHAR2,
1524: x_returnStatus OUT NOCOPY VARCHAR2) IS
1525:
1526: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1527: l_params wip_logger.param_tbl_t;
1528: l_returnStatus VARCHAR2(1);
1529: l_errMsg VARCHAR2(2000);
1530: begin
1681: WHERE transaction_temp_id = p_interface_id;
1682:
1683:
1684: l_cmp_txn c_cmp_txn%ROWTYPE;
1685: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1686: l_cost_method NUMBER;
1687: l_err_num NUMBER;
1688: l_msg_count NUMBER;
1689: l_ret_value NUMBER;