DBA Data[Home] [Help]

APPS.JTF_FM_REQUEST_GRP_W dependencies on JTF_VARCHAR2_TABLE_1000

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 44: a0 := JTF_VARCHAR2_TABLE_1000();

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();
45: else
46: a0 := JTF_VARCHAR2_TABLE_1000();
47: if t.count > 0 then
48: a0.extend(t.count);

Line 46: a0 := JTF_VARCHAR2_TABLE_1000();

42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_1000();
45: else
46: a0 := JTF_VARCHAR2_TABLE_1000();
47: if t.count > 0 then
48: a0.extend(t.count);
49: ddindx := t.first;
50: indx := 1;

Line 122: , p_bind_var JTF_VARCHAR2_TABLE_1000

118: , p_fax VARCHAR2
119: , p_file_path VARCHAR2
120: , p_user_note VARCHAR2
121: , p_content_type VARCHAR2
122: , p_bind_var JTF_VARCHAR2_TABLE_1000
123: , p_bind_val JTF_VARCHAR2_TABLE_1000
124: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
125: , p_request_id NUMBER
126: , x_content_xml out nocopy VARCHAR2

Line 123: , p_bind_val JTF_VARCHAR2_TABLE_1000

119: , p_file_path VARCHAR2
120: , p_user_note VARCHAR2
121: , p_content_type VARCHAR2
122: , p_bind_var JTF_VARCHAR2_TABLE_1000
123: , p_bind_val JTF_VARCHAR2_TABLE_1000
124: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
125: , p_request_id NUMBER
126: , x_content_xml out nocopy VARCHAR2
127: )

Line 124: , p_bind_var_type JTF_VARCHAR2_TABLE_1000

120: , p_user_note VARCHAR2
121: , p_content_type VARCHAR2
122: , p_bind_var JTF_VARCHAR2_TABLE_1000
123: , p_bind_val JTF_VARCHAR2_TABLE_1000
124: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
125: , p_request_id NUMBER
126: , x_content_xml out nocopy VARCHAR2
127: )
128:

Line 231: , p_bind_var JTF_VARCHAR2_TABLE_1000

227: , p_fax VARCHAR2
228: , p_file_path VARCHAR2
229: , p_user_note VARCHAR2
230: , p_content_type VARCHAR2
231: , p_bind_var JTF_VARCHAR2_TABLE_1000
232: , p_bind_val JTF_VARCHAR2_TABLE_1000
233: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
234: , p_request_id NUMBER
235: , x_content_xml out nocopy VARCHAR2

Line 232: , p_bind_val JTF_VARCHAR2_TABLE_1000

228: , p_file_path VARCHAR2
229: , p_user_note VARCHAR2
230: , p_content_type VARCHAR2
231: , p_bind_var JTF_VARCHAR2_TABLE_1000
232: , p_bind_val JTF_VARCHAR2_TABLE_1000
233: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
234: , p_request_id NUMBER
235: , x_content_xml out nocopy VARCHAR2
236: , p_content_source VARCHAR2

Line 233: , p_bind_var_type JTF_VARCHAR2_TABLE_1000

229: , p_user_note VARCHAR2
230: , p_content_type VARCHAR2
231: , p_bind_var JTF_VARCHAR2_TABLE_1000
232: , p_bind_val JTF_VARCHAR2_TABLE_1000
233: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
234: , p_request_id NUMBER
235: , x_content_xml out nocopy VARCHAR2
236: , p_content_source VARCHAR2
237: , p_version NUMBER

Line 387: , p_content_type JTF_VARCHAR2_TABLE_1000

383: , x_return_status out nocopy VARCHAR2
384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2
386: , p_request_id NUMBER
387: , p_content_type JTF_VARCHAR2_TABLE_1000
388: , p_content_id JTF_NUMBER_TABLE
389: , p_content_nm JTF_VARCHAR2_TABLE_1000
390: , p_document_type JTF_VARCHAR2_TABLE_1000
391: , p_media_type JTF_VARCHAR2_TABLE_1000

Line 389: , p_content_nm JTF_VARCHAR2_TABLE_1000

385: , x_msg_data out nocopy VARCHAR2
386: , p_request_id NUMBER
387: , p_content_type JTF_VARCHAR2_TABLE_1000
388: , p_content_id JTF_NUMBER_TABLE
389: , p_content_nm JTF_VARCHAR2_TABLE_1000
390: , p_document_type JTF_VARCHAR2_TABLE_1000
391: , p_media_type JTF_VARCHAR2_TABLE_1000
392: , p_printer JTF_VARCHAR2_TABLE_1000
393: , p_email JTF_VARCHAR2_TABLE_1000

