DBA Data[Home] [Help]

APPS.WMA_CFM dependencies on WIP_CONSTANTS

Line 94: if assembly.revQtyControlCode = WIP_CONSTANTS.REV then

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: );

Line 169: cfmRec.row.transaction_mode := WIP_CONSTANTS.BACKGROUND;

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;

Line 170: cfmRec.row.process_flag := WIP_CONSTANTS.PENDING;

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;

Line 191: if ( param.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then

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

Line 193: cfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;

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,

Line 194: elsif ( param.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then

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

Line 196: cfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;

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;

Line 197: elsif ( param.transactionType in (WIP_CONSTANTS.SCRASSY_TYPE,

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,

Line 198: WIP_CONSTANTS.RETSCRA_TYPE) ) then

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,

Line 200: cfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;

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;

Line 319: if assembly.revQtyControlCode = WIP_CONSTANTS.REV then

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: );

Line 396: lpnCfmRec.row.transaction_mode := WIP_CONSTANTS.BACKGROUND;

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;

Line 413: if ( lpnParam.transactionType = WIP_CONSTANTS.CPLASSY_TYPE ) then

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

Line 415: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.CPLASSY_ACTION;

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;

Line 416: elsif ( lpnParam.transactionType = WIP_CONSTANTS.RETASSY_TYPE ) then

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;

Line 418: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.RETASSY_ACTION;

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

Line 421: elsif ( lpnParam.transactionType = WIP_CONSTANTS.SCRASSY_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
423: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;
424: if ( wma_util.getScrapAcctID(lpnParam.environment.orgID,
425: scrapAcctID,

Line 423: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_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,
426: errMsg) = false ) then
427: return false;

Line 432: lpnCfmRec.row.transaction_action_id := WIP_CONSTANTS.SCRASSY_ACTION;

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,