[Home] [Help]
75: p_reference IN VARCHAR2 := null,
76: p_initMsgList IN VARCHAR2,
77: p_endDebug IN VARCHAR2,
78: p_mtlTxnMode IN NUMBER,
79: x_compTbl IN OUT NOCOPY system.wip_component_tbl_t,
80: x_returnStatus OUT NOCOPY VARCHAR2) is
81: cursor c_populatedReqs IS
82: select mti.inventory_item_id itemID,
83: mti.transaction_interface_id txnIntID,
869: p_taskID IN NUMBER,
870: /* added for bug 5332615 */ p_unitNumber in varchar2 DEFAULT '',
871: p_initMsgList IN VARCHAR2,
872: p_endDebug IN VARCHAR2,
873: x_compTbl OUT NOCOPY system.wip_component_tbl_t,
874: x_returnStatus OUT NOCOPY VARCHAR2) is
875: l_grpID NUMBER; --bom table identifier
876: l_cmnBillID NUMBER;
877: l_cmnOrgID NUMBER;
1092: end if;
1093: exception
1094: when no_data_found then
1095: x_returnStatus := fnd_api.g_ret_sts_success;
1096: x_compTbl := system.wip_component_tbl_t();
1097:
1098: if (l_logLevel <= wip_constants.trace_logging) then
1099: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1100: p_procReturnStatus => x_returnStatus,
1318: end if; ----if item is a phantom
1319: end loop;
1320: end if;
1321:
1322: x_compTbl := system.wip_component_tbl_t();
1323: x_compTbl.extend(g_compTblExtendSize);
1324:
1325: --second pass: select all the remaining records into a pl/sql table
1326: for l_compRec in c_groupedComponents(v_cmnOrgID => l_cmnOrgID, v_orgID => p_orgID, v_grpID => l_grpID) loop
1583: AND wmti.transaction_id = p_txn_id;
1584:
1585: l_rsa wip_movProc_priv.rsa_tbl_t;
1586: l_params wip_logger.param_tbl_t;
1587: l_compTbl system.wip_component_tbl_t:=NULL;
1588: l_repAssyPull c_repAssyPull%ROWTYPE;
1589: l_wmta c_wmta%ROWTYPE;
1590: l_returnStatus VARCHAR(1);
1591: l_errMsg VARCHAR2(240);
3067: l_last_op NUMBER;
3068: l_first_bf_op NUMBER;
3069: l_last_bf_op NUMBER;
3070: l_bf_qty NUMBER;
3071: l_compTbl system.wip_component_tbl_t;
3072: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3073: l_backwardMove NUMBER := WIP_CONSTANTS.NO;
3074: BEGIN
3075: SAVEPOINT s_backflush2;
3130: l_last_op := 1.1;
3131: END IF;
3132:
3133: -- Initialized component object
3134: l_compTbl := system.wip_component_tbl_t();
3135:
3136: IF(p_fmOp IS NULL OR p_fmStep IS NULL OR
3137: p_toOp IS NULL OR p_toStep IS NULL) THEN
3138: -- Completion/return transactions