Line 390: , p_document_type JTF_VARCHAR2_TABLE_1000

386: , p_request_id NUMBER
387: , p_content_type JTF_VARCHAR2_TABLE_1000
388: , p_content_id JTF_NUMBER_TABLE
389: , p_content_nm JTF_VARCHAR2_TABLE_1000
390: , p_document_type JTF_VARCHAR2_TABLE_1000
391: , p_media_type JTF_VARCHAR2_TABLE_1000
392: , p_printer JTF_VARCHAR2_TABLE_1000
393: , p_email JTF_VARCHAR2_TABLE_1000
394: , p_fax JTF_VARCHAR2_TABLE_1000

Line 391: , p_media_type JTF_VARCHAR2_TABLE_1000

387: , p_content_type JTF_VARCHAR2_TABLE_1000
388: , p_content_id JTF_NUMBER_TABLE
389: , p_content_nm JTF_VARCHAR2_TABLE_1000
390: , p_document_type JTF_VARCHAR2_TABLE_1000
391: , p_media_type JTF_VARCHAR2_TABLE_1000
392: , p_printer JTF_VARCHAR2_TABLE_1000
393: , p_email JTF_VARCHAR2_TABLE_1000
394: , p_fax JTF_VARCHAR2_TABLE_1000
395: , p_file_path JTF_VARCHAR2_TABLE_1000

Line 392: , p_printer JTF_VARCHAR2_TABLE_1000

388: , p_content_id JTF_NUMBER_TABLE
389: , p_content_nm JTF_VARCHAR2_TABLE_1000
390: , p_document_type JTF_VARCHAR2_TABLE_1000
391: , p_media_type JTF_VARCHAR2_TABLE_1000
392: , p_printer JTF_VARCHAR2_TABLE_1000
393: , p_email JTF_VARCHAR2_TABLE_1000
394: , p_fax JTF_VARCHAR2_TABLE_1000
395: , p_file_path JTF_VARCHAR2_TABLE_1000
396: , p_user_note JTF_VARCHAR2_TABLE_1000

Line 393: , p_email JTF_VARCHAR2_TABLE_1000

389: , p_content_nm JTF_VARCHAR2_TABLE_1000
390: , p_document_type JTF_VARCHAR2_TABLE_1000
391: , p_media_type JTF_VARCHAR2_TABLE_1000
392: , p_printer JTF_VARCHAR2_TABLE_1000
393: , p_email JTF_VARCHAR2_TABLE_1000
394: , p_fax JTF_VARCHAR2_TABLE_1000
395: , p_file_path JTF_VARCHAR2_TABLE_1000
396: , p_user_note JTF_VARCHAR2_TABLE_1000
397: , p_quantity JTF_NUMBER_TABLE

Line 394: , p_fax JTF_VARCHAR2_TABLE_1000

390: , p_document_type JTF_VARCHAR2_TABLE_1000
391: , p_media_type JTF_VARCHAR2_TABLE_1000
392: , p_printer JTF_VARCHAR2_TABLE_1000
393: , p_email JTF_VARCHAR2_TABLE_1000
394: , p_fax JTF_VARCHAR2_TABLE_1000
395: , p_file_path JTF_VARCHAR2_TABLE_1000
396: , p_user_note JTF_VARCHAR2_TABLE_1000
397: , p_quantity JTF_NUMBER_TABLE
398: , x_content_xml out nocopy VARCHAR2

Line 395: , p_file_path JTF_VARCHAR2_TABLE_1000

391: , p_media_type JTF_VARCHAR2_TABLE_1000
392: , p_printer JTF_VARCHAR2_TABLE_1000
393: , p_email JTF_VARCHAR2_TABLE_1000
394: , p_fax JTF_VARCHAR2_TABLE_1000
395: , p_file_path JTF_VARCHAR2_TABLE_1000
396: , p_user_note JTF_VARCHAR2_TABLE_1000
397: , p_quantity JTF_NUMBER_TABLE
398: , x_content_xml out nocopy VARCHAR2
399: )

Line 396: , p_user_note JTF_VARCHAR2_TABLE_1000

392: , p_printer JTF_VARCHAR2_TABLE_1000
393: , p_email JTF_VARCHAR2_TABLE_1000
394: , p_fax JTF_VARCHAR2_TABLE_1000
395: , p_file_path JTF_VARCHAR2_TABLE_1000
396: , p_user_note JTF_VARCHAR2_TABLE_1000
397: , p_quantity JTF_NUMBER_TABLE
398: , x_content_xml out nocopy VARCHAR2
399: )
400:

Line 512: , p_party_name JTF_VARCHAR2_TABLE_1000

508: , p_doc_ref VARCHAR2
509: , p_list_type VARCHAR2
510: , p_view_nm VARCHAR2
511: , p_party_id JTF_NUMBER_TABLE
512: , p_party_name JTF_VARCHAR2_TABLE_1000
513: , p_printer JTF_VARCHAR2_TABLE_1000
514: , p_email JTF_VARCHAR2_TABLE_1000
515: , p_fax JTF_VARCHAR2_TABLE_1000
516: , p_file_path JTF_VARCHAR2_TABLE_1000

Line 513: , p_printer JTF_VARCHAR2_TABLE_1000

509: , p_list_type VARCHAR2
510: , p_view_nm VARCHAR2
511: , p_party_id JTF_NUMBER_TABLE
512: , p_party_name JTF_VARCHAR2_TABLE_1000
513: , p_printer JTF_VARCHAR2_TABLE_1000
514: , p_email JTF_VARCHAR2_TABLE_1000
515: , p_fax JTF_VARCHAR2_TABLE_1000
516: , p_file_path JTF_VARCHAR2_TABLE_1000
517: , p_server_id NUMBER

Line 514: , p_email JTF_VARCHAR2_TABLE_1000

510: , p_view_nm VARCHAR2
511: , p_party_id JTF_NUMBER_TABLE
512: , p_party_name JTF_VARCHAR2_TABLE_1000
513: , p_printer JTF_VARCHAR2_TABLE_1000
514: , p_email JTF_VARCHAR2_TABLE_1000
515: , p_fax JTF_VARCHAR2_TABLE_1000
516: , p_file_path JTF_VARCHAR2_TABLE_1000
517: , p_server_id NUMBER
518: , p_queue_response VARCHAR2

Line 515: , p_fax JTF_VARCHAR2_TABLE_1000

511: , p_party_id JTF_NUMBER_TABLE
512: , p_party_name JTF_VARCHAR2_TABLE_1000
513: , p_printer JTF_VARCHAR2_TABLE_1000
514: , p_email JTF_VARCHAR2_TABLE_1000
515: , p_fax JTF_VARCHAR2_TABLE_1000
516: , p_file_path JTF_VARCHAR2_TABLE_1000
517: , p_server_id NUMBER
518: , p_queue_response VARCHAR2
519: , p_extended_header VARCHAR2

Line 516: , p_file_path JTF_VARCHAR2_TABLE_1000

512: , p_party_name JTF_VARCHAR2_TABLE_1000
513: , p_printer JTF_VARCHAR2_TABLE_1000
514: , p_email JTF_VARCHAR2_TABLE_1000
515: , p_fax JTF_VARCHAR2_TABLE_1000
516: , p_file_path JTF_VARCHAR2_TABLE_1000
517: , p_server_id NUMBER
518: , p_queue_response VARCHAR2
519: , p_extended_header VARCHAR2
520: , p_content_xml VARCHAR2

Line 665: , p_mass_bind_var JTF_VARCHAR2_TABLE_1000

661: , p_content_xml VARCHAR2
662: , p_request_id NUMBER
663: , p_per_user_history VARCHAR2
664: , p_mass_query_id NUMBER
665: , p_mass_bind_var JTF_VARCHAR2_TABLE_1000
666: , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000
667: , p_mass_bind_val JTF_VARCHAR2_TABLE_1000
668: )
669:

Line 666: , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000

662: , p_request_id NUMBER
663: , p_per_user_history VARCHAR2
664: , p_mass_query_id NUMBER
665: , p_mass_bind_var JTF_VARCHAR2_TABLE_1000
666: , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000
667: , p_mass_bind_val JTF_VARCHAR2_TABLE_1000
668: )
669:
670: as

Line 667: , p_mass_bind_val JTF_VARCHAR2_TABLE_1000

663: , p_per_user_history VARCHAR2
664: , p_mass_query_id NUMBER
665: , p_mass_bind_var JTF_VARCHAR2_TABLE_1000
666: , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000
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;

Line 829: , p_corrected_address JTF_VARCHAR2_TABLE_1000

825: , x_msg_count out nocopy NUMBER
826: , x_msg_data out nocopy VARCHAR2
827: , p_request_id NUMBER
828: , p_job JTF_NUMBER_TABLE
829: , p_corrected_address JTF_VARCHAR2_TABLE_1000
830: , x_return_status out nocopy VARCHAR2
831: )
832:
833: as