APPS.JTF_FM_REQUEST_GRP_W dependencies on JTF_VARCHAR2_TABLE_1000

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy jtf_fm_request_grp.g_varchar_tbl_type, a0 JTF_VARCHAR2_TABLE_1000);

1: package jtf_fm_request_grp_w as
2: /* $Header: jtfgfmws.pls 120.2 2005/12/27 00:34 anchaudh ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy jtf_fm_request_grp.g_varchar_tbl_type, a0 JTF_VARCHAR2_TABLE_1000);
4: procedure rosetta_table_copy_out_p3(t jtf_fm_request_grp.g_varchar_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_1000);
5:
6: procedure rosetta_table_copy_in_p5(t out nocopy jtf_fm_request_grp.g_number_tbl_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p5(t jtf_fm_request_grp.g_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 4: procedure rosetta_table_copy_out_p3(t jtf_fm_request_grp.g_varchar_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_1000);

1: package jtf_fm_request_grp_w as
2: /* $Header: jtfgfmws.pls 120.2 2005/12/27 00:34 anchaudh ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy jtf_fm_request_grp.g_varchar_tbl_type, a0 JTF_VARCHAR2_TABLE_1000);
4: procedure rosetta_table_copy_out_p3(t jtf_fm_request_grp.g_varchar_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_1000);
5:
6: procedure rosetta_table_copy_in_p5(t out nocopy jtf_fm_request_grp.g_number_tbl_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p5(t jtf_fm_request_grp.g_number_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
8:

Line 27: , p_bind_var JTF_VARCHAR2_TABLE_1000

23: , p_fax VARCHAR2
24: , p_file_path VARCHAR2
25: , p_user_note VARCHAR2
26: , p_content_type VARCHAR2
27: , p_bind_var JTF_VARCHAR2_TABLE_1000
28: , p_bind_val JTF_VARCHAR2_TABLE_1000
29: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
30: , p_request_id NUMBER
31: , x_content_xml out nocopy VARCHAR2

Line 28: , p_bind_val JTF_VARCHAR2_TABLE_1000

24: , p_file_path VARCHAR2
25: , p_user_note VARCHAR2
26: , p_content_type VARCHAR2
27: , p_bind_var JTF_VARCHAR2_TABLE_1000
28: , p_bind_val JTF_VARCHAR2_TABLE_1000
29: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
30: , p_request_id NUMBER
31: , x_content_xml out nocopy VARCHAR2
32: );

Line 29: , p_bind_var_type JTF_VARCHAR2_TABLE_1000

25: , p_user_note VARCHAR2
26: , p_content_type VARCHAR2
27: , p_bind_var JTF_VARCHAR2_TABLE_1000
28: , p_bind_val JTF_VARCHAR2_TABLE_1000
29: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
30: , p_request_id NUMBER
31: , x_content_xml out nocopy VARCHAR2
32: );
33: procedure get_content_xml(p_api_version NUMBER

Line 51: , p_bind_var JTF_VARCHAR2_TABLE_1000

47: , p_fax VARCHAR2
48: , p_file_path VARCHAR2
49: , p_user_note VARCHAR2
50: , p_content_type VARCHAR2
51: , p_bind_var JTF_VARCHAR2_TABLE_1000
52: , p_bind_val JTF_VARCHAR2_TABLE_1000
53: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
54: , p_request_id NUMBER
55: , x_content_xml out nocopy VARCHAR2

Line 52: , p_bind_val JTF_VARCHAR2_TABLE_1000

48: , p_file_path VARCHAR2
49: , p_user_note VARCHAR2
50: , p_content_type VARCHAR2
51: , p_bind_var JTF_VARCHAR2_TABLE_1000
52: , p_bind_val JTF_VARCHAR2_TABLE_1000
53: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
54: , p_request_id NUMBER
55: , x_content_xml out nocopy VARCHAR2
56: , p_content_source VARCHAR2

Line 53: , p_bind_var_type JTF_VARCHAR2_TABLE_1000

49: , p_user_note VARCHAR2
50: , p_content_type VARCHAR2
51: , p_bind_var JTF_VARCHAR2_TABLE_1000
52: , p_bind_val JTF_VARCHAR2_TABLE_1000
53: , p_bind_var_type JTF_VARCHAR2_TABLE_1000
54: , p_request_id NUMBER
55: , x_content_xml out nocopy VARCHAR2
56: , p_content_source VARCHAR2
57: , p_version NUMBER

Line 77: , p_content_type JTF_VARCHAR2_TABLE_1000

73: , x_return_status out nocopy VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p_request_id NUMBER
77: , p_content_type JTF_VARCHAR2_TABLE_1000
78: , p_content_id JTF_NUMBER_TABLE
79: , p_content_nm JTF_VARCHAR2_TABLE_1000
80: , p_document_type JTF_VARCHAR2_TABLE_1000
81: , p_media_type JTF_VARCHAR2_TABLE_1000

Line 79: , p_content_nm JTF_VARCHAR2_TABLE_1000

75: , x_msg_data out nocopy VARCHAR2
76: , p_request_id NUMBER
77: , p_content_type JTF_VARCHAR2_TABLE_1000
78: , p_content_id JTF_NUMBER_TABLE
79: , p_content_nm JTF_VARCHAR2_TABLE_1000
80: , p_document_type JTF_VARCHAR2_TABLE_1000
81: , p_media_type JTF_VARCHAR2_TABLE_1000
82: , p_printer JTF_VARCHAR2_TABLE_1000
83: , p_email JTF_VARCHAR2_TABLE_1000

Line 80: , p_document_type JTF_VARCHAR2_TABLE_1000

76: , p_request_id NUMBER
77: , p_content_type JTF_VARCHAR2_TABLE_1000
78: , p_content_id JTF_NUMBER_TABLE
79: , p_content_nm JTF_VARCHAR2_TABLE_1000
80: , p_document_type JTF_VARCHAR2_TABLE_1000
81: , p_media_type JTF_VARCHAR2_TABLE_1000
82: , p_printer JTF_VARCHAR2_TABLE_1000
83: , p_email JTF_VARCHAR2_TABLE_1000
84: , p_fax JTF_VARCHAR2_TABLE_1000

Line 81: , p_media_type JTF_VARCHAR2_TABLE_1000

77: , p_content_type JTF_VARCHAR2_TABLE_1000
78: , p_content_id JTF_NUMBER_TABLE
79: , p_content_nm JTF_VARCHAR2_TABLE_1000
80: , p_document_type JTF_VARCHAR2_TABLE_1000
81: , p_media_type JTF_VARCHAR2_TABLE_1000
82: , p_printer JTF_VARCHAR2_TABLE_1000
83: , p_email JTF_VARCHAR2_TABLE_1000
84: , p_fax JTF_VARCHAR2_TABLE_1000
85: , p_file_path JTF_VARCHAR2_TABLE_1000

Line 82: , p_printer JTF_VARCHAR2_TABLE_1000

78: , p_content_id JTF_NUMBER_TABLE
79: , p_content_nm JTF_VARCHAR2_TABLE_1000
80: , p_document_type JTF_VARCHAR2_TABLE_1000
81: , p_media_type JTF_VARCHAR2_TABLE_1000
82: , p_printer JTF_VARCHAR2_TABLE_1000
83: , p_email JTF_VARCHAR2_TABLE_1000
84: , p_fax JTF_VARCHAR2_TABLE_1000
85: , p_file_path JTF_VARCHAR2_TABLE_1000
86: , p_user_note JTF_VARCHAR2_TABLE_1000

Line 83: , p_email JTF_VARCHAR2_TABLE_1000

79: , p_content_nm JTF_VARCHAR2_TABLE_1000
80: , p_document_type JTF_VARCHAR2_TABLE_1000
81: , p_media_type JTF_VARCHAR2_TABLE_1000
82: , p_printer JTF_VARCHAR2_TABLE_1000
83: , p_email JTF_VARCHAR2_TABLE_1000
84: , p_fax JTF_VARCHAR2_TABLE_1000
85: , p_file_path JTF_VARCHAR2_TABLE_1000
86: , p_user_note JTF_VARCHAR2_TABLE_1000
87: , p_quantity JTF_NUMBER_TABLE

Line 84: , p_fax JTF_VARCHAR2_TABLE_1000

80: , p_document_type JTF_VARCHAR2_TABLE_1000
81: , p_media_type JTF_VARCHAR2_TABLE_1000
82: , p_printer JTF_VARCHAR2_TABLE_1000
83: , p_email JTF_VARCHAR2_TABLE_1000
84: , p_fax JTF_VARCHAR2_TABLE_1000
85: , p_file_path JTF_VARCHAR2_TABLE_1000
86: , p_user_note JTF_VARCHAR2_TABLE_1000
87: , p_quantity JTF_NUMBER_TABLE
88: , x_content_xml out nocopy VARCHAR2

Line 85: , p_file_path JTF_VARCHAR2_TABLE_1000

81: , p_media_type JTF_VARCHAR2_TABLE_1000
82: , p_printer JTF_VARCHAR2_TABLE_1000
83: , p_email JTF_VARCHAR2_TABLE_1000
84: , p_fax JTF_VARCHAR2_TABLE_1000
85: , p_file_path JTF_VARCHAR2_TABLE_1000
86: , p_user_note JTF_VARCHAR2_TABLE_1000
87: , p_quantity JTF_NUMBER_TABLE
88: , x_content_xml out nocopy VARCHAR2
89: );

Line 86: , p_user_note JTF_VARCHAR2_TABLE_1000

82: , p_printer JTF_VARCHAR2_TABLE_1000
83: , p_email JTF_VARCHAR2_TABLE_1000
84: , p_fax JTF_VARCHAR2_TABLE_1000
85: , p_file_path JTF_VARCHAR2_TABLE_1000
86: , p_user_note JTF_VARCHAR2_TABLE_1000
87: , p_quantity JTF_NUMBER_TABLE
88: , x_content_xml out nocopy VARCHAR2
89: );
90: procedure submit_batch_request(p_api_version NUMBER

Line 110: , p_party_name JTF_VARCHAR2_TABLE_1000

106: , p_doc_ref VARCHAR2
107: , p_list_type VARCHAR2
108: , p_view_nm VARCHAR2
109: , p_party_id JTF_NUMBER_TABLE
110: , p_party_name JTF_VARCHAR2_TABLE_1000
111: , p_printer JTF_VARCHAR2_TABLE_1000
112: , p_email JTF_VARCHAR2_TABLE_1000
113: , p_fax JTF_VARCHAR2_TABLE_1000
114: , p_file_path JTF_VARCHAR2_TABLE_1000

Line 111: , p_printer JTF_VARCHAR2_TABLE_1000

107: , p_list_type VARCHAR2
108: , p_view_nm VARCHAR2
109: , p_party_id JTF_NUMBER_TABLE
110: , p_party_name JTF_VARCHAR2_TABLE_1000
111: , p_printer JTF_VARCHAR2_TABLE_1000
112: , p_email JTF_VARCHAR2_TABLE_1000
113: , p_fax JTF_VARCHAR2_TABLE_1000
114: , p_file_path JTF_VARCHAR2_TABLE_1000
115: , p_server_id NUMBER

Line 112: , p_email JTF_VARCHAR2_TABLE_1000

108: , p_view_nm VARCHAR2
109: , p_party_id JTF_NUMBER_TABLE
110: , p_party_name JTF_VARCHAR2_TABLE_1000
111: , p_printer JTF_VARCHAR2_TABLE_1000
112: , p_email JTF_VARCHAR2_TABLE_1000
113: , p_fax JTF_VARCHAR2_TABLE_1000
114: , p_file_path JTF_VARCHAR2_TABLE_1000
115: , p_server_id NUMBER
116: , p_queue_response VARCHAR2

Line 113: , p_fax JTF_VARCHAR2_TABLE_1000

109: , p_party_id JTF_NUMBER_TABLE
110: , p_party_name JTF_VARCHAR2_TABLE_1000
111: , p_printer JTF_VARCHAR2_TABLE_1000
112: , p_email JTF_VARCHAR2_TABLE_1000
113: , p_fax JTF_VARCHAR2_TABLE_1000
114: , p_file_path JTF_VARCHAR2_TABLE_1000
115: , p_server_id NUMBER
116: , p_queue_response VARCHAR2
117: , p_extended_header VARCHAR2

Line 114: , p_file_path JTF_VARCHAR2_TABLE_1000

110: , p_party_name JTF_VARCHAR2_TABLE_1000
111: , p_printer JTF_VARCHAR2_TABLE_1000
112: , p_email JTF_VARCHAR2_TABLE_1000
113: , p_fax JTF_VARCHAR2_TABLE_1000
114: , p_file_path JTF_VARCHAR2_TABLE_1000
115: , p_server_id NUMBER
116: , p_queue_response VARCHAR2
117: , p_extended_header VARCHAR2
118: , p_content_xml VARCHAR2

Line 148: , p_mass_bind_var JTF_VARCHAR2_TABLE_1000

144: , p_content_xml VARCHAR2
145: , p_request_id NUMBER
146: , p_per_user_history VARCHAR2
147: , p_mass_query_id NUMBER
148: , p_mass_bind_var JTF_VARCHAR2_TABLE_1000
149: , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000
150: , p_mass_bind_val JTF_VARCHAR2_TABLE_1000
151: );
152: procedure new_cancel_request(p_api_version NUMBER

Line 149: , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000

145: , p_request_id NUMBER
146: , p_per_user_history VARCHAR2
147: , p_mass_query_id NUMBER
148: , p_mass_bind_var JTF_VARCHAR2_TABLE_1000
149: , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000
150: , p_mass_bind_val JTF_VARCHAR2_TABLE_1000
151: );
152: procedure new_cancel_request(p_api_version NUMBER
153: , p_init_msg_list VARCHAR2

Line 150: , p_mass_bind_val JTF_VARCHAR2_TABLE_1000

146: , p_per_user_history VARCHAR2
147: , p_mass_query_id NUMBER
148: , p_mass_bind_var JTF_VARCHAR2_TABLE_1000
149: , p_mass_bind_var_type JTF_VARCHAR2_TABLE_1000
150: , p_mass_bind_val JTF_VARCHAR2_TABLE_1000
151: );
152: procedure new_cancel_request(p_api_version NUMBER
153: , p_init_msg_list VARCHAR2
154: , p_commit VARCHAR2

Line 170: , p_corrected_address JTF_VARCHAR2_TABLE_1000

166: , x_msg_count out nocopy NUMBER
167: , x_msg_data out nocopy VARCHAR2
168: , p_request_id NUMBER
169: , p_job JTF_NUMBER_TABLE
170: , p_corrected_address JTF_VARCHAR2_TABLE_1000
171: , x_return_status out nocopy VARCHAR2
172: );
173: procedure resubmit_malformed(p_api_version NUMBER
174: , p_init_msg_list VARCHAR2