[Home] [Help]
1: package body oks_entitlements_pub_w as
2: /* $Header: OKSWENTB.pls 120.3 2005/12/22 10:52 jvarghes noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
2682:
2683:
2684:
2685:
2686: oks_entitlements_pub_w.rosetta_table_copy_out_p16(ddx_all_contracts, p6_a0
2687: , p6_a1
2688: , p6_a2
2689: , p6_a3
2690: , p6_a4
2782:
2783:
2784:
2785:
2786: oks_entitlements_pub_w.rosetta_table_copy_out_p19(ddx_all_lines, p6_a0
2787: , p6_a1
2788: , p6_a2
2789: , p6_a3
2790: , p6_a4
2879:
2880:
2881:
2882:
2883: oks_entitlements_pub_w.rosetta_table_copy_out_p22(ddx_covered_levels, p6_a0
2884: , p6_a1
2885: , p6_a2
2886: , p6_a3
2887: , p6_a4
2996:
2997:
2998:
2999:
3000: oks_entitlements_pub_w.rosetta_table_copy_out_p26(ddx_ent_contracts, p6_a0
3001: , p6_a1
3002: , p6_a2
3003: , p6_a3
3004: , p6_a4
3120:
3121:
3122:
3123:
3124: oks_entitlements_pub_w.rosetta_table_copy_out_p30(ddx_ent_contracts, p6_a0
3125: , p6_a1
3126: , p6_a2
3127: , p6_a3
3128: , p6_a4
3240:
3241:
3242:
3243:
3244: oks_entitlements_pub_w.rosetta_table_copy_out_p34(ddx_ent_contracts, p6_a0
3245: , p6_a1
3246: , p6_a2
3247: , p6_a3
3248: , p6_a4
3335:
3336:
3337:
3338:
3339: oks_entitlements_pub_w.rosetta_table_copy_out_p38(ddx_ent_contracts, p6_a0
3340: , p6_a1
3341: , p6_a2
3342: , p6_a3
3343: , p6_a4
3381:
3382:
3383: ddp_request_date := rosetta_g_miss_date_in_map(p_request_date);
3384:
3385: oks_entitlements_pub_w.rosetta_table_copy_in_p41(ddp_covlevel_tbl_in, p5_a0
3386: , p5_a1
3387: , p5_a2
3388: , p5_a3
3389: );
3418:
3419:
3420:
3421:
3422: oks_entitlements_pub_w.rosetta_table_copy_out_p41(ddx_covlevel_tbl_out, p10_a0
3423: , p10_a1
3424: , p10_a2
3425: , p10_a3
3426: );
3483: ddp_contract_rec.contract_party_id := p2_a9;
3484: ddp_contract_rec.request_date := rosetta_g_miss_date_in_map(p2_a10);
3485: ddp_contract_rec.entitlement_check_yn := p2_a11;
3486:
3487: oks_entitlements_pub_w.rosetta_table_copy_in_p44(ddp_clvl_id_tbl, p3_a0
3488: , p3_a1
3489: );
3490:
3491:
3509:
3510:
3511:
3512:
3513: oks_entitlements_pub_w.rosetta_table_copy_out_p47(ddx_contract_tbl, p7_a0
3514: , p7_a1
3515: , p7_a2
3516: , p7_a3
3517: , p7_a4
3876:
3877:
3878:
3879:
3880: oks_entitlements_pub_w.rosetta_table_copy_out_p60(ddx_ent_contacts, p7_a0
3881: , p7_a1
3882: , p7_a2
3883: , p7_a3
3884: , p7_a4
3938:
3939:
3940:
3941:
3942: oks_entitlements_pub_w.rosetta_table_copy_out_p63(ddx_prf_engineers, p8_a0
3943: , p8_a1
3944: , p8_a2
3945: , p8_a3
3946: , p8_a4
4147:
4148:
4149:
4150:
4151: oks_entitlements_pub_w.rosetta_table_copy_out_p70(ddx_cov_txn_grp_lines, p6_a0
4152: , p6_a1
4153: , p6_a2
4154: , p6_a3
4155: );
4223:
4224:
4225:
4226:
4227: oks_entitlements_pub_w.rosetta_table_copy_out_p73(ddx_txn_bill_types, p7_a0
4228: , p7_a1
4229: , p7_a2
4230: , p7_a3
4231: );
4229: , p7_a2
4230: , p7_a3
4231: );
4232:
4233: oks_entitlements_pub_w.rosetta_table_copy_out_p75(ddx_txn_bill_rates, p8_a0
4234: , p8_a1
4235: , p8_a2
4236: , p8_a3
4237: , p8_a4
4346: ddp_contract_line_rec.line_bill_to_site_id := p3_a7;
4347: ddp_contract_line_rec.line_ship_to_site_id := p3_a8;
4348: ddp_contract_line_rec.line_renewal_type_code := p3_a9;
4349:
4350: oks_entitlements_pub_w.rosetta_table_copy_in_p81(ddp_clvl_id_tbl, p4_a0
4351: , p4_a1
4352: , p4_a2
4353: );
4354:
4375:
4376:
4377:
4378:
4379: oks_entitlements_pub_w.rosetta_table_copy_out_p83(ddx_contract_tbl, p8_a0
4380: , p8_a1
4381: , p8_a2
4382: , p8_a3
4383: , p8_a4
4396: , p8_a17
4397: );
4398: end;
4399:
4400: end oks_entitlements_pub_w;