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.JTF_EC_PUB_W dependencies on JTF_EC_PUB

Line 1: package body jtf_ec_pub_w as

1: package body jtf_ec_pub_w as
2: /* $Header: jtfpecwb.pls 115.1 2002/02/14 13:07:33 pkm 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_p7(t out jtf_ec_pub.esc_ref_docs_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p7(t out jtf_ec_pub.esc_ref_docs_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 85: procedure rosetta_table_copy_out_p7(t jtf_ec_pub.esc_ref_docs_tbl_type, a0 out JTF_NUMBER_TABLE

81: end loop;
82: end if;
83: end if;
84: end rosetta_table_copy_in_p7;
85: procedure rosetta_table_copy_out_p7(t jtf_ec_pub.esc_ref_docs_tbl_type, a0 out JTF_NUMBER_TABLE
86: , a1 out JTF_VARCHAR2_TABLE_100
87: , a2 out JTF_VARCHAR2_TABLE_100
88: , a3 out JTF_NUMBER_TABLE
89: , a4 out JTF_VARCHAR2_TABLE_100

Line 219: procedure rosetta_table_copy_in_p9(t out jtf_ec_pub.esc_contacts_tbl_type, a0 JTF_NUMBER_TABLE

215: end if;
216: end if;
217: end rosetta_table_copy_out_p7;
218:
219: procedure rosetta_table_copy_in_p9(t out jtf_ec_pub.esc_contacts_tbl_type, a0 JTF_NUMBER_TABLE
220: , a1 JTF_NUMBER_TABLE
221: , a2 JTF_NUMBER_TABLE
222: , a3 JTF_VARCHAR2_TABLE_100
223: , a4 JTF_VARCHAR2_TABLE_100

Line 282: procedure rosetta_table_copy_out_p9(t jtf_ec_pub.esc_contacts_tbl_type, a0 out JTF_NUMBER_TABLE

278: end loop;
279: end if;
280: end if;
281: end rosetta_table_copy_in_p9;
282: procedure rosetta_table_copy_out_p9(t jtf_ec_pub.esc_contacts_tbl_type, a0 out JTF_NUMBER_TABLE
283: , a1 out JTF_NUMBER_TABLE
284: , a2 out JTF_NUMBER_TABLE
285: , a3 out JTF_VARCHAR2_TABLE_100
286: , a4 out JTF_VARCHAR2_TABLE_100

Line 416: procedure rosetta_table_copy_in_p11(t out jtf_ec_pub.esc_cont_points_tbl_type, a0 JTF_NUMBER_TABLE

412: end if;
413: end if;
414: end rosetta_table_copy_out_p9;
415:
416: procedure rosetta_table_copy_in_p11(t out jtf_ec_pub.esc_cont_points_tbl_type, a0 JTF_NUMBER_TABLE
417: , a1 JTF_VARCHAR2_TABLE_100
418: , a2 JTF_NUMBER_TABLE
419: , a3 JTF_NUMBER_TABLE
420: , a4 JTF_NUMBER_TABLE

Line 477: procedure rosetta_table_copy_out_p11(t jtf_ec_pub.esc_cont_points_tbl_type, a0 out JTF_NUMBER_TABLE

473: end loop;
474: end if;
475: end if;
476: end rosetta_table_copy_in_p11;
477: procedure rosetta_table_copy_out_p11(t jtf_ec_pub.esc_cont_points_tbl_type, a0 out JTF_NUMBER_TABLE
478: , a1 out JTF_VARCHAR2_TABLE_100
479: , a2 out JTF_NUMBER_TABLE
480: , a3 out JTF_NUMBER_TABLE
481: , a4 out JTF_NUMBER_TABLE

Line 606: procedure rosetta_table_copy_in_p13(t out jtf_ec_pub.notes_tbl_type, a0 JTF_VARCHAR2_TABLE_100

602: end if;
603: end if;
604: end rosetta_table_copy_out_p11;
605:
606: procedure rosetta_table_copy_in_p13(t out jtf_ec_pub.notes_tbl_type, a0 JTF_VARCHAR2_TABLE_100
607: , a1 JTF_NUMBER_TABLE
608: , a2 JTF_VARCHAR2_TABLE_2000
609: , a3 JTF_VARCHAR2_TABLE_32767
610: , a4 JTF_VARCHAR2_TABLE_300

Line 647: procedure rosetta_table_copy_out_p13(t jtf_ec_pub.notes_tbl_type, a0 out JTF_VARCHAR2_TABLE_100

643: end loop;
644: end if;
645: end if;
646: end rosetta_table_copy_in_p13;
647: procedure rosetta_table_copy_out_p13(t jtf_ec_pub.notes_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
648: , a1 out JTF_NUMBER_TABLE
649: , a2 out JTF_VARCHAR2_TABLE_2000
650: , a3 out JTF_VARCHAR2_TABLE_32767
651: , a4 out JTF_VARCHAR2_TABLE_300

Line 853: ddp_esc_record jtf_ec_pub.esc_rec_type;

849: , x_esc_number out NUMBER
850: , x_workflow_process_id out VARCHAR2
851: )
852: as
853: ddp_esc_record jtf_ec_pub.esc_rec_type;
854: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
855: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
856: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
857: ddp_notes jtf_ec_pub.notes_tbl_type;

Line 854: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;

850: , x_workflow_process_id out VARCHAR2
851: )
852: as
853: ddp_esc_record jtf_ec_pub.esc_rec_type;
854: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
855: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
856: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
857: ddp_notes jtf_ec_pub.notes_tbl_type;
858: ddindx binary_integer; indx binary_integer;

Line 855: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;

851: )
852: as
853: ddp_esc_record jtf_ec_pub.esc_rec_type;
854: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
855: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
856: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
857: ddp_notes jtf_ec_pub.notes_tbl_type;
858: ddindx binary_integer; indx binary_integer;
859: begin

Line 856: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;

852: as
853: ddp_esc_record jtf_ec_pub.esc_rec_type;
854: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
855: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
856: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
857: ddp_notes jtf_ec_pub.notes_tbl_type;
858: ddindx binary_integer; indx binary_integer;
859: begin
860:

Line 857: ddp_notes jtf_ec_pub.notes_tbl_type;

853: ddp_esc_record jtf_ec_pub.esc_rec_type;
854: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
855: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
856: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
857: ddp_notes jtf_ec_pub.notes_tbl_type;
858: ddindx binary_integer; indx binary_integer;
859: begin
860:
861: -- copy data to the local IN or IN-OUT args, if any

Line 905: jtf_ec_pub_w.rosetta_table_copy_in_p7(ddp_reference_documents, p12_a0

901: ddp_esc_record.attribute14 := p11_a28;
902: ddp_esc_record.attribute15 := p11_a29;
903: ddp_esc_record.attribute_category := p11_a30;
904:
905: jtf_ec_pub_w.rosetta_table_copy_in_p7(ddp_reference_documents, p12_a0
906: , p12_a1
907: , p12_a2
908: , p12_a3
909: , p12_a4

Line 930: jtf_ec_pub_w.rosetta_table_copy_in_p9(ddp_esc_contacts, p13_a0

926: , p12_a21
927: , p12_a22
928: );
929:
930: jtf_ec_pub_w.rosetta_table_copy_in_p9(ddp_esc_contacts, p13_a0
931: , p13_a1
932: , p13_a2
933: , p13_a3
934: , p13_a4

Line 955: jtf_ec_pub_w.rosetta_table_copy_in_p11(ddp_cont_points, p14_a0

951: , p13_a21
952: , p13_a22
953: );
954:
955: jtf_ec_pub_w.rosetta_table_copy_in_p11(ddp_cont_points, p14_a0
956: , p14_a1
957: , p14_a2
958: , p14_a3
959: , p14_a4

Line 979: jtf_ec_pub_w.rosetta_table_copy_in_p13(ddp_notes, p15_a0

975: , p14_a20
976: , p14_a21
977: );
978:
979: jtf_ec_pub_w.rosetta_table_copy_in_p13(ddp_notes, p15_a0
980: , p15_a1
981: , p15_a2
982: , p15_a3
983: , p15_a4

Line 997: jtf_ec_pub.create_escalation(p_api_version,

993:
994:
995:
996: -- here's the delegated call to the old PL/SQL routine
997: jtf_ec_pub.create_escalation(p_api_version,
998: p_init_msg_list,
999: p_commit,
1000: x_return_status,
1001: x_msg_count,

Line 1166: ddp_esc_record jtf_ec_pub.esc_rec_type;

1162: , x_object_version_number out NUMBER
1163: , x_workflow_process_id out VARCHAR2
1164: )
1165: as
1166: ddp_esc_record jtf_ec_pub.esc_rec_type;
1167: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
1168: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
1169: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
1170: ddp_notes jtf_ec_pub.notes_tbl_type;

Line 1167: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;

1163: , x_workflow_process_id out VARCHAR2
1164: )
1165: as
1166: ddp_esc_record jtf_ec_pub.esc_rec_type;
1167: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
1168: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
1169: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
1170: ddp_notes jtf_ec_pub.notes_tbl_type;
1171: ddindx binary_integer; indx binary_integer;

Line 1168: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;

1164: )
1165: as
1166: ddp_esc_record jtf_ec_pub.esc_rec_type;
1167: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
1168: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
1169: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
1170: ddp_notes jtf_ec_pub.notes_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin

Line 1169: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;

1165: as
1166: ddp_esc_record jtf_ec_pub.esc_rec_type;
1167: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
1168: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
1169: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
1170: ddp_notes jtf_ec_pub.notes_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin
1173:

Line 1170: ddp_notes jtf_ec_pub.notes_tbl_type;

1166: ddp_esc_record jtf_ec_pub.esc_rec_type;
1167: ddp_reference_documents jtf_ec_pub.esc_ref_docs_tbl_type;
1168: ddp_esc_contacts jtf_ec_pub.esc_contacts_tbl_type;
1169: ddp_cont_points jtf_ec_pub.esc_cont_points_tbl_type;
1170: ddp_notes jtf_ec_pub.notes_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin
1173:
1174: -- copy data to the local IN or IN-OUT args, if any

Line 1220: jtf_ec_pub_w.rosetta_table_copy_in_p7(ddp_reference_documents, p14_a0

1216: ddp_esc_record.attribute14 := p13_a28;
1217: ddp_esc_record.attribute15 := p13_a29;
1218: ddp_esc_record.attribute_category := p13_a30;
1219:
1220: jtf_ec_pub_w.rosetta_table_copy_in_p7(ddp_reference_documents, p14_a0
1221: , p14_a1
1222: , p14_a2
1223: , p14_a3
1224: , p14_a4

Line 1245: jtf_ec_pub_w.rosetta_table_copy_in_p9(ddp_esc_contacts, p15_a0

1241: , p14_a21
1242: , p14_a22
1243: );
1244:
1245: jtf_ec_pub_w.rosetta_table_copy_in_p9(ddp_esc_contacts, p15_a0
1246: , p15_a1
1247: , p15_a2
1248: , p15_a3
1249: , p15_a4

Line 1270: jtf_ec_pub_w.rosetta_table_copy_in_p11(ddp_cont_points, p16_a0

1266: , p15_a21
1267: , p15_a22
1268: );
1269:
1270: jtf_ec_pub_w.rosetta_table_copy_in_p11(ddp_cont_points, p16_a0
1271: , p16_a1
1272: , p16_a2
1273: , p16_a3
1274: , p16_a4

Line 1294: jtf_ec_pub_w.rosetta_table_copy_in_p13(ddp_notes, p17_a0

1290: , p16_a20
1291: , p16_a21
1292: );
1293:
1294: jtf_ec_pub_w.rosetta_table_copy_in_p13(ddp_notes, p17_a0
1295: , p17_a1
1296: , p17_a2
1297: , p17_a3
1298: , p17_a4

Line 1311: jtf_ec_pub.update_escalation(p_api_version,

1307:
1308:
1309:
1310: -- here's the delegated call to the old PL/SQL routine
1311: jtf_ec_pub.update_escalation(p_api_version,
1312: p_init_msg_list,
1313: p_commit,
1314: x_return_status,
1315: x_msg_count,

Line 1354: end jtf_ec_pub_w;

1350:
1351:
1352: end;
1353:
1354: end jtf_ec_pub_w;