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.WSMPJUPD dependencies on WSM_OP_REASON_CODES

Line 50: type t_wsm_op_reason_codes_tbl is table of wsm_op_reason_codes%rowtype index by binary_integer;

46: type t_cur_uom_tbl is table of wsm_job_secondary_quantities.uom_code%type index by binary_integer;
47: -- End MES secondary qty changes
48:
49: -- MES copy tables changes
50: type t_wsm_op_reason_codes_tbl is table of wsm_op_reason_codes%rowtype index by binary_integer;
51: --type t_wsm_subst_comp_tbl is table of wsm_substitute_components%rowtype index by binary_integer;
52: type t_wsm_copy_requirement_ops_tbl is table of wsm_copy_requirement_ops%rowtype index by binary_integer;
53: -- End MES copy tables changes
54:

Line 88: l_rj_op_reason_codes_tbl t_wsm_op_reason_codes_tbl;

84: l_wsm_op_sec_qty_tbl t_wsm_op_sec_qty_tbl;
85: l_wsm_sj_sec_qty_tbl t_wsm_sj_sec_qty_tbl;
86: l_wsm_rj_sec_qty_tbl t_wsm_rj_sec_qty_tbl;
87:
88: l_rj_op_reason_codes_tbl t_wsm_op_reason_codes_tbl;
89: l_sj_op_reason_codes_tbl t_wsm_op_reason_codes_tbl;
90:
91: l_job_qty_tbl t_wsm_job_sec_qty_tbl;
92:

Line 89: l_sj_op_reason_codes_tbl t_wsm_op_reason_codes_tbl;

85: l_wsm_sj_sec_qty_tbl t_wsm_sj_sec_qty_tbl;
86: l_wsm_rj_sec_qty_tbl t_wsm_rj_sec_qty_tbl;
87:
88: l_rj_op_reason_codes_tbl t_wsm_op_reason_codes_tbl;
89: l_sj_op_reason_codes_tbl t_wsm_op_reason_codes_tbl;
90:
91: l_job_qty_tbl t_wsm_job_sec_qty_tbl;
92:
93: l_sj_tbl_counter number;

Line 486: from wsm_op_reason_codes

482:
483: select *
484: bulk collect
485: into l_sj_op_reason_codes_tbl
486: from wsm_op_reason_codes
487: where operation_seq_num = p_wltx_starting_jobs_tbl(p_rep_job_index).operation_seq_num
488: and wip_entity_id = p_wltx_starting_jobs_tbl(p_rep_job_index).wip_entity_id;
489:
490: if( g_log_level_statement >= l_log_level ) then

Line 552: insert into wsm_op_reason_codes

548: p_run_log_level => l_log_level
549: );
550: End if;
551: forall i in indices of l_rj_op_reason_codes_tbl
552: insert into wsm_op_reason_codes
553: values l_rj_op_reason_codes_tbl(i);
554:
555: END IF;
556:

Line 758: PROCEDURE copy_wsm_op_reason_codes ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

