DBA Data[Home] [Help]

APPS.WMA_DERIVE dependencies on WIP_CONSTANTS

Line 8: select nvl(mobile_transaction_mode, wip_constants.background)

4: FUNCTION getTxnMode (orgID IN NUMBER) return NUMBER IS
5: txnMode NUMBER;
6: begin
7:
8: select nvl(mobile_transaction_mode, wip_constants.background)
9: into txnMode
10: from wip_parameters
11: where organization_id = orgID;
12:

Line 16: return wip_constants.background;

12:
13: return txnMode;
14: exception
15: when others then
16: return wip_constants.background;
17: end getTxnMode;
18:
19: /**
20: * returns the next value in a database sequence

Line 158: AND wen.entity_type in (WIP_CONSTANTS.DISCRETE,

154: wip_lines wl,
155: wip_entities wen
156: where wdj.wip_entity_id = wipEntityID
157: AND wen.wip_entity_id = wipEntityID
158: AND wen.entity_type in (WIP_CONSTANTS.DISCRETE,
159: WIP_CONSTANTS.EAM)
160: AND wl.line_id (+)= wdj.line_id
161: AND wl.organization_id (+) = wdj.organization_id;
162:

Line 159: WIP_CONSTANTS.EAM)

155: wip_entities wen
156: where wdj.wip_entity_id = wipEntityID
157: AND wen.wip_entity_id = wipEntityID
158: AND wen.entity_type in (WIP_CONSTANTS.DISCRETE,
159: WIP_CONSTANTS.EAM)
160: AND wl.line_id (+)= wdj.line_id
161: AND wl.organization_id (+) = wdj.organization_id;
162:
163: BEGIN