eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_MES_UTILITIES_PVT dependencies on STANDARD

Line 35: p_standard_op_id in number,

31: p_responsibility_id in number,
32: p_wip_entity_id in number,
33: p_org_id in number,
34: p_job_op_seq_num in number,
35: p_standard_op_id in number,
36: p_intraop_step in number,
37: p_status_type in number
38: ) return number is
39:

Line 69: l_param_tbl(5).paramName := 'p_standard_op_id';

65: l_param_tbl(3).paramName := 'p_org_id';
66: l_param_tbl(3).paramValue := p_org_id;
67: l_param_tbl(4).paramName := 'p_job_op_seq_num';
68: l_param_tbl(4).paramValue := p_job_op_seq_num;
69: l_param_tbl(5).paramName := 'p_standard_op_id';
70: l_param_tbl(5).paramValue := p_standard_op_id;
71: l_param_tbl(6).paramName := 'p_intraop_step';
72: l_param_tbl(6).paramValue := p_intraop_step;
73: l_param_tbl(7).paramName := 'p_status_type';

Line 70: l_param_tbl(5).paramValue := p_standard_op_id;

66: l_param_tbl(3).paramValue := p_org_id;
67: l_param_tbl(4).paramName := 'p_job_op_seq_num';
68: l_param_tbl(4).paramValue := p_job_op_seq_num;
69: l_param_tbl(5).paramName := 'p_standard_op_id';
70: l_param_tbl(5).paramValue := p_standard_op_id;
71: l_param_tbl(6).paramName := 'p_intraop_step';
72: l_param_tbl(6).paramValue := p_intraop_step;
73: l_param_tbl(7).paramName := 'p_status_type';
74: l_param_tbl(7).paramValue := p_status_type;

Line 87: -- check if the standard operation has responsibility exclusion

83: if (p_job_op_seq_num IS NULL or p_status_type = 6) then
84: return 0; -- No transaction allowed for future operations
85: end if;
86:
87: -- check if the standard operation has responsibility exclusion
88: l_excluded := 2;
89: if(p_responsibility_id > 0 and p_standard_op_id IS NOT NULL) then
90: begin
91: select 1

Line 89: if(p_responsibility_id > 0 and p_standard_op_id IS NOT NULL) then

85: end if;
86:
87: -- check if the standard operation has responsibility exclusion
88: l_excluded := 2;
89: if(p_responsibility_id > 0 and p_standard_op_id IS NOT NULL) then
90: begin
91: select 1
92: into l_excluded
93: from bom_std_op_resp_exclusions bsore

Line 94: where standard_operation_id = p_standard_op_id

90: begin
91: select 1
92: into l_excluded
93: from bom_std_op_resp_exclusions bsore
94: where standard_operation_id = p_standard_op_id
95: and responsibility_id = p_responsibility_id;
96: exception
97: when too_many_rows then
98: l_excluded := 1;

Line 117: -- check the mandatory steps on standard operation definition

113: l_move_next_option
114: from wsm_parameters wp
115: where organization_id = p_org_id;
116:
117: -- check the mandatory steps on standard operation definition
118: -- NOTE: data migrated from wsm_operation_details to bso will be yes/no = 1,2
119: -- and new data in bso is default null = no while updating std ops form gives yes/no = 0,1
120: -- The net effect is yes = 1 and no = 0 or 2 or null. Best to code as if 1, else
121: --

Line 125: if(p_standard_op_id IS NOT NULL) then

121: --
122: -- Change for Bugfix 5347555 only use_org_settings default null = yes
123: -- Note: we do not need to check bos vs. bso as changes to bso are updated to bos immediately.
124: -- however in the future we may need to add a check as in wsm_txn_allowed if routing-level changes become allowed.
125: if(p_standard_op_id IS NOT NULL) then
126: begin
127: select NVL(use_org_settings, 1), -- default: use org settings
128: NVL(queue_mandatory_flag, 0), -- default: no
129: NVL(run_mandatory_flag, 0), -- default: no

Line 135: from bom_standard_operations bso

131: into l_use_org_settings,
132: l_queue_mandatory,
133: l_run_mandatory,
134: l_to_move_mandatory
135: from bom_standard_operations bso
136: where standard_operation_id = p_standard_op_id;
137: exception
138: when others then
139: l_use_org_settings := 1; -- use org settings if bso had some problem

Line 136: where standard_operation_id = p_standard_op_id;

132: l_queue_mandatory,
133: l_run_mandatory,
134: l_to_move_mandatory
135: from bom_standard_operations bso
136: where standard_operation_id = p_standard_op_id;
137: exception
138: when others then
139: l_use_org_settings := 1; -- use org settings if bso had some problem
140: l_queue_mandatory := 0; -- won't be used

Line 210: p_standard_op_id in number,

206: p_responsibility_id in number,
207: p_wip_entity_id in number,
208: p_org_id in number,
209: p_job_op_seq_num in number,
210: p_standard_op_id in number,
211: p_intraop_step in number,
212: p_status_type in number,
213: x_allowed out nocopy number,
214: x_error_msg_name out nocopy varchar2

Line 258: l_param_tbl(6).paramName := 'p_standard_op_id';

254: l_param_tbl(4).paramName := 'p_org_id';
255: l_param_tbl(4).paramValue := p_org_id;
256: l_param_tbl(5).paramName := 'p_job_op_seq_num';
257: l_param_tbl(5).paramValue := p_job_op_seq_num;
258: l_param_tbl(6).paramName := 'p_standard_op_id';
259: l_param_tbl(6).paramValue := p_standard_op_id;
260: l_param_tbl(7).paramName := 'p_intraop_step';
261: l_param_tbl(7).paramValue := p_intraop_step;
262: l_param_tbl(8).paramName := 'p_status_type';

Line 259: l_param_tbl(6).paramValue := p_standard_op_id;

255: l_param_tbl(4).paramValue := p_org_id;
256: l_param_tbl(5).paramName := 'p_job_op_seq_num';
257: l_param_tbl(5).paramValue := p_job_op_seq_num;
258: l_param_tbl(6).paramName := 'p_standard_op_id';
259: l_param_tbl(6).paramValue := p_standard_op_id;
260: l_param_tbl(7).paramName := 'p_intraop_step';
261: l_param_tbl(7).paramValue := p_intraop_step;
262: l_param_tbl(8).paramName := 'p_status_type';
263: l_param_tbl(8).paramValue := p_status_type;

Line 322: if ((p_transaction_type = 32) AND (p_standard_op_id IS NULL)) then

318:
319: if(p_transaction_type not in (1, 4, 8)) then --skip validations for view job op, traveler
320:
321: -- start bugfix 5225744
322: if ((p_transaction_type = 32) AND (p_standard_op_id IS NULL)) then
323: x_allowed := 0; --cannot merge at non-std op
324: x_error_msg_name := 'WSM_MES_NO_NONSTD_OP_MERGE';
325: return;
326: end if;

Line 458: if(p_responsibility_id > 0 and p_standard_op_id IS NOT NULL and p_transaction_type<>2) then

454: end if;
455:
456: -- check operation responsibility exclusion
457: l_excluded := 0;
458: if(p_responsibility_id > 0 and p_standard_op_id IS NOT NULL and p_transaction_type<>2) then
459: begin
460: select 1
461: into l_excluded
462: from bom_std_op_resp_exclusions bsore

Line 463: where standard_operation_id = p_standard_op_id

459: begin
460: select 1
461: into l_excluded
462: from bom_std_op_resp_exclusions bsore
463: where standard_operation_id = p_standard_op_id
464: and responsibility_id = p_responsibility_id;
465: exception
466: when too_many_rows then
467: l_excluded := 1;

Line 545: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

541: AND BOS.operation_sequence_id = WO.operation_sequence_id;
542: ELSE
543: SELECT nvl(BSO.use_org_settings, 1), nvl(BSO.run_mandatory_flag, 0), nvl(BSO.to_move_mandatory_flag, 0)
544: INTO l_op_use_org_settings, l_op_run_mandatory_flag, l_op_to_move_mandatory_flag
545: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
546: WHERE WO.wip_entity_id = p_wip_entity_id
547: AND WO.operation_seq_num = p_job_op_seq_num
548: AND BSO.standard_operation_id = WO.standard_operation_id
549: AND BSO.organization_id = WO.organization_id;

Line 548: AND BSO.standard_operation_id = WO.standard_operation_id

544: INTO l_op_use_org_settings, l_op_run_mandatory_flag, l_op_to_move_mandatory_flag
545: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
546: WHERE WO.wip_entity_id = p_wip_entity_id
547: AND WO.operation_seq_num = p_job_op_seq_num
548: AND BSO.standard_operation_id = WO.standard_operation_id
549: AND BSO.organization_id = WO.organization_id;
550: END IF;--IF (l_routing_op_seq_num IS NOT NULL)
551: exception
552: when others then