754: END;
755:
756: /************** Commenting out due to few discrepancies in the code...
757: Reason code information is handled if the process_mes_info
758: PROCEDURE copy_wsm_op_reason_codes ( p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
759: p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
760: p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
761: p_rep_job_index IN NUMBER,
762: p_sj_also_rj_index IN NUMBER,

Line 769: l_wsm_op_reason_codes_tbl t_wsm_op_reason_codes_tbl;

765: x_error_msg OUT NOCOPY VARCHAR2)
766: IS
767:
768: l_sj_we_id NUMBER ;
769: l_wsm_op_reason_codes_tbl t_wsm_op_reason_codes_tbl;
770:
771: l_counter number;
772: g_code_type_bonus CONSTANT NUMBER := 1 ;
773: g_code_type_scrap CONSTANT NUMBER := 2 ;

Line 779: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.copy_wsm_op_reason_codes';

775: -- Logging variables.....
776: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
777: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
778: l_stmt_num NUMBER;
779: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.copy_wsm_op_reason_codes';
780:
781: BEGIN
782:
783: savepoint start_copy_wsm_op_reason_codes;

Line 783: savepoint start_copy_wsm_op_reason_codes;

779: l_module VARCHAR2(100) := 'wsm.plsql.WSMPJUPD.copy_wsm_op_reason_codes';
780:
781: BEGIN
782:
783: savepoint start_copy_wsm_op_reason_codes;
784:
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: l_stmt_num := 10;

Line 800: l_wsm_op_reason_codes_tbl.delete;

796: l_stmt_num := 20;
797: If p_wltx_header.transaction_type_id in (WSMPCNST.SPLIT,WSMPCNST.MERGE) then
798: for i in p_wltx_resulting_jobs_tbl.first .. p_wltx_resulting_jobs_tbl.last loop
799: if p_wltx_resulting_jobs_tbl(i).split_has_update_assy <>1 then
800: l_wsm_op_reason_codes_tbl.delete;
801: BEGIN
802: select *
803: bulk collect into l_wsm_op_reason_codes_tbl
804: from wsm_op_reason_codes

Line 803: bulk collect into l_wsm_op_reason_codes_tbl

799: if p_wltx_resulting_jobs_tbl(i).split_has_update_assy <>1 then
800: l_wsm_op_reason_codes_tbl.delete;
801: BEGIN
802: select *
803: bulk collect into l_wsm_op_reason_codes_tbl
804: from wsm_op_reason_codes
805: where operation_seq_num = p_wltx_resulting_jobs_tbl(i).starting_operation_seq_num
806: and wip_entity_id = l_sj_we_id
807: and p_wltx_resulting_jobs_tbl(i).wip_entity_id <> l_sj_we_id;

Line 804: from wsm_op_reason_codes

800: l_wsm_op_reason_codes_tbl.delete;
801: BEGIN
802: select *
803: bulk collect into l_wsm_op_reason_codes_tbl
804: from wsm_op_reason_codes
805: where operation_seq_num = p_wltx_resulting_jobs_tbl(i).starting_operation_seq_num
806: and wip_entity_id = l_sj_we_id
807: and p_wltx_resulting_jobs_tbl(i).wip_entity_id <> l_sj_we_id;
808: EXCEPTION

Line 812: if l_wsm_op_reason_codes_tbl.count > 0 then

808: EXCEPTION
809: when no_data_found then
810: null;
811: END;
812: if l_wsm_op_reason_codes_tbl.count > 0 then
813: for j in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last loop
814: l_wsm_op_reason_codes_tbl(j).wip_entity_id := p_wltx_resulting_jobs_tbl(i).wip_entity_id;
815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;
816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;

Line 813: for j in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last loop

809: when no_data_found then
810: null;
811: END;
812: if l_wsm_op_reason_codes_tbl.count > 0 then
813: for j in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last loop
814: l_wsm_op_reason_codes_tbl(j).wip_entity_id := p_wltx_resulting_jobs_tbl(i).wip_entity_id;
815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;
816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;
817: l_wsm_op_reason_codes_tbl(j).Last_updated_by := fnd_global.user_id;

Line 814: l_wsm_op_reason_codes_tbl(j).wip_entity_id := p_wltx_resulting_jobs_tbl(i).wip_entity_id;

810: null;
811: END;
812: if l_wsm_op_reason_codes_tbl.count > 0 then
813: for j in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last loop
814: l_wsm_op_reason_codes_tbl(j).wip_entity_id := p_wltx_resulting_jobs_tbl(i).wip_entity_id;
815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;
816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;
817: l_wsm_op_reason_codes_tbl(j).Last_updated_by := fnd_global.user_id;
818: l_wsm_op_reason_codes_tbl(j).Creation_date := sysdate;

Line 815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;

811: END;
812: if l_wsm_op_reason_codes_tbl.count > 0 then
813: for j in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last loop
814: l_wsm_op_reason_codes_tbl(j).wip_entity_id := p_wltx_resulting_jobs_tbl(i).wip_entity_id;
815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;
816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;
817: l_wsm_op_reason_codes_tbl(j).Last_updated_by := fnd_global.user_id;
818: l_wsm_op_reason_codes_tbl(j).Creation_date := sysdate;
819: l_wsm_op_reason_codes_tbl(j).Last_updated_login := fnd_global.login_id;

Line 816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;

812: if l_wsm_op_reason_codes_tbl.count > 0 then
813: for j in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last loop
814: l_wsm_op_reason_codes_tbl(j).wip_entity_id := p_wltx_resulting_jobs_tbl(i).wip_entity_id;
815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;
816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;
817: l_wsm_op_reason_codes_tbl(j).Last_updated_by := fnd_global.user_id;
818: l_wsm_op_reason_codes_tbl(j).Creation_date := sysdate;
819: l_wsm_op_reason_codes_tbl(j).Last_updated_login := fnd_global.login_id;
820: end loop;

Line 817: l_wsm_op_reason_codes_tbl(j).Last_updated_by := fnd_global.user_id;

813: for j in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last loop
814: l_wsm_op_reason_codes_tbl(j).wip_entity_id := p_wltx_resulting_jobs_tbl(i).wip_entity_id;
815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;
816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;
817: l_wsm_op_reason_codes_tbl(j).Last_updated_by := fnd_global.user_id;
818: l_wsm_op_reason_codes_tbl(j).Creation_date := sysdate;
819: l_wsm_op_reason_codes_tbl(j).Last_updated_login := fnd_global.login_id;
820: end loop;
821: end if;

Line 818: l_wsm_op_reason_codes_tbl(j).Creation_date := sysdate;

814: l_wsm_op_reason_codes_tbl(j).wip_entity_id := p_wltx_resulting_jobs_tbl(i).wip_entity_id;
815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;
816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;
817: l_wsm_op_reason_codes_tbl(j).Last_updated_by := fnd_global.user_id;
818: l_wsm_op_reason_codes_tbl(j).Creation_date := sysdate;
819: l_wsm_op_reason_codes_tbl(j).Last_updated_login := fnd_global.login_id;
820: end loop;
821: end if;
822: if l_wsm_op_reason_codes_tbl.count > 0 then

Line 819: l_wsm_op_reason_codes_tbl(j).Last_updated_login := fnd_global.login_id;

815: l_wsm_op_reason_codes_tbl(j).Created_by := fnd_global.user_id;
816: l_wsm_op_reason_codes_tbl(j).Last_update_date := sysdate;
817: l_wsm_op_reason_codes_tbl(j).Last_updated_by := fnd_global.user_id;
818: l_wsm_op_reason_codes_tbl(j).Creation_date := sysdate;
819: l_wsm_op_reason_codes_tbl(j).Last_updated_login := fnd_global.login_id;
820: end loop;
821: end if;
822: if l_wsm_op_reason_codes_tbl.count > 0 then
823: forall k in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last

Line 822: if l_wsm_op_reason_codes_tbl.count > 0 then

818: l_wsm_op_reason_codes_tbl(j).Creation_date := sysdate;
819: l_wsm_op_reason_codes_tbl(j).Last_updated_login := fnd_global.login_id;
820: end loop;
821: end if;
822: if l_wsm_op_reason_codes_tbl.count > 0 then
823: forall k in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last
824: insert into wsm_op_reason_codes
825: values l_wsm_op_reason_codes_tbl(k);
826: end if;

Line 823: forall k in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last

819: l_wsm_op_reason_codes_tbl(j).Last_updated_login := fnd_global.login_id;
820: end loop;
821: end if;
822: if l_wsm_op_reason_codes_tbl.count > 0 then
823: forall k in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last
824: insert into wsm_op_reason_codes
825: values l_wsm_op_reason_codes_tbl(k);
826: end if;
827: end if;

Line 824: insert into wsm_op_reason_codes

820: end loop;
821: end if;
822: if l_wsm_op_reason_codes_tbl.count > 0 then
823: forall k in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last
824: insert into wsm_op_reason_codes
825: values l_wsm_op_reason_codes_tbl(k);
826: end if;
827: end if;
828: end loop;

Line 825: values l_wsm_op_reason_codes_tbl(k);

821: end if;
822: if l_wsm_op_reason_codes_tbl.count > 0 then
823: forall k in l_wsm_op_reason_codes_tbl.first .. l_wsm_op_reason_codes_tbl.last
824: insert into wsm_op_reason_codes
825: values l_wsm_op_reason_codes_tbl(k);
826: end if;
827: end if;
828: end loop;
829: end if;

Line 836: insert into wsm_op_reason_codes

832: -- This will be handled by the call to OPRNB.copy_mes procedure in the secondary_quantities procedure..
833: if p_wltx_header.transaction_type_id = WSMPCNST.BONUS then
834: --query bom_standard_operations child table and populate reason codes for the new op.;
835: l_counter := p_wltx_resulting_jobs_tbl.first;
836: insert into wsm_op_reason_codes
837: (Organization_id,
838: Wip_entity_id ,
839: Operation_seq_num,
840: Code_Type ,

Line 866: insert into wsm_op_reason_codes

862: where sequence_number = p_wltx_resulting_jobs_tbl(l_counter).starting_operation_seq_num
863: and STANDARD_OPERATION_ID = p_wltx_resulting_jobs_tbl(l_counter).starting_std_op_id
864: );
865:
866: insert into wsm_op_reason_codes
867: (Organization_id,
868: Wip_entity_id ,
869: Operation_seq_num,
870: Code_Type ,

Line 901: ROLLBACK TO start_copy_wsm_op_reason_codes;

897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900:
901: ROLLBACK TO start_copy_wsm_op_reason_codes;
902:
903: x_return_status := G_RET_ERROR;
904: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
905: p_count => x_msg_count ,

Line 911: ROLLBACK TO start_copy_wsm_op_reason_codes;

907: );
908:
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910:
911: ROLLBACK TO start_copy_wsm_op_reason_codes;
912:
913: x_return_status := G_RET_UNEXPECTED;
914: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
915: p_count => x_msg_count ,

Line 920: ROLLBACK TO start_copy_wsm_op_reason_codes;

916: p_data => x_error_msg
917: );
918: WHEN OTHERS THEN
919:
920: ROLLBACK TO start_copy_wsm_op_reason_codes;
921:
922: x_return_status := G_RET_UNEXPECTED;
923: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
924: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))