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_INT_REQUEST_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 285: l_header_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

281: l_header_count NUMBER;
282: l_email_from_address VARCHAR2(100) DEFAULT NULL;
283: l_email_reply_to_address VARCHAR2(100) DEFAULT NULL;
284: l_sender_display_name VARCHAR2(100) DEFAULT NULL;
285: l_header_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
286: l_header_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
287: l_bind_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
288: l_bind_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
289: l_select_cols VARCHAR2(3000);

Line 286: l_header_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

282: l_email_from_address VARCHAR2(100) DEFAULT NULL;
283: l_email_reply_to_address VARCHAR2(100) DEFAULT NULL;
284: l_sender_display_name VARCHAR2(100) DEFAULT NULL;
285: l_header_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
286: l_header_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
287: l_bind_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
288: l_bind_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
289: l_select_cols VARCHAR2(3000);
290: l_insert_statement VARCHAR2(32767);

Line 287: l_bind_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

283: l_email_reply_to_address VARCHAR2(100) DEFAULT NULL;
284: l_sender_display_name VARCHAR2(100) DEFAULT NULL;
285: l_header_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
286: l_header_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
287: l_bind_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
288: l_bind_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
289: l_select_cols VARCHAR2(3000);
290: l_insert_statement VARCHAR2(32767);
291: l_fnd_query VARCHAR2(32767);

Line 288: l_bind_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

284: l_sender_display_name VARCHAR2(100) DEFAULT NULL;
285: l_header_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
286: l_header_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
287: l_bind_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
288: l_bind_value JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
289: l_select_cols VARCHAR2(3000);
290: l_insert_statement VARCHAR2(32767);
291: l_fnd_query VARCHAR2(32767);
292: l_Add_columns VARCHAR2(32767);

Line 1010: PROCEDURE update_lines_status_bulk ( line_ids IN JTF_VARCHAR2_TABLE_100

1006: | - Updates jtf_fm_request_history_all - for outcome code |
1007: | - Updates jtf_fm_email_stat - for email details |
1008: | |
1009: *---------------------------------------------------------------------------------*/
1010: PROCEDURE update_lines_status_bulk ( line_ids IN JTF_VARCHAR2_TABLE_100
1011: , request_id IN NUMBER
1012: , line_status IN JTF_VARCHAR2_TABLE_100
1013: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1014: , x_return_status OUT NOCOPY VARCHAR2

Line 1012: , line_status IN JTF_VARCHAR2_TABLE_100

1008: | |
1009: *---------------------------------------------------------------------------------*/
1010: PROCEDURE update_lines_status_bulk ( line_ids IN JTF_VARCHAR2_TABLE_100
1011: , request_id IN NUMBER
1012: , line_status IN JTF_VARCHAR2_TABLE_100
1013: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1014: , x_return_status OUT NOCOPY VARCHAR2
1015: , x_msg_count OUT NOCOPY NUMBER
1016: , x_msg_data OUT NOCOPY VARCHAR2

Line 1150: PROCEDURE update_lines_status ( line_ids IN JTF_VARCHAR2_TABLE_100

1146: | jtf_fm_int_request_lines table and sets the email status to |
1147: | the passed email status PL/SQL table. |
1148: | |
1149: *---------------------------------------------------------------------------------*/
1150: PROCEDURE update_lines_status ( line_ids IN JTF_VARCHAR2_TABLE_100
1151: , request_id IN NUMBER
1152: , line_status IN VARCHAR2
1153: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1154: , x_return_status OUT NOCOPY VARCHAR2

Line 1454: , p_parameter_table OUT NOCOPY JTF_VARCHAR2_TABLE_100

1450: , p_email_from_address OUT NOCOPY VARCHAR2
1451: , p_email_reply_to_address OUT NOCOPY VARCHAR2
1452: , p_sender_display_name OUT NOCOPY VARCHAR2
1453: , p_subject OUT NOCOPY VARCHAR2
1454: , p_parameter_table OUT NOCOPY JTF_VARCHAR2_TABLE_100
1455: , x_return_status OUT NOCOPY VARCHAR2
1456: , x_msg_count OUT NOCOPY NUMBER
1457: , x_msg_data OUT NOCOPY VARCHAR2
1458: ) IS

Line 1574: p_parameter_table := jtf_varchar2_table_100();

1570: AND server_id = p_server_id
1571: ORDER BY priority, creation_date DESC;
1572: l_header_request_id NUMBER;
1573: BEGIN
1574: p_parameter_table := jtf_varchar2_table_100();
1575:
1576: FOR i IN 1 .. 100
1577: LOOP
1578: p_parameter_table.extend();