APPS.EAM_COMPLETION dependencies on EAM_JOB_COMPLETION_TXNS

Line 1007: -- get transaction_id from sequence eam_job_completion_txns_s

1003:
1004: l_statement := 25;
1005: x_statement := l_statement;
1006:
1007: -- get transaction_id from sequence eam_job_completion_txns_s
1008: select eam_job_completion_txns_s.nextval into i_transaction_id from dual;
1009:
1010: if(x_request_id is not null and x_application_id is not null and
1011: x_program_id is not null) then

Line 1008: select eam_job_completion_txns_s.nextval into i_transaction_id from dual;

1004: l_statement := 25;
1005: x_statement := l_statement;
1006:
1007: -- get transaction_id from sequence eam_job_completion_txns_s
1008: select eam_job_completion_txns_s.nextval into i_transaction_id from dual;
1009:
1010: if(x_request_id is not null and x_application_id is not null and
1011: x_program_id is not null) then
1012: i_program_update_date := sysdate;

Line 1556: -- insert all information to eam_job_completion_txns table for tracking

1552: l_locator := x_inventory_item_info(1).locator;
1553: l_lot_number := x_inventory_item_info(1).lot_number;
1554: end if;
1555:
1556: -- insert all information to eam_job_completion_txns table for tracking
1557: -- history
1558: -- check for the type of work order to insert the values appropriately
1559: -- The check is added as part of bug #2774571
1560: if(x_rebuild_jobs = 'N') then -- for normal work order

Line 1561: insert into eam_job_completion_txns (transaction_id,

1557: -- history
1558: -- check for the type of work order to insert the values appropriately
1559: -- The check is added as part of bug #2774571
1560: if(x_rebuild_jobs = 'N') then -- for normal work order
1561: insert into eam_job_completion_txns (transaction_id,
1562: transaction_date,
1563: transaction_type,
1564: wip_entity_id,
1565: organization_id,

Line 1652: insert into eam_job_completion_txns (transaction_id,

1648: x_attribute14,
1649: x_attribute15
1650: );
1651: else -- rebuild work orders.
1652: insert into eam_job_completion_txns (transaction_id,
1653: transaction_date,
1654: transaction_type,
1655: wip_entity_id,
1656: organization_id,