90: assembly := wma_derive.getItem(param.assemblyID,
91: param.environment.orgID,
92: param.locatorID);
93:
94: if assembly.revQtyControlCode = WIP_CONSTANTS.REV then
95: /* 3033785 */
96: wip_common.Get_Released_Revs_Type_Meaning (x_released_revs_type,
97: x_released_revs_meaning
98: );
165:
166: cfmRec.row.transaction_interface_id := param.transactionInterfaceID;
167: cfmRec.row.transaction_header_id := param.transactionHeaderID;
168: cfmRec.row.lock_flag := 2;
169: cfmRec.row.transaction_mode := WIP_CONSTANTS.BACKGROUND;
170: cfmRec.row.process_flag := WIP_CONSTANTS.PENDING;
171: cfmRec.row.validation_required := 1;
172:
173: cfmRec.row.source_code := WMA_COMMON.SOURCE_CODE;
166: cfmRec.row.transaction_interface_id := param.transactionInterfaceID;
167: cfmRec.row.transaction_header_id := param.transactionHeaderID;
168: cfmRec.row.lock_flag := 2;
169: cfmRec.row.transaction_mode := WIP_CONSTANTS.BACKGROUND;
170: cfmRec.row.process_flag := WIP_CONSTANTS.PENDING;
171: cfmRec.row.validation_required := 1;
172:
173: cfmRec.row.source_code := WMA_COMMON.SOURCE_CODE;
174: cfmRec.row.source_line_id := -1;
187: cfmRec.row.negative_req_flag := 1;
188: cfmRec.row.transaction_quantity := param.transactionQty;
189: cfmRec.row.primary_quantity := param.transactionQty;
190:
191: if ( param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
192: -- for completion
193: cfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
194: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
195: -- for return
189: cfmRec.row.primary_quantity := param.transactionQty;
190:
191: if ( param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
192: -- for completion
193: cfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
194: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
195: -- for return
196: cfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
197: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
190:
191: if ( param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
192: -- for completion
193: cfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
194: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
195: -- for return
196: cfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
197: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
198: WIP_CONSTANTS.RETSCRA_TYPE) ) then
192: -- for completion
193: cfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
194: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
195: -- for return
196: cfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
197: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
198: WIP_CONSTANTS.RETSCRA_TYPE) ) then
199: -- for scrap
200: cfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
193: cfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
194: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
195: -- for return
196: cfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
197: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
198: WIP_CONSTANTS.RETSCRA_TYPE) ) then
199: -- for scrap
200: cfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
201: if ( wma_util.getScrapAcctID(param.environment.orgID,
194: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
195: -- for return
196: cfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
197: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
198: WIP_CONSTANTS.RETSCRA_TYPE) ) then
199: -- for scrap
200: cfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
201: if ( wma_util.getScrapAcctID(param.environment.orgID,
202: scrapAcctID,
196: cfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
197: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,
198: WIP_CONSTANTS.RETSCRA_TYPE) ) then
199: -- for scrap
200: cfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
201: if ( wma_util.getScrapAcctID(param.environment.orgID,
202: scrapAcctID,
203: errMsg) = false ) then
204: return false;
315: assembly := wma_derive.getItem(lpnParam.assemblyID,
316: lpnParam.environment.orgID,
317: lpnParam.locatorID);
318:
319: if assembly.revQtyControlCode = WIP_CONSTANTS.REV then
320: /* 3033785 */
321: wip_common.Get_Released_Revs_Type_Meaning (x_released_revs_type,
322: x_released_revs_meaning
323: );
392: end if;
393:
394: lpnCfmRec.row.header_id := lpnParam.headerID;
395: lpnCfmRec.row.lock_flag := 'N';
396: lpnCfmRec.row.transaction_mode := WIP_CONSTANTS.BACKGROUND;
397:
398:
399: lpnCfmRec.row.last_updated_by := lpnParam.environment.userID;
400: lpnCfmRec.row.last_update_date := sysdate;
409: lpnCfmRec.row.transaction_type_id := lpnParam.transactionType;
410: lpnCfmRec.row.transaction_quantity := lpnParam.transactionQty;
411: lpnCfmRec.row.primary_quantity := lpnParam.transactionQty;
412:
413: if ( lpnParam.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
414: -- for completion
415: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
416: elsif ( lpnParam.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
417: -- for return
411: lpnCfmRec.row.primary_quantity := lpnParam.transactionQty;
412:
413: if ( lpnParam.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
414: -- for completion
415: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
416: elsif ( lpnParam.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
417: -- for return
418: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
419: lpnCfmRec.row.transaction_quantity := lpnParam.transactionQty * -1;
412:
413: if ( lpnParam.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then
414: -- for completion
415: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
416: elsif ( lpnParam.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
417: -- for return
418: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
419: lpnCfmRec.row.transaction_quantity := lpnParam.transactionQty * -1;
420: lpnCfmRec.row.primary_quantity := lpnParam.transactionQty * -1;
414: -- for completion
415: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;
416: elsif ( lpnParam.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then
417: -- for return
418: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
419: lpnCfmRec.row.transaction_quantity := lpnParam.transactionQty * -1;
420: lpnCfmRec.row.primary_quantity := lpnParam.transactionQty * -1;
421: elsif ( lpnParam.transactionType = WIP_CONSTANTS.SCRASSY_TYPE ) then
422: -- for scrap
417: -- for return
418: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;
419: lpnCfmRec.row.transaction_quantity := lpnParam.transactionQty * -1;
420: lpnCfmRec.row.primary_quantity := lpnParam.transactionQty * -1;
421: elsif ( lpnParam.transactionType = WIP_CONSTANTS.SCRASSY_TYPE ) then
422: -- for scrap
423: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
424: if ( wma_util.getScrapAcctID(lpnParam.environment.orgID,
425: scrapAcctID,
419: lpnCfmRec.row.transaction_quantity := lpnParam.transactionQty * -1;
420: lpnCfmRec.row.primary_quantity := lpnParam.transactionQty * -1;
421: elsif ( lpnParam.transactionType = WIP_CONSTANTS.SCRASSY_TYPE ) then
422: -- for scrap
423: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
424: if ( wma_util.getScrapAcctID(lpnParam.environment.orgID,
425: scrapAcctID,
426: errMsg) = false ) then
427: return false;
428: end if;
429: elsif ( lpnParam.transactionType = 91 ) then
430: -- for return from scrap, it has the same action id as scrap, you
431: -- can only distinguish them by type id
432: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
433: lpnCfmRec.row.transaction_quantity := lpnParam.transactionQty * -1;
434: lpnCfmRec.row.primary_quantity := lpnParam.transactionQty * -1;
435: if ( wma_util.getScrapAcctID(lpnParam.environment.orgID,
436: scrapAcctID,