[Home] [Help]
1: PACKAGE BODY EAM_PROCESS_SAFETY_PUB_W AS
2: /* $Header: EAMPSAWB.pls 120.0 2011/03/08 08:08:50 vboddapa noship $ */
3: /***************************************************************************
4: --
5: -- Copyright (c) 2011 Oracle Corporation, Redwood Shores, CA, USA
2285: ddp_iso_header_rec.creation_date := p4_a50;
2286: ddp_iso_header_rec.user_id := p4_a51;
2287: ddp_iso_header_rec.responsibility_id := p4_a52;
2288:
2289: eam_process_safety_pub_w.rosetta_table_copy_in_p9(ddp_establish_iso_tbl, p5_a0
2290: , p5_a1
2291: , p5_a2
2292: , p5_a3
2293: , p5_a4
2340: , p5_a51
2341: , p5_a52
2342: );
2343:
2344: eam_process_safety_pub_w.rosetta_table_copy_in_p9(ddp_re_establish_iso_tbl, p6_a0
2345: , p6_a1
2346: , p6_a2
2347: , p6_a3
2348: , p6_a4
2395: , p6_a51
2396: , p6_a52
2397: );
2398:
2399: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_isolated_asset_tbl, p7_a0
2400: , p7_a1
2401: , p7_a2
2402: , p7_a3
2403: , p7_a4
2825: ddp_work_clearance_header_rec.creation_date := p4_a51;
2826: ddp_work_clearance_header_rec.user_id := p4_a52;
2827: ddp_work_clearance_header_rec.responsibility_id := p4_a53;
2828:
2829: eam_process_safety_pub_w.rosetta_table_copy_in_p9(ddp_clearance_establish_tbl, p5_a0
2830: , p5_a1
2831: , p5_a2
2832: , p5_a3
2833: , p5_a4
2880: , p5_a51
2881: , p5_a52
2882: );
2883:
2884: eam_process_safety_pub_w.rosetta_table_copy_in_p9(ddp_clearance_re_estabish_tbl, p6_a0
2885: , p6_a1
2886: , p6_a2
2887: , p6_a3
2888: , p6_a4
2935: , p6_a51
2936: , p6_a52
2937: );
2938:
2939: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_clearance_wo_asso_tbl, p7_a0
2940: , p7_a1
2941: , p7_a2
2942: , p7_a3
2943: , p7_a4
2983: , p7_a44
2984: , p7_a45
2985: );
2986:
2987: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_clearance_permit_asso_tbl, p8_a0
2988: , p8_a1
2989: , p8_a2
2990: , p8_a3
2991: , p8_a4
3367: ddp_work_permit_header_rec.creation_date := p4_a48;
3368: ddp_work_permit_header_rec.user_id := p4_a49;
3369: ddp_work_permit_header_rec.responsibility_id := p4_a50;
3370:
3371: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_permit_wo_association_tbl, p5_a0
3372: , p5_a1
3373: , p5_a2
3374: , p5_a3
3375: , p5_a4
3415: , p5_a44
3416: , p5_a45
3417: );
3418:
3419: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_permit_clearance_asso_tbl, p6_a0
3420: , p6_a1
3421: , p6_a2
3422: , p6_a3
3423: , p6_a4
3643: else ddp_init_msg_list := true;
3644: end if;
3645:
3646:
3647: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_permit_clearance_asso_tbl, p4_a0
3648: , p4_a1
3649: , p4_a2
3650: , p4_a3
3651: , p4_a4
3798: else ddp_init_msg_list := true;
3799: end if;
3800:
3801:
3802: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_clearance_wo_asso_tbl, p4_a0
3803: , p4_a1
3804: , p4_a2
3805: , p4_a3
3806: , p4_a4
3953: else ddp_init_msg_list := true;
3954: end if;
3955:
3956:
3957: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_permit_wo_association_tbl, p4_a0
3958: , p4_a1
3959: , p4_a2
3960: , p4_a3
3961: , p4_a4
4108: else ddp_init_msg_list := true;
4109: end if;
4110:
4111:
4112: eam_process_safety_pub_w.rosetta_table_copy_in_p8(ddp_isolated_assets_tbl, p4_a0
4113: , p4_a1
4114: , p4_a2
4115: , p4_a3
4116: , p4_a4
4188:
4189:
4190: end;
4191:
4192: END EAM_PROCESS_SAFETY_PUB_W;