DBA Data[Home] [Help]

APPS.AS_OSI_LEAD_PUB_W dependencies on AS_OSI_LEAD_PUB_W

Line 1: package body as_osi_lead_pub_w as

1: package body as_osi_lead_pub_w as
2: /* $Header: asxolpab.pls 115.2 2002/12/10 01:32:14 kichan ship $ */
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:

Line 834: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p3_a0

830: p2_a39 := ddp_osi_rec.cust_name;
831: p2_a40 := ddp_osi_rec.site_name;
832: p2_a41 := ddp_osi_rec.oppy_name;
833:
834: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p3_a0
835: , p3_a1
836: );
837: end;
838:

Line 983: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p3_a0

979: p2_a39 := ddp_osi_rec.cust_name;
980: p2_a40 := ddp_osi_rec.site_name;
981: p2_a41 := ddp_osi_rec.oppy_name;
982:
983: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p3_a0
984: , p3_a1
985: );
986:
987: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p4_a0

Line 987: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p4_a0

983: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p3_a0
984: , p3_a1
985: );
986:
987: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p4_a0
988: , p4_a1
989: , p4_a2
990: );
991:

Line 992: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p5_a0

988: , p4_a1
989: , p4_a2
990: );
991:
992: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p5_a0
993: , p5_a1
994: , p5_a2
995: );
996:

Line 997: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p6_a0

993: , p5_a1
994: , p5_a2
995: );
996:
997: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p6_a0
998: , p6_a1
999: , p6_a2
1000: );
1001:

Line 1002: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p7_a0

998: , p6_a1
999: , p6_a2
1000: );
1001:
1002: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p7_a0
1003: , p7_a1
1004: );
1005:
1006: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p8_a0

Line 1006: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p8_a0

1002: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p7_a0
1003: , p7_a1
1004: );
1005:
1006: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p8_a0
1007: , p8_a1
1008: );
1009:
1010: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p9_a0

Line 1010: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p9_a0

1006: as_osi_lead_pub_w.rosetta_table_copy_out_p30(ddp_osi_ovd_tbl, p8_a0
1007: , p8_a1
1008: );
1009:
1010: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p9_a0
1011: , p9_a1
1012: );
1013: end;
1014:

Line 1062: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0

1058: ddp_osi_ovm_tbl);
1059:
1060: -- copy data back from the local variables to OUT or IN-OUT args, if any
1061:
1062: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0
1063: , p1_a1
1064: );
1065:
1066: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p2_a0

Line 1066: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p2_a0

1062: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0
1063: , p1_a1
1064: );
1065:
1066: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p2_a0
1067: , p2_a1
1068: , p2_a2
1069: );
1070:

Line 1071: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p3_a0

1067: , p2_a1
1068: , p2_a2
1069: );
1070:
1071: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p3_a0
1072: , p3_a1
1073: , p3_a2
1074: );
1075:

Line 1076: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p4_a0

1072: , p3_a1
1073: , p3_a2
1074: );
1075:
1076: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p4_a0
1077: , p4_a1
1078: , p4_a2
1079: );
1080:

Line 1081: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p5_a0

1077: , p4_a1
1078: , p4_a2
1079: );
1080:
1081: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p5_a0
1082: , p5_a1
1083: );
1084:
1085: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p6_a0

Line 1085: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p6_a0

1081: as_osi_lead_pub_w.rosetta_table_copy_out_p22(ddp_osi_ccs_tbl, p5_a0
1082: , p5_a1
1083: );
1084:
1085: as_osi_lead_pub_w.rosetta_table_copy_out_p26(ddp_osi_ovm_tbl, p6_a0
1086: , p6_a1
1087: );
1088: end;
1089:

Line 1195: as_osi_lead_pub_w.rosetta_table_copy_in_p30(ddp_osi_ovd_tbl, p4_a0

1191: ddp_osi_rec.cust_name := p3_a39;
1192: ddp_osi_rec.site_name := p3_a40;
1193: ddp_osi_rec.oppy_name := p3_a41;
1194:
1195: as_osi_lead_pub_w.rosetta_table_copy_in_p30(ddp_osi_ovd_tbl, p4_a0
1196: , p4_a1
1197: );
1198:
1199:

Line 1241: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0

1237: ddp_osi_cvb_tbl);
1238:
1239: -- copy data back from the local variables to OUT or IN-OUT args, if any
1240:
1241: as_osi_lead_pub_w.rosetta_table_copy_out_p6(ddp_osi_cvb_tbl, p1_a0
1242: , p1_a1
1243: );
1244: end;
1245:

Line 1266: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p1_a0

1262: ddp_osi_cnb_tbl);
1263:
1264: -- copy data back from the local variables to OUT or IN-OUT args, if any
1265:
1266: as_osi_lead_pub_w.rosetta_table_copy_out_p10(ddp_osi_cnb_tbl, p1_a0
1267: , p1_a1
1268: , p1_a2
1269: );
1270: end;

Line 1296: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p2_a0

1292:
1293: -- copy data back from the local variables to OUT or IN-OUT args, if any
1294:
1295:
1296: as_osi_lead_pub_w.rosetta_table_copy_out_p14(ddp_osi_lkp_tbl, p2_a0
1297: , p2_a1
1298: , p2_a2
1299: );
1300: end;

Line 1326: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p2_a0

1322:
1323: -- copy data back from the local variables to OUT or IN-OUT args, if any
1324:
1325:
1326: as_osi_lead_pub_w.rosetta_table_copy_out_p18(ddp_osi_nam_tbl, p2_a0
1327: , p2_a1
1328: , p2_a2
1329: );
1330: end;

Line 1332: end as_osi_lead_pub_w;

1328: , p2_a2
1329: );
1330: end;
1331:
1332: end as_osi_lead_pub_w;