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_FM_REQUEST_GRP_W dependencies on JTF_FM_REQUEST_GRP

Line 1: package body jtf_fm_request_grp_w as

1: package body jtf_fm_request_grp_w as
2: /* $Header: jtfgfmwb.pls 120.2 2005/12/27 00:33 anchaudh 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_fm_request_grp.g_varchar_tbl_type, a0 JTF_VARCHAR2_TABLE_1000) as

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_fm_request_grp.g_varchar_tbl_type, a0 JTF_VARCHAR2_TABLE_1000) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p3(t jtf_fm_request_grp.g_varchar_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_1000) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p3;
40: procedure rosetta_table_copy_out_p3(t jtf_fm_request_grp.g_varchar_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_1000) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_1000();

Line 63: procedure rosetta_table_copy_in_p5(t out nocopy jtf_fm_request_grp.g_number_tbl_type, a0 JTF_NUMBER_TABLE) as

59: end if;
60: end if;
61: end rosetta_table_copy_out_p3;
62:
63: procedure rosetta_table_copy_in_p5(t out nocopy jtf_fm_request_grp.g_number_tbl_type, a0 JTF_NUMBER_TABLE) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if a0 is not null and a0.count > 0 then
67: if a0.count > 0 then

Line 81: procedure rosetta_table_copy_out_p5(t jtf_fm_request_grp.g_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p5;
81: procedure rosetta_table_copy_out_p5(t jtf_fm_request_grp.g_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();

Line 130: ddp_bind_var jtf_fm_request_grp.g_varchar_tbl_type;

126: , x_content_xml out nocopy VARCHAR2
127: )
128:
129: as
130: ddp_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
131: ddp_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
132: ddp_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
133: ddindx binary_integer; indx binary_integer;
134: begin

Line 131: ddp_bind_val jtf_fm_request_grp.g_varchar_tbl_type;

127: )
128:
129: as
130: ddp_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
131: ddp_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
132: ddp_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
133: ddindx binary_integer; indx binary_integer;
134: begin
135:

Line 132: ddp_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;

128:
129: as
130: ddp_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
131: ddp_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
132: ddp_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
133: ddindx binary_integer; indx binary_integer;
134: begin
135:
136: -- copy data to the local IN or IN-OUT args, if any

Line 155: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var, p_bind_var);

151:
152:
153:
154:
155: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var, p_bind_var);
156:
157: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_val, p_bind_val);
158:
159: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var_type, p_bind_var_type);

Line 157: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_val, p_bind_val);

153:
154:
155: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var, p_bind_var);
156:
157: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_val, p_bind_val);
158:
159: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var_type, p_bind_var_type);
160:
161:

Line 159: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var_type, p_bind_var_type);

155: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var, p_bind_var);
156:
157: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_val, p_bind_val);
158:
159: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var_type, p_bind_var_type);
160:
161:
162:
163: -- here's the delegated call to the old PL/SQL routine

Line 164: jtf_fm_request_grp.get_content_xml(p_api_version,

160:
161:
162:
163: -- here's the delegated call to the old PL/SQL routine
164: jtf_fm_request_grp.get_content_xml(p_api_version,
165: p_init_msg_list,
166: p_commit,
167: p_validation_level,
168: x_return_status,

Line 241: ddp_bind_var jtf_fm_request_grp.g_varchar_tbl_type;

237: , p_version NUMBER
238: )
239:
240: as
241: ddp_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
242: ddp_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
243: ddp_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
244: ddindx binary_integer; indx binary_integer;
245: begin

Line 242: ddp_bind_val jtf_fm_request_grp.g_varchar_tbl_type;

238: )
239:
240: as
241: ddp_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
242: ddp_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
243: ddp_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
244: ddindx binary_integer; indx binary_integer;
245: begin
246:

Line 243: ddp_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;

239:
240: as
241: ddp_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
242: ddp_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
243: ddp_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
244: ddindx binary_integer; indx binary_integer;
245: begin
246:
247: -- copy data to the local IN or IN-OUT args, if any

Line 266: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var, p_bind_var);

262:
263:
264:
265:
266: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var, p_bind_var);
267:
268: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_val, p_bind_val);
269:
270: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var_type, p_bind_var_type);

Line 268: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_val, p_bind_val);

264:
265:
266: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var, p_bind_var);
267:
268: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_val, p_bind_val);
269:
270: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var_type, p_bind_var_type);
271:
272:

Line 270: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var_type, p_bind_var_type);

266: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var, p_bind_var);
267:
268: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_val, p_bind_val);
269:
270: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_bind_var_type, p_bind_var_type);
271:
272:
273:
274:

Line 277: jtf_fm_request_grp.get_content_xml(p_api_version,

273:
274:
275:
276: -- here's the delegated call to the old PL/SQL routine
277: jtf_fm_request_grp.get_content_xml(p_api_version,
278: p_init_msg_list,
279: p_commit,
280: p_validation_level,
281: x_return_status,

Line 358: jtf_fm_request_grp.cancel_request(p_api_version,

354:
355: ddp_submit_dt_tm := rosetta_g_miss_date_in_map(p_submit_dt_tm);
356:
357: -- here's the delegated call to the old PL/SQL routine
358: jtf_fm_request_grp.cancel_request(p_api_version,
359: p_init_msg_list,
360: p_commit,
361: p_validation_level,
362: x_return_status,

Line 402: ddp_content_type jtf_fm_request_grp.g_varchar_tbl_type;

398: , x_content_xml out nocopy VARCHAR2
399: )
400:
401: as
402: ddp_content_type jtf_fm_request_grp.g_varchar_tbl_type;
403: ddp_content_id jtf_fm_request_grp.g_number_tbl_type;
404: ddp_content_nm jtf_fm_request_grp.g_varchar_tbl_type;
405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;
406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;

Line 403: ddp_content_id jtf_fm_request_grp.g_number_tbl_type;

399: )
400:
401: as
402: ddp_content_type jtf_fm_request_grp.g_varchar_tbl_type;
403: ddp_content_id jtf_fm_request_grp.g_number_tbl_type;
404: ddp_content_nm jtf_fm_request_grp.g_varchar_tbl_type;
405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;
406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;
407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;

Line 404: ddp_content_nm jtf_fm_request_grp.g_varchar_tbl_type;

400:
401: as
402: ddp_content_type jtf_fm_request_grp.g_varchar_tbl_type;
403: ddp_content_id jtf_fm_request_grp.g_number_tbl_type;
404: ddp_content_nm jtf_fm_request_grp.g_varchar_tbl_type;
405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;
406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;
407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;

Line 405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;

401: as
402: ddp_content_type jtf_fm_request_grp.g_varchar_tbl_type;
403: ddp_content_id jtf_fm_request_grp.g_number_tbl_type;
404: ddp_content_nm jtf_fm_request_grp.g_varchar_tbl_type;
405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;
406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;
407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;

Line 406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;

402: ddp_content_type jtf_fm_request_grp.g_varchar_tbl_type;
403: ddp_content_id jtf_fm_request_grp.g_number_tbl_type;
404: ddp_content_nm jtf_fm_request_grp.g_varchar_tbl_type;
405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;
406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;
407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
410: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;

Line 407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;

403: ddp_content_id jtf_fm_request_grp.g_number_tbl_type;
404: ddp_content_nm jtf_fm_request_grp.g_varchar_tbl_type;
405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;
406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;
407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
410: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
411: ddp_user_note jtf_fm_request_grp.g_varchar_tbl_type;

Line 408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;

404: ddp_content_nm jtf_fm_request_grp.g_varchar_tbl_type;
405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;
406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;
407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
410: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
411: ddp_user_note jtf_fm_request_grp.g_varchar_tbl_type;
412: ddp_quantity jtf_fm_request_grp.g_number_tbl_type;

Line 409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;

405: ddp_document_type jtf_fm_request_grp.g_varchar_tbl_type;
406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;
407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
410: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
411: ddp_user_note jtf_fm_request_grp.g_varchar_tbl_type;
412: ddp_quantity jtf_fm_request_grp.g_number_tbl_type;
413: ddindx binary_integer; indx binary_integer;

Line 410: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;

406: ddp_media_type jtf_fm_request_grp.g_varchar_tbl_type;
407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
410: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
411: ddp_user_note jtf_fm_request_grp.g_varchar_tbl_type;
412: ddp_quantity jtf_fm_request_grp.g_number_tbl_type;
413: ddindx binary_integer; indx binary_integer;
414: begin

Line 411: ddp_user_note jtf_fm_request_grp.g_varchar_tbl_type;

407: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
410: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
411: ddp_user_note jtf_fm_request_grp.g_varchar_tbl_type;
412: ddp_quantity jtf_fm_request_grp.g_number_tbl_type;
413: ddindx binary_integer; indx binary_integer;
414: begin
415:

Line 412: ddp_quantity jtf_fm_request_grp.g_number_tbl_type;

408: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
409: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
410: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
411: ddp_user_note jtf_fm_request_grp.g_varchar_tbl_type;
412: ddp_quantity jtf_fm_request_grp.g_number_tbl_type;
413: ddindx binary_integer; indx binary_integer;
414: begin
415:
416: -- copy data to the local IN or IN-OUT args, if any

Line 425: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_type, p_content_type);

421:
422:
423:
424:
425: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_type, p_content_type);
426:
427: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_content_id, p_content_id);
428:
429: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_nm, p_content_nm);

Line 427: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_content_id, p_content_id);

423:
424:
425: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_type, p_content_type);
426:
427: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_content_id, p_content_id);
428:
429: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_nm, p_content_nm);
430:
431: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_document_type, p_document_type);

Line 429: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_nm, p_content_nm);

425: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_type, p_content_type);
426:
427: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_content_id, p_content_id);
428:
429: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_nm, p_content_nm);
430:
431: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_document_type, p_document_type);
432:
433: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_media_type, p_media_type);

Line 431: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_document_type, p_document_type);

427: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_content_id, p_content_id);
428:
429: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_nm, p_content_nm);
430:
431: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_document_type, p_document_type);
432:
433: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_media_type, p_media_type);
434:
435: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);

Line 433: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_media_type, p_media_type);

429: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_content_nm, p_content_nm);
430:
431: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_document_type, p_document_type);
432:
433: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_media_type, p_media_type);
434:
435: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);
436:
437: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);

Line 435: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);

431: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_document_type, p_document_type);
432:
433: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_media_type, p_media_type);
434:
435: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);
436:
437: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);
438:
439: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);

Line 437: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);

433: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_media_type, p_media_type);
434:
435: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);
436:
437: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);
438:
439: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);
440:
441: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);

Line 439: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);

435: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);
436:
437: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);
438:
439: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);
440:
441: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);
442:
443: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_user_note, p_user_note);

Line 441: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);

437: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);
438:
439: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);
440:
441: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);
442:
443: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_user_note, p_user_note);
444:
445: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_quantity, p_quantity);

Line 443: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_user_note, p_user_note);

439: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);
440:
441: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);
442:
443: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_user_note, p_user_note);
444:
445: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_quantity, p_quantity);
446:
447:

Line 445: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_quantity, p_quantity);

441: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);
442:
443: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_user_note, p_user_note);
444:
445: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_quantity, p_quantity);
446:
447:
448: -- here's the delegated call to the old PL/SQL routine
449: jtf_fm_request_grp.get_multiple_content_xml(p_api_version,

Line 449: jtf_fm_request_grp.get_multiple_content_xml(p_api_version,

445: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_quantity, p_quantity);
446:
447:
448: -- here's the delegated call to the old PL/SQL routine
449: jtf_fm_request_grp.get_multiple_content_xml(p_api_version,
450: p_init_msg_list,
451: p_commit,
452: p_validation_level,
453: x_return_status,

Line 526: ddp_party_id jtf_fm_request_grp.g_number_tbl_type;

522: , p_per_user_history VARCHAR2
523: )
524:
525: as
526: ddp_party_id jtf_fm_request_grp.g_number_tbl_type;
527: ddp_party_name jtf_fm_request_grp.g_varchar_tbl_type;
528: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
529: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
530: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;

Line 527: ddp_party_name jtf_fm_request_grp.g_varchar_tbl_type;

523: )
524:
525: as
526: ddp_party_id jtf_fm_request_grp.g_number_tbl_type;
527: ddp_party_name jtf_fm_request_grp.g_varchar_tbl_type;
528: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
529: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
530: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
531: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;

Line 528: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;

524:
525: as
526: ddp_party_id jtf_fm_request_grp.g_number_tbl_type;
527: ddp_party_name jtf_fm_request_grp.g_varchar_tbl_type;
528: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
529: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
530: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
531: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
532: ddindx binary_integer; indx binary_integer;

Line 529: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;

525: as
526: ddp_party_id jtf_fm_request_grp.g_number_tbl_type;
527: ddp_party_name jtf_fm_request_grp.g_varchar_tbl_type;
528: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
529: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
530: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
531: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
532: ddindx binary_integer; indx binary_integer;
533: begin

Line 530: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;

526: ddp_party_id jtf_fm_request_grp.g_number_tbl_type;
527: ddp_party_name jtf_fm_request_grp.g_varchar_tbl_type;
528: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
529: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
530: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
531: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
532: ddindx binary_integer; indx binary_integer;
533: begin
534:

Line 531: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;

527: ddp_party_name jtf_fm_request_grp.g_varchar_tbl_type;
528: ddp_printer jtf_fm_request_grp.g_varchar_tbl_type;
529: ddp_email jtf_fm_request_grp.g_varchar_tbl_type;
530: ddp_fax jtf_fm_request_grp.g_varchar_tbl_type;
531: ddp_file_path jtf_fm_request_grp.g_varchar_tbl_type;
532: ddindx binary_integer; indx binary_integer;
533: begin
534:
535: -- copy data to the local IN or IN-OUT args, if any

Line 555: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_party_id, p_party_id);

551:
552:
553:
554:
555: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_party_id, p_party_id);
556:
557: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_party_name, p_party_name);
558:
559: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);

Line 557: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_party_name, p_party_name);

553:
554:
555: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_party_id, p_party_id);
556:
557: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_party_name, p_party_name);
558:
559: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);
560:
561: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);

Line 559: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);

555: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_party_id, p_party_id);
556:
557: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_party_name, p_party_name);
558:
559: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);
560:
561: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);
562:
563: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);

Line 561: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);

557: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_party_name, p_party_name);
558:
559: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);
560:
561: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);
562:
563: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);
564:
565: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);

Line 563: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);

559: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_printer, p_printer);
560:
561: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);
562:
563: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);
564:
565: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);
566:
567:

Line 565: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);

561: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_email, p_email);
562:
563: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_fax, p_fax);
564:
565: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_file_path, p_file_path);
566:
567:
568:
569:

Line 574: jtf_fm_request_grp.submit_batch_request(p_api_version,

570:
571:
572:
573: -- here's the delegated call to the old PL/SQL routine
574: jtf_fm_request_grp.submit_batch_request(p_api_version,
575: p_init_msg_list,
576: p_commit,
577: p_validation_level,
578: x_return_status,

Line 671: ddp_mass_bind_var jtf_fm_request_grp.g_varchar_tbl_type;

667: , p_mass_bind_val JTF_VARCHAR2_TABLE_1000
668: )
669:
670: as
671: ddp_mass_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
672: ddp_mass_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
673: ddp_mass_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
674: ddindx binary_integer; indx binary_integer;
675: begin

Line 672: ddp_mass_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;

668: )
669:
670: as
671: ddp_mass_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
672: ddp_mass_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
673: ddp_mass_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
674: ddindx binary_integer; indx binary_integer;
675: begin
676:

Line 673: ddp_mass_bind_val jtf_fm_request_grp.g_varchar_tbl_type;

669:
670: as
671: ddp_mass_bind_var jtf_fm_request_grp.g_varchar_tbl_type;
672: ddp_mass_bind_var_type jtf_fm_request_grp.g_varchar_tbl_type;
673: ddp_mass_bind_val jtf_fm_request_grp.g_varchar_tbl_type;
674: ddindx binary_integer; indx binary_integer;
675: begin
676:
677: -- copy data to the local IN or IN-OUT args, if any

Line 704: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_var, p_mass_bind_var);

700:
701:
702:
703:
704: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_var, p_mass_bind_var);
705:
706: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_var_type, p_mass_bind_var_type);
707:
708: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_val, p_mass_bind_val);

Line 706: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_var_type, p_mass_bind_var_type);

702:
703:
704: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_var, p_mass_bind_var);
705:
706: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_var_type, p_mass_bind_var_type);
707:
708: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_val, p_mass_bind_val);
709:
710: -- here's the delegated call to the old PL/SQL routine

Line 708: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_val, p_mass_bind_val);

704: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_var, p_mass_bind_var);
705:
706: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_var_type, p_mass_bind_var_type);
707:
708: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_val, p_mass_bind_val);
709:
710: -- here's the delegated call to the old PL/SQL routine
711: jtf_fm_request_grp.submit_mass_request(p_api_version,
712: p_init_msg_list,

Line 711: jtf_fm_request_grp.submit_mass_request(p_api_version,

707:
708: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_mass_bind_val, p_mass_bind_val);
709:
710: -- here's the delegated call to the old PL/SQL routine
711: jtf_fm_request_grp.submit_mass_request(p_api_version,
712: p_init_msg_list,
713: p_commit,
714: p_validation_level,
715: x_return_status,

Line 800: jtf_fm_request_grp.new_cancel_request(p_api_version,

796:
797: ddp_submit_dt_tm := rosetta_g_miss_date_in_map(p_submit_dt_tm);
798:
799: -- here's the delegated call to the old PL/SQL routine
800: jtf_fm_request_grp.new_cancel_request(p_api_version,
801: p_init_msg_list,
802: p_commit,
803: p_validation_level,
804: x_return_status,

Line 834: ddp_job jtf_fm_request_grp.g_number_tbl_type;

830: , x_return_status out nocopy VARCHAR2
831: )
832:
833: as
834: ddp_job jtf_fm_request_grp.g_number_tbl_type;
835: ddp_corrected_address jtf_fm_request_grp.g_varchar_tbl_type;
836: ddindx binary_integer; indx binary_integer;
837: begin
838:

Line 835: ddp_corrected_address jtf_fm_request_grp.g_varchar_tbl_type;

831: )
832:
833: as
834: ddp_job jtf_fm_request_grp.g_number_tbl_type;
835: ddp_corrected_address jtf_fm_request_grp.g_varchar_tbl_type;
836: ddindx binary_integer; indx binary_integer;
837: begin
838:
839: -- copy data to the local IN or IN-OUT args, if any

Line 847: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_job, p_job);

843:
844:
845:
846:
847: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_job, p_job);
848:
849: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_corrected_address, p_corrected_address);
850:
851:

Line 849: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_corrected_address, p_corrected_address);

845:
846:
847: jtf_fm_request_grp_w.rosetta_table_copy_in_p5(ddp_job, p_job);
848:
849: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_corrected_address, p_corrected_address);
850:
851:
852: -- here's the delegated call to the old PL/SQL routine
853: jtf_fm_request_grp.correct_malformed(p_api_version,

Line 853: jtf_fm_request_grp.correct_malformed(p_api_version,

849: jtf_fm_request_grp_w.rosetta_table_copy_in_p3(ddp_corrected_address, p_corrected_address);
850:
851:
852: -- here's the delegated call to the old PL/SQL routine
853: jtf_fm_request_grp.correct_malformed(p_api_version,
854: p_init_msg_list,
855: p_commit,
856: p_validation_level,
857: x_msg_count,

Line 888: ddx_request_id jtf_fm_request_grp.g_number_tbl_type;

884: , x_return_status out nocopy VARCHAR2
885: )
886:
887: as
888: ddx_request_id jtf_fm_request_grp.g_number_tbl_type;
889: ddindx binary_integer; indx binary_integer;
890: begin
891:
892: -- copy data to the local IN or IN-OUT args, if any

Line 903: jtf_fm_request_grp.resubmit_malformed(p_api_version,

899:
900:
901:
902: -- here's the delegated call to the old PL/SQL routine
903: jtf_fm_request_grp.resubmit_malformed(p_api_version,
904: p_init_msg_list,
905: p_commit,
906: p_validation_level,
907: x_msg_count,

Line 921: jtf_fm_request_grp_w.rosetta_table_copy_out_p5(ddx_request_id, x_request_id);

917:
918:
919:
920:
921: jtf_fm_request_grp_w.rosetta_table_copy_out_p5(ddx_request_id, x_request_id);
922:
923: end;
924:
925: end jtf_fm_request_grp_w;

Line 925: end jtf_fm_request_grp_w;

921: jtf_fm_request_grp_w.rosetta_table_copy_out_p5(ddx_request_id, x_request_id);
922:
923: end;
924:
925: end jtf_fm_request_grp_w;