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.

[Home] [Help]

APPS.CSD_REPAIR_MANAGER_UTIL dependencies on JTF_VARCHAR2_TABLE_100

Line 46: (lx_error_message_table IN OUT NOCOPY JTF_VARCHAR2_TABLE_1000,

42:
43: -- private routines.
44:
45: procedure prepare_error_message_table
46: (lx_error_message_table IN OUT NOCOPY JTF_VARCHAR2_TABLE_1000,
47: l_msg_count IN NUMBER DEFAULT 0,
48: l_msg_data IN VARCHAR2 DEFAULT NULL,
49: l_errored_field IN VARCHAR2,
50: l_repair_line_id IN NUMBER

Line 54: (lx_error_message_table IN OUT NOCOPY JTF_VARCHAR2_TABLE_1000,

50: l_repair_line_id IN NUMBER
51: );
52:
53: procedure prepare_error_message_table
54: (lx_error_message_table IN OUT NOCOPY JTF_VARCHAR2_TABLE_1000,
55: l_msg_count IN NUMBER DEFAULT 0,
56: l_msg_data IN VARCHAR2 DEFAULT NULL,
57: l_errored_field IN VARCHAR2,
58: l_repair_line_id IN NUMBER

Line 205: l_repair_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

201:
202: l_incident_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
203: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
204:
205: l_repair_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
206: l_incident_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
207: l_serial_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
208: l_instance_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
209:

Line 206: l_incident_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

202: l_incident_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
203: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
204:
205: l_repair_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
206: l_incident_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
207: l_serial_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
208: l_instance_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
209:
210: begin

Line 207: l_serial_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

203: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
204:
205: l_repair_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
206: l_incident_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
207: l_serial_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
208: l_instance_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
209:
210: begin
211:

Line 208: l_instance_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

204:
205: l_repair_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
206: l_incident_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
207: l_serial_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
208: l_instance_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
209:
210: begin
211:
212: -- get the repair line ids

Line 728: l_error_messages_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_1000,

724: p_note_text IN VARCHAR2 DEFAULT NULL,
725: x_return_status OUT NOCOPY VARCHAR2,
726: x_msg_count OUT NOCOPY NUMBER,
727: x_msg_data OUT NOCOPY VARCHAR2,
728: l_error_messages_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_1000,
729: p_ro_promise_date IN DATE DEFAULT NULL
730: )
731: IS
732:

Line 811: l_error_messages_tbl := JTF_VARCHAR2_TABLE_1000();

807: 'p_repair_line_id('||i||') = '||p_repair_line_ids(i));
808: END LOOP;
809: END IF;
810: -- initialize the error messages table.
811: l_error_messages_tbl := JTF_VARCHAR2_TABLE_1000();
812:
813: --
814: -- find out the values for update
815: --

Line 1445: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,

1441: PROCEDURE mass_create_repair_orders(p_api_version IN NUMBER DEFAULT 1.0,
1442: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1443: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1444: p_item_ids IN JTF_NUMBER_TABLE,
1445: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
1446: p_quantity IN JTF_NUMBER_TABLE,
1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,
1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,
1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,

Line 1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,

1443: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1444: p_item_ids IN JTF_NUMBER_TABLE,
1445: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
1446: p_quantity IN JTF_NUMBER_TABLE,
1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,
1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,
1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
1451: p_repair_type_ids IN JTF_NUMBER_TABLE,

Line 1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,

1444: p_item_ids IN JTF_NUMBER_TABLE,
1445: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
1446: p_quantity IN JTF_NUMBER_TABLE,
1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,
1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,
1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
1451: p_repair_type_ids IN JTF_NUMBER_TABLE,
1452: p_instance_ids IN JTF_NUMBER_TABLE,

Line 1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,

1445: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
1446: p_quantity IN JTF_NUMBER_TABLE,
1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,
1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,
1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
1451: p_repair_type_ids IN JTF_NUMBER_TABLE,
1452: p_instance_ids IN JTF_NUMBER_TABLE,
1453: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,

Line 1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,

1446: p_quantity IN JTF_NUMBER_TABLE,
1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,
1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,
1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
1451: p_repair_type_ids IN JTF_NUMBER_TABLE,
1452: p_instance_ids IN JTF_NUMBER_TABLE,
1453: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,
1454: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,

Line 1455: p_ib_ctrl_flag IN JTF_VARCHAR2_TABLE_100,

1451: p_repair_type_ids IN JTF_NUMBER_TABLE,
1452: p_instance_ids IN JTF_NUMBER_TABLE,
1453: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,
1454: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,
1455: p_ib_ctrl_flag IN JTF_VARCHAR2_TABLE_100,
1456: p_party_id IN NUMBER,
1457: p_account_id IN NUMBER,
1458: x_return_status OUT NOCOPY VARCHAR2,
1459: x_msg_count OUT NOCOPY NUMBER,

Line 2576: FUNCTION string_aggregate(input IN JTF_VARCHAR2_TABLE_100)

2572: entries in the table type. If the minimum DB version for
2573: APPS becomes 11g use inbuilt STRAGGR method instead of this.
2574: **/
2575:
2576: FUNCTION string_aggregate(input IN JTF_VARCHAR2_TABLE_100)
2577: RETURN VARCHAR2
2578: IS
2579:
2580: l_value VARCHAR2(4000) := '';