APPS.EAM_COMPLETION dependencies on EAM_JOB_COMPLETION_TXNS

Line 1005: -- get transaction_id from sequence eam_job_completion_txns_s

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

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

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

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

1505: l_locator := x_inventory_item_info(1).locator;
1506: l_lot_number := x_inventory_item_info(1).lot_number;
1507: end if;
1508:
1509: -- insert all information to eam_job_completion_txns table for tracking
1510: -- history
1511: -- check for the type of work order to insert the values appropriately
1512: -- The check is added as part of bug #2774571
1513: if(x_rebuild_jobs = 'N') then -- for normal work order

Line 1514: insert into eam_job_completion_txns (transaction_id,

1510: -- history
1511: -- check for the type of work order to insert the values appropriately
1512: -- The check is added as part of bug #2774571
1513: if(x_rebuild_jobs = 'N') then -- for normal work order
1514: insert into eam_job_completion_txns (transaction_id,
1515: transaction_date,
1516: transaction_type,
1517: wip_entity_id,
1518: organization_id,

Line 1605: insert into eam_job_completion_txns (transaction_id,

1601: x_attribute14,
1602: x_attribute15
1603: );
1604: else -- rebuild work orders.
1605: insert into eam_job_completion_txns (transaction_id,
1606: transaction_date,
1607: transaction_type,
1608: wip_entity_id,
1609: organization_id,