DBA Data[Home] [Help]

APPS.WIP_MTLPROC_PRIV dependencies on WIP_MTLTEMPPROC_GRP

Line 32: procedure processTxn(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,

28: -- procedure resetMtlTxnID;
29: -- procedure setTxnTmpID(p_txnTmpID IN NUMBER);
30: procedure writeError(p_txnTmpID IN NUMBER);
31:
32: procedure processTxn(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,
33: p_issueQty IN NUMBER,
34: p_repSchedID IN NUMBER,
35: x_returnStatus OUT NOCOPY VARCHAR2);
36:

Line 37: procedure populateRepScheds(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,

33: p_issueQty IN NUMBER,
34: p_repSchedID IN NUMBER,
35: x_returnStatus OUT NOCOPY VARCHAR2);
36:
37: procedure populateRepScheds(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,
38: x_schedTbl OUT NOCOPY num_tbl_t,
39: x_qtyTbl OUT NOCOPY num_tbl_t,
40: x_returnStatus OUT NOCOPY VARCHAR2);
41:

Line 42: procedure processRepetitive(p_issueRec IN OUT nocopy wip_mtlTempProc_grp.comp_rec_t,

38: x_schedTbl OUT NOCOPY num_tbl_t,
39: x_qtyTbl OUT NOCOPY num_tbl_t,
40: x_returnStatus OUT NOCOPY VARCHAR2);
41:
42: procedure processRepetitive(p_issueRec IN OUT nocopy wip_mtlTempProc_grp.comp_rec_t,
43: x_returnStatus OUT NOCOPY VARCHAR2);
44:
45: ---------------------------
46: --public/private procedures

Line 52: l_issueRec wip_mtlTempProc_grp.comp_rec_t;

48: procedure processTemp(p_initMsgList IN VARCHAR2,
49: p_endDebug IN VARCHAR2,
50: p_txnTmpID IN NUMBER,
51: x_returnStatus OUT NOCOPY VARCHAR2) is
52: l_issueRec wip_mtlTempProc_grp.comp_rec_t;
53: l_returnStatus VARCHAR2(1);
54: l_invStatus NUMBER;
55: l_errMsg VARCHAR2(2400);
56: l_params wip_logger.param_tbl_t;

Line 298: procedure fillIssueParamTbl(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,

294: wip_logger.cleanUp(x_returnStatus => l_returnStatus); --discard logging return status
295: end if;
296: end processTemp;
297:
298: procedure fillIssueParamTbl(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,
299: x_params OUT NOCOPY wip_logger.param_tbl_t)
300: is begin
301:
302: x_params(1).paramName := 'p_issueRec.txnTmpID';

Line 361: procedure processTxn(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,

357: x_params(28).paramValue := p_issueRec.rebuildSerialNumber;
358:
359: end fillIssueParamTbl;
360:
361: procedure processTxn(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,
362: p_issueQty IN NUMBER,
363: p_repSchedID IN NUMBER,
364: x_returnStatus OUT NOCOPY VARCHAR2) IS
365: l_rowid ROWID;

Line 631: procedure populateRepScheds(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,

627: --This procedure fetches the repetitive schedules and how much of the component
628: --quantity can be allocated to that schedule. As different cursors are used for
629: --issues and returns as well as by supply type, this helper method helps reduce
630: --the size of processRepetitive() below
631: procedure populateRepScheds(p_issueRec IN wip_mtlTempProc_grp.comp_rec_t,
632: x_schedTbl OUT NOCOPY num_tbl_t,
633: x_qtyTbl OUT NOCOPY num_tbl_t,
634: x_returnStatus OUT NOCOPY VARCHAR2) is
635: l_mmttCount NUMBER;

Line 906: procedure processRepetitive(p_issueRec IN OUT NOCOPY wip_mtlTempProc_grp.comp_rec_t,

902: x_returnStatus := fnd_api.g_ret_sts_success;
903: --only errors that can occur are sql exceptions. let those fall through to the calling fn
904: end populateRepScheds;
905:
906: procedure processRepetitive(p_issueRec IN OUT NOCOPY wip_mtlTempProc_grp.comp_rec_t,
907: x_returnStatus OUT NOCOPY VARCHAR2) IS
908: /* Fix for bug 4390097: Rounding l_remQty to prevent wrong quantities in MMTA */
909: -- l_remQty NUMBER := round(abs(p_issueRec.primaryQty),5);
910: /*Fix for bug 5374443: Need not round l_remQty. It contains MMTT primary quantity which is already rounded to 6 decimals. */