APPS.EAM_OP_COMP dependencies on EAM_OP_COMP

Line 1: PACKAGE BODY eam_op_comp AS

1: PACKAGE BODY eam_op_comp AS
2: /* $Header: EAMOCMPB.pls 120.9 2010/12/14 10:23:54 vpasupur ship $ */
3:
4:
5: FUNCTION IS_WORKFLOW_ENABLED

Line 170: from eam_op_completion_txns eoct,wip_operation_networks won

166:
167: --added for fix to bug 3543834:
168: CURSOR CON3 IS
169: select nvl(max(actual_end_date),sysdate-20000)
170: from eam_op_completion_txns eoct,wip_operation_networks won
171: where eoct.wip_entity_id = p_wip_entity_id
172: and eoct.operation_seq_num=won.prior_operation
173: and won.wip_entity_id=eoct.wip_entity_id
174: and won.next_operation=p_operation_seq_num

Line 177: from eam_op_completion_txns

173: and won.wip_entity_id=eoct.wip_entity_id
174: and won.next_operation=p_operation_seq_num
175: and transaction_type=1
176: and transaction_id = (select max(transaction_id)
177: from eam_op_completion_txns
178: where wip_entity_id = p_wip_entity_id
179: and operation_seq_num = eoct.operation_seq_num
180: );
181:

Line 185: select transaction_id from eam_op_completion_txns

181:
182:
183:
184: CURSOR CT IS
185: select transaction_id from eam_op_completion_txns
186: where transaction_id = l_transaction_id;
187: CURSOR CH IS
188: select asset_status_id from eam_asset_status_history
189: where asset_status_id = l_status_id;

Line 262: 'EAM_OP_COMP_WOCOMP_TEST');

258: x_err_code := 1;
259: x_err_msg := l_validate_msg;
260: fnd_message.set_name(
261: 'EAM',
262: 'EAM_OP_COMP_WOCOMP_TEST');
263: --following line also added as part of bug 5440339
264: fnd_message.set_token('OP_SEQ_NO', p_operation_seq_num);
265: APP_EXCEPTION.Raise_Exception;
266: END IF;

Line 323: select eam_op_completion_txns_s.nextval into l_transaction_id from dual;

319: APP_EXCEPTION.Raise_Exception;
320: END IF;
321: close C;
322:
323: select eam_op_completion_txns_s.nextval into l_transaction_id from dual;
324:
325: -- -insert into TABLE eam_op_completion_txns
326: INSERT INTO EAM_OP_COMPLETION_TXNS(
327: TRANSACTION_ID,

Line 325: -- -insert into TABLE eam_op_completion_txns

321: close C;
322:
323: select eam_op_completion_txns_s.nextval into l_transaction_id from dual;
324:
325: -- -insert into TABLE eam_op_completion_txns
326: INSERT INTO EAM_OP_COMPLETION_TXNS(
327: TRANSACTION_ID,
328: TRANSACTION_DATE,
329: TRANSACTION_TYPE,

Line 326: INSERT INTO EAM_OP_COMPLETION_TXNS(

322:
323: select eam_op_completion_txns_s.nextval into l_transaction_id from dual;
324:
325: -- -insert into TABLE eam_op_completion_txns
326: INSERT INTO EAM_OP_COMPLETION_TXNS(
327: TRANSACTION_ID,
328: TRANSACTION_DATE,
329: TRANSACTION_TYPE,
330: WIP_ENTITY_ID,

Line 625: from eam_op_completion_txns eoct,wip_operation_networks won

621: begin
622: --fix for 3543834.changed queries to fetch correct data
623: select max(actual_end_date)
624: into l_max_prior_end_date
625: from eam_op_completion_txns eoct,wip_operation_networks won
626: where eoct.wip_entity_id = p_wip_entity_id
627: and eoct.operation_seq_num=won.prior_operation
628: and won.wip_entity_id=eoct.wip_entity_id
629: and won.next_operation=p_operation_seq_num

Line 632: from eam_op_completion_txns

628: and won.wip_entity_id=eoct.wip_entity_id
629: and won.next_operation=p_operation_seq_num
630: and transaction_type=1
631: and transaction_id = (select max(transaction_id)
632: from eam_op_completion_txns
633: where wip_entity_id = p_wip_entity_id
634: and operation_seq_num = eoct.operation_seq_num
635: );
636:

Line 670: END eam_op_comp;

666: eam_debug.init_err_stack('Exception has occured in ' || l_api_name);
667: end get_op_defaults;
668:
669:
670: END eam_op_comp;