[Home] [Help]
76: p_reference IN VARCHAR2 := null,
77: p_initMsgList IN VARCHAR2,
78: p_endDebug IN VARCHAR2,
79: p_mtlTxnMode IN NUMBER,
80: x_compTbl IN OUT NOCOPY system.wip_component_tbl_t,
81: x_returnStatus OUT NOCOPY VARCHAR2) is
82: cursor c_populatedReqs IS
83: select mti.inventory_item_id itemID,
84: mti.transaction_interface_id txnIntID,
859: p_taskID IN NUMBER,
860: /* added for bug 5332615 */ p_unitNumber in varchar2 DEFAULT '',
861: p_initMsgList IN VARCHAR2,
862: p_endDebug IN VARCHAR2,
863: x_compTbl OUT NOCOPY system.wip_component_tbl_t,
864: x_returnStatus OUT NOCOPY VARCHAR2) is
865: l_grpID NUMBER; --bom table identifier
866: l_cmnBillID NUMBER;
867: l_cmnOrgID NUMBER;
1066: end if;
1067: exception
1068: when no_data_found then
1069: x_returnStatus := fnd_api.g_ret_sts_success;
1070: x_compTbl := system.wip_component_tbl_t();
1071:
1072: if (l_logLevel <= wip_constants.trace_logging) then
1073: wip_logger.exitPoint(p_procName => 'wip_bflProc_priv.explodeRequirements',
1074: p_procReturnStatus => x_returnStatus,
1277: end if;
1278: end loop;
1279: end if;
1280:
1281: x_compTbl := system.wip_component_tbl_t();
1282: x_compTbl.extend(g_compTblExtendSize);
1283:
1284: --second pass: select all the remaining records into a pl/sql table
1285: for l_compRec in c_groupedComponents(v_cmnOrgID => l_cmnOrgID, v_orgID => p_orgID, v_grpID => l_grpID) loop
1532: AND wmti.transaction_id = p_txn_id;
1533:
1534: l_rsa wip_movProc_priv.rsa_tbl_t;
1535: l_params wip_logger.param_tbl_t;
1536: l_compTbl system.wip_component_tbl_t:=NULL;
1537: l_repAssyPull c_repAssyPull%ROWTYPE;
1538: l_wmta c_wmta%ROWTYPE;
1539: l_returnStatus VARCHAR(1);
1540: l_errMsg VARCHAR2(240);
2958: l_last_op NUMBER;
2959: l_first_bf_op NUMBER;
2960: l_last_bf_op NUMBER;
2961: l_bf_qty NUMBER;
2962: l_compTbl system.wip_component_tbl_t;
2963: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2964: l_backwardMove NUMBER := WIP_CONSTANTS.NO;
2965: BEGIN
2966: SAVEPOINT s_backflush2;
3021: l_last_op := 1.1;
3022: END IF;
3023:
3024: -- Initialized component object
3025: l_compTbl := system.wip_component_tbl_t();
3026:
3027: IF(p_fmOp IS NULL OR p_fmStep IS NULL OR
3028: p_toOp IS NULL OR p_toStep IS NULL) THEN
3029: -- Completion/return transactions