DBA Data[Home] [Help]

APPS.CSD_REPAIR_MANAGER_UTIL dependencies on JTF_VARCHAR2_TABLE_100

Line 89: l_error_messages_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_1000,

85: p_note_text IN VARCHAR2 DEFAULT NULL,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: l_error_messages_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_1000,
90: p_ro_promise_date IN DATE DEFAULT NULL
91: );
92: /******************************************************************************/
93: /* Procedure Name: mass_create_attachments */

Line 125: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,

121: PROCEDURE mass_create_repair_orders(p_api_version IN NUMBER DEFAULT 1.0,
122: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: p_item_ids IN JTF_NUMBER_TABLE,
125: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
126: p_quantity IN JTF_NUMBER_TABLE,
127: p_uom_code IN JTF_VARCHAR2_TABLE_100,
128: p_external_ref IN JTF_VARCHAR2_TABLE_100,
129: p_lot_nums IN JTF_VARCHAR2_TABLE_100,

Line 127: p_uom_code IN JTF_VARCHAR2_TABLE_100,

123: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: p_item_ids IN JTF_NUMBER_TABLE,
125: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
126: p_quantity IN JTF_NUMBER_TABLE,
127: p_uom_code IN JTF_VARCHAR2_TABLE_100,
128: p_external_ref IN JTF_VARCHAR2_TABLE_100,
129: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
130: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
131: p_repair_type_ids IN JTF_NUMBER_TABLE,

Line 128: p_external_ref IN JTF_VARCHAR2_TABLE_100,

124: p_item_ids IN JTF_NUMBER_TABLE,
125: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
126: p_quantity IN JTF_NUMBER_TABLE,
127: p_uom_code IN JTF_VARCHAR2_TABLE_100,
128: p_external_ref IN JTF_VARCHAR2_TABLE_100,
129: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
130: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
131: p_repair_type_ids IN JTF_NUMBER_TABLE,
132: p_instance_ids IN JTF_NUMBER_TABLE,

Line 129: p_lot_nums IN JTF_VARCHAR2_TABLE_100,

125: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
126: p_quantity IN JTF_NUMBER_TABLE,
127: p_uom_code IN JTF_VARCHAR2_TABLE_100,
128: p_external_ref IN JTF_VARCHAR2_TABLE_100,
129: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
130: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
131: p_repair_type_ids IN JTF_NUMBER_TABLE,
132: p_instance_ids IN JTF_NUMBER_TABLE,
133: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,

Line 130: p_item_revisions IN JTF_VARCHAR2_TABLE_100,

126: p_quantity IN JTF_NUMBER_TABLE,
127: p_uom_code IN JTF_VARCHAR2_TABLE_100,
128: p_external_ref IN JTF_VARCHAR2_TABLE_100,
129: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
130: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
131: p_repair_type_ids IN JTF_NUMBER_TABLE,
132: p_instance_ids IN JTF_NUMBER_TABLE,
133: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,
134: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,

Line 135: p_ib_ctrl_flag IN JTF_VARCHAR2_TABLE_100,

131: p_repair_type_ids IN JTF_NUMBER_TABLE,
132: p_instance_ids IN JTF_NUMBER_TABLE,
133: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,
134: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,
135: p_ib_ctrl_flag IN JTF_VARCHAR2_TABLE_100,
136: p_party_id IN NUMBER,
137: p_account_id IN NUMBER,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,

Line 190: FUNCTION string_aggregate(input IN JTF_VARCHAR2_TABLE_100)

186: APPS becomes 11g use inbuilt STRAGGR method instead of this.
187: **/
188:
189:
190: FUNCTION string_aggregate(input IN JTF_VARCHAR2_TABLE_100)
191: RETURN VARCHAR2;
192:
193: END CSD_REPAIR_MANAGER_UTIL;