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.8 2006/09/18 08:33:47 cboppana noship $ */
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 621: from eam_op_completion_txns eoct,wip_operation_networks won

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

Line 628: from eam_op_completion_txns

624: and won.wip_entity_id=eoct.wip_entity_id
625: and won.next_operation=p_operation_seq_num
626: and transaction_type=1
627: and transaction_id = (select max(transaction_id)
628: from eam_op_completion_txns
629: where wip_entity_id = p_wip_entity_id
630: and operation_seq_num = eoct.operation_seq_num
631: );
632:

Line 666: END eam_op_comp;

662: eam_debug.init_err_stack('Exception has occured in ' || l_api_name);
663: end get_op_defaults;
664:
665:
666: END eam_op_comp;