DBA Data[Home] [Help]

APPS.JTF_IH_PUB_W dependencies on JTF_IH_PUB

Line 1: package body jtf_ih_pub_w as

1: package body jtf_ih_pub_w as
2: /* $Header: JTFIHJWB.pls 115.32 2003/07/14 17:56:34 ialeshin 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 22: procedure rosetta_table_copy_in_p3(t out nocopy jtf_ih_pub.activity_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy jtf_ih_pub.activity_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_300

Line 129: procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

125: end loop;
126: end if;
127: end if;
128: end rosetta_table_copy_in_p3;
129: procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130: , a1 out nocopy JTF_NUMBER_TABLE
131: , a2 out nocopy JTF_NUMBER_TABLE
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 373: procedure rosetta_table_copy_in_p8(t out nocopy jtf_ih_pub.mlcs_tbl_type, a0 JTF_DATE_TABLE

369: end if;
370: end if;
371: end rosetta_table_copy_out_p3;
372:
373: procedure rosetta_table_copy_in_p8(t out nocopy jtf_ih_pub.mlcs_tbl_type, a0 JTF_DATE_TABLE
374: , a1 JTF_VARCHAR2_TABLE_100
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_NUMBER_TABLE
377: , a4 JTF_DATE_TABLE

Line 420: procedure rosetta_table_copy_out_p8(t jtf_ih_pub.mlcs_tbl_type, a0 out nocopy JTF_DATE_TABLE

416: end loop;
417: end if;
418: end if;
419: end rosetta_table_copy_in_p8;
420: procedure rosetta_table_copy_out_p8(t jtf_ih_pub.mlcs_tbl_type, a0 out nocopy JTF_DATE_TABLE
421: , a1 out nocopy JTF_VARCHAR2_TABLE_100
422: , a2 out nocopy JTF_NUMBER_TABLE
423: , a3 out nocopy JTF_NUMBER_TABLE
424: , a4 out nocopy JTF_DATE_TABLE

Line 621: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;

617: , p10_a48 NUMBER := 0-1962.0724
618: )
619:
620: as
621: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
622: ddp_activities jtf_ih_pub.activity_tbl_type;
623: ddindx binary_integer; indx binary_integer;
624: begin
625:

Line 622: ddp_activities jtf_ih_pub.activity_tbl_type;

618: )
619:
620: as
621: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
622: ddp_activities jtf_ih_pub.activity_tbl_type;
623: ddindx binary_integer; indx binary_integer;
624: begin
625:
626: -- copy data to the local IN or IN-OUT args, if any

Line 687: jtf_ih_pub_w.rosetta_table_copy_in_p3(ddp_activities, p11_a0

683: ddp_interaction_rec.primary_party_id := rosetta_g_miss_num_map(p10_a46);
684: ddp_interaction_rec.contact_rel_party_id := rosetta_g_miss_num_map(p10_a47);
685: ddp_interaction_rec.contact_party_id := rosetta_g_miss_num_map(p10_a48);
686:
687: jtf_ih_pub_w.rosetta_table_copy_in_p3(ddp_activities, p11_a0
688: , p11_a1
689: , p11_a2
690: , p11_a3
691: , p11_a4

Line 735: jtf_ih_pub.create_interaction(p_api_version,

731: , p11_a44
732: );
733:
734: -- here's the delegated call to the old PL/SQL routine
735: jtf_ih_pub.create_interaction(p_api_version,
736: p_init_msg_list,
737: p_commit,
738: p_resp_appl_id,
739: p_resp_id,

Line 813: ddp_media jtf_ih_pub.media_rec_type;

809: , p10_a22 VARCHAR2 := fnd_api.g_miss_char
810: )
811:
812: as
813: ddp_media jtf_ih_pub.media_rec_type;
814: ddp_mlcs jtf_ih_pub.mlcs_tbl_type;
815: ddindx binary_integer; indx binary_integer;
816: begin
817:

Line 814: ddp_mlcs jtf_ih_pub.mlcs_tbl_type;

810: )
811:
812: as
813: ddp_media jtf_ih_pub.media_rec_type;
814: ddp_mlcs jtf_ih_pub.mlcs_tbl_type;
815: ddindx binary_integer; indx binary_integer;
816: begin
817:
818: -- copy data to the local IN or IN-OUT args, if any

Line 853: jtf_ih_pub_w.rosetta_table_copy_in_p8(ddp_mlcs, p11_a0

849: ddp_media.bulk_batch_id := rosetta_g_miss_num_map(p10_a20);
850: ddp_media.bulk_interaction_id := rosetta_g_miss_num_map(p10_a21);
851: ddp_media.address := p10_a22;
852:
853: jtf_ih_pub_w.rosetta_table_copy_in_p8(ddp_mlcs, p11_a0
854: , p11_a1
855: , p11_a2
856: , p11_a3
857: , p11_a4

Line 871: jtf_ih_pub.create_mediaitem(p_api_version,

867: , p11_a14
868: );
869:
870: -- here's the delegated call to the old PL/SQL routine
871: jtf_ih_pub.create_mediaitem(p_api_version,
872: p_init_msg_list,
873: p_commit,
874: p_resp_appl_id,
875: p_resp_id,

Line 935: ddp_media_rec jtf_ih_pub.media_rec_type;

931: , p10_a22 VARCHAR2 := fnd_api.g_miss_char
932: )
933:
934: as
935: ddp_media_rec jtf_ih_pub.media_rec_type;
936: ddindx binary_integer; indx binary_integer;
937: begin
938:
939: -- copy data to the local IN or IN-OUT args, if any

Line 976: jtf_ih_pub.create_mediaitem(p_api_version,

972: ddp_media_rec.address := p10_a22;
973:
974:
975: -- here's the delegated call to the old PL/SQL routine
976: jtf_ih_pub.create_mediaitem(p_api_version,
977: p_init_msg_list,
978: p_commit,
979: p_resp_appl_id,
980: p_resp_id,

Line 1031: ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;

1027: , p10_a14 NUMBER := 0-1962.0724
1028: )
1029:
1030: as
1031: ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;
1032: ddindx binary_integer; indx binary_integer;
1033: begin
1034:
1035: -- copy data to the local IN or IN-OUT args, if any

Line 1063: jtf_ih_pub.create_medialifecycle(p_api_version,

1059: ddp_media_lc_rec.bulk_batch_id := rosetta_g_miss_num_map(p10_a13);
1060: ddp_media_lc_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a14);
1061:
1062: -- here's the delegated call to the old PL/SQL routine
1063: jtf_ih_pub.create_medialifecycle(p_api_version,
1064: p_init_msg_list,
1065: p_commit,
1066: p_resp_appl_id,
1067: p_resp_id,

Line 1151: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;

1147: , p10_a48 NUMBER := 0-1962.0724
1148: )
1149:
1150: as
1151: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
1152: ddindx binary_integer; indx binary_integer;
1153: begin
1154:
1155: -- copy data to the local IN or IN-OUT args, if any

Line 1218: jtf_ih_pub.open_interaction(p_api_version,

1214: ddp_interaction_rec.contact_party_id := rosetta_g_miss_num_map(p10_a48);
1215:
1216:
1217: -- here's the delegated call to the old PL/SQL routine
1218: jtf_ih_pub.open_interaction(p_api_version,
1219: p_init_msg_list,
1220: p_commit,
1221: p_resp_appl_id,
1222: p_resp_id,

Line 1308: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;

1304: , p10_a48 NUMBER := 0-1962.0724
1305: )
1306:
1307: as
1308: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
1309: ddindx binary_integer; indx binary_integer;
1310: begin
1311:
1312: -- copy data to the local IN or IN-OUT args, if any

Line 1375: jtf_ih_pub.update_interaction(p_api_version,

1371: ddp_interaction_rec.contact_party_id := rosetta_g_miss_num_map(p10_a48);
1372:
1373:
1374: -- here's the delegated call to the old PL/SQL routine
1375: jtf_ih_pub.update_interaction(p_api_version,
1376: p_init_msg_list,
1377: p_commit,
1378: p_resp_appl_id,
1379: p_resp_id,

Line 1465: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;

1461: , p10_a48 NUMBER := 0-1962.0724
1462: )
1463:
1464: as
1465: ddp_interaction_rec jtf_ih_pub.interaction_rec_type;
1466: ddindx binary_integer; indx binary_integer;
1467: begin
1468:
1469: -- copy data to the local IN or IN-OUT args, if any

Line 1532: jtf_ih_pub.close_interaction(p_api_version,

1528: ddp_interaction_rec.contact_party_id := rosetta_g_miss_num_map(p10_a48);
1529:
1530:
1531: -- here's the delegated call to the old PL/SQL routine
1532: jtf_ih_pub.close_interaction(p_api_version,
1533: p_init_msg_list,
1534: p_commit,
1535: p_resp_appl_id,
1536: p_resp_id,

Line 1618: ddp_activity_rec jtf_ih_pub.activity_rec_type;

1614: , p10_a44 NUMBER := 0-1962.0724
1615: )
1616:
1617: as
1618: ddp_activity_rec jtf_ih_pub.activity_rec_type;
1619: ddindx binary_integer; indx binary_integer;
1620: begin
1621:
1622: -- copy data to the local IN or IN-OUT args, if any

Line 1681: jtf_ih_pub.add_activity(p_api_version,

1677: ddp_activity_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a44);
1678:
1679:
1680: -- here's the delegated call to the old PL/SQL routine
1681: jtf_ih_pub.add_activity(p_api_version,
1682: p_init_msg_list,
1683: p_commit,
1684: p_resp_appl_id,
1685: p_resp_id,

Line 1767: ddp_activity_rec jtf_ih_pub.activity_rec_type;

1763: , p10_a44 NUMBER := 0-1962.0724
1764: )
1765:
1766: as
1767: ddp_activity_rec jtf_ih_pub.activity_rec_type;
1768: ddindx binary_integer; indx binary_integer;
1769: begin
1770:
1771: -- copy data to the local IN or IN-OUT args, if any

Line 1830: jtf_ih_pub.update_activity(p_api_version,

1826: ddp_activity_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a44);
1827:
1828:
1829: -- here's the delegated call to the old PL/SQL routine
1830: jtf_ih_pub.update_activity(p_api_version,
1831: p_init_msg_list,
1832: p_commit,
1833: p_resp_appl_id,
1834: p_resp_id,

Line 1895: jtf_ih_pub.update_activityduration(p_api_version,

1891:
1892:
1893:
1894: -- here's the delegated call to the old PL/SQL routine
1895: jtf_ih_pub.update_activityduration(p_api_version,
1896: p_init_msg_list,
1897: p_commit,
1898: p_resp_appl_id,
1899: p_resp_id,

Line 1963: ddp_media_rec jtf_ih_pub.media_rec_type;

1959: , p10_a22 VARCHAR2 := fnd_api.g_miss_char
1960: )
1961:
1962: as
1963: ddp_media_rec jtf_ih_pub.media_rec_type;
1964: ddindx binary_integer; indx binary_integer;
1965: begin
1966:
1967: -- copy data to the local IN or IN-OUT args, if any

Line 2004: jtf_ih_pub.open_mediaitem(p_api_version,

2000: ddp_media_rec.address := p10_a22;
2001:
2002:
2003: -- here's the delegated call to the old PL/SQL routine
2004: jtf_ih_pub.open_mediaitem(p_api_version,
2005: p_init_msg_list,
2006: p_commit,
2007: p_resp_appl_id,
2008: p_resp_id,

Line 2068: ddp_media_rec jtf_ih_pub.media_rec_type;

2064: , p10_a22 VARCHAR2 := fnd_api.g_miss_char
2065: )
2066:
2067: as
2068: ddp_media_rec jtf_ih_pub.media_rec_type;
2069: ddindx binary_integer; indx binary_integer;
2070: begin
2071:
2072: -- copy data to the local IN or IN-OUT args, if any

Line 2109: jtf_ih_pub.update_mediaitem(p_api_version,

2105: ddp_media_rec.address := p10_a22;
2106:
2107:
2108: -- here's the delegated call to the old PL/SQL routine
2109: jtf_ih_pub.update_mediaitem(p_api_version,
2110: p_init_msg_list,
2111: p_commit,
2112: p_resp_appl_id,
2113: p_resp_id,

Line 2173: ddp_media_rec jtf_ih_pub.media_rec_type;

2169: , p10_a22 VARCHAR2 := fnd_api.g_miss_char
2170: )
2171:
2172: as
2173: ddp_media_rec jtf_ih_pub.media_rec_type;
2174: ddindx binary_integer; indx binary_integer;
2175: begin
2176:
2177: -- copy data to the local IN or IN-OUT args, if any

Line 2214: jtf_ih_pub.close_mediaitem(p_api_version,

2210: ddp_media_rec.address := p10_a22;
2211:
2212:
2213: -- here's the delegated call to the old PL/SQL routine
2214: jtf_ih_pub.close_mediaitem(p_api_version,
2215: p_init_msg_list,
2216: p_commit,
2217: p_resp_appl_id,
2218: p_resp_id,

Line 2270: ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;

2266: , p10_a14 NUMBER := 0-1962.0724
2267: )
2268:
2269: as
2270: ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;
2271: ddindx binary_integer; indx binary_integer;
2272: begin
2273:
2274: -- copy data to the local IN or IN-OUT args, if any

Line 2303: jtf_ih_pub.add_medialifecycle(p_api_version,

2299: ddp_media_lc_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a14);
2300:
2301:
2302: -- here's the delegated call to the old PL/SQL routine
2303: jtf_ih_pub.add_medialifecycle(p_api_version,
2304: p_init_msg_list,
2305: p_commit,
2306: p_resp_appl_id,
2307: p_resp_id,

Line 2359: ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;

2355: , p10_a14 NUMBER := 0-1962.0724
2356: )
2357:
2358: as
2359: ddp_media_lc_rec jtf_ih_pub.media_lc_rec_type;
2360: ddindx binary_integer; indx binary_integer;
2361: begin
2362:
2363: -- copy data to the local IN or IN-OUT args, if any

Line 2392: jtf_ih_pub.update_medialifecycle(p_api_version,

2388: ddp_media_lc_rec.bulk_interaction_id := rosetta_g_miss_num_map(p10_a14);
2389:
2390:
2391: -- here's the delegated call to the old PL/SQL routine
2392: jtf_ih_pub.update_medialifecycle(p_api_version,
2393: p_init_msg_list,
2394: p_commit,
2395: p_resp_appl_id,
2396: p_resp_id,

Line 2419: end jtf_ih_pub_w;

2415:
2416:
2417: end;
2418:
2419: end jtf_ih_pub_w;