354: PROCEDURE link_sr_ro_rma_oa_wrapper(
355: p_bulk_rcv_dtls_tbl IN VARCHAR2_TABLE_200,
356: p_mode IN VARCHAR2,
357: p_incident_id IN NUMBER DEFAULT NULL,
358: x_repair_line_id OUT NOCOPY JTF_NUMBER_TABLE,
359: x_incident_id OUT NOCOPY JTF_NUMBER_TABLE,
360: x_unplanned_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
361: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
362: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
355: p_bulk_rcv_dtls_tbl IN VARCHAR2_TABLE_200,
356: p_mode IN VARCHAR2,
357: p_incident_id IN NUMBER DEFAULT NULL,
358: x_repair_line_id OUT NOCOPY JTF_NUMBER_TABLE,
359: x_incident_id OUT NOCOPY JTF_NUMBER_TABLE,
360: x_unplanned_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
361: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
362: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
363: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
359: x_incident_id OUT NOCOPY JTF_NUMBER_TABLE,
360: x_unplanned_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
361: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
362: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
363: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
364: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,
365: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,
366: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE
367: ) ;
360: x_unplanned_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
361: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
362: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
363: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
364: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,
365: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,
366: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE
367: ) ;
368:
361: x_over_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
362: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
363: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
364: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,
365: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,
366: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE
367: ) ;
368:
369:
362: x_under_receipt_flag OUT NOCOPY VARCHAR2_TABLE_100,
363: x_order_header_id OUT NOCOPY JTF_NUMBER_TABLE,
364: x_order_line_id OUT NOCOPY JTF_NUMBER_TABLE,
365: x_over_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE,
366: x_under_receipt_qty OUT NOCOPY JTF_NUMBER_TABLE
367: ) ;
368:
369:
370: /* ***************************************************************************/
429: p_party_id in NUMBER) RETURN NUMBER;
430:
431: /*-----------------------------------------------------------------*/
432: /* Function name: get_num_in_list */
433: /* description : The function will return the JTF_NUMBER_TABLE */
434: /* type when a string containing numbers is passed to it.*/
435: /*-----------------------------------------------------------------*/
436:
437: FUNCTION get_num_in_list(p_in_string IN varchar2) RETURN JTF_NUMBER_TABLE;
433: /* description : The function will return the JTF_NUMBER_TABLE */
434: /* type when a string containing numbers is passed to it.*/
435: /*-----------------------------------------------------------------*/
436:
437: FUNCTION get_num_in_list(p_in_string IN varchar2) RETURN JTF_NUMBER_TABLE;
438:
439: END CSD_BULK_RECEIVE_UTIL;