APPS.CSD_INTERNAL_ORDERS_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 48: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315

44: p_source_ous IN JTF_NUMBER_TABLE,
45: p_source_orgs IN JTF_NUMBER_TABLE,
46: p_need_by_date IN DATE,
47: p_quantitys IN JTF_NUMBER_TABLE,
48: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315
49: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315
50: x_requisition OUT NOCOPY VARCHAR2,
51: x_requisition_id OUT NOCOPY NUMBER,
52: x_msg_count OUT NOCOPY NUMBER,

Line 49: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315

45: p_source_orgs IN JTF_NUMBER_TABLE,
46: p_need_by_date IN DATE,
47: p_quantitys IN JTF_NUMBER_TABLE,
48: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315
49: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315
50: x_requisition OUT NOCOPY VARCHAR2,
51: x_requisition_id OUT NOCOPY NUMBER,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,

Line 83: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315

79: p_source_ous IN JTF_NUMBER_TABLE,
80: p_source_orgs IN JTF_NUMBER_TABLE,
81: p_need_by_date IN DATE,
82: p_quantitys IN JTF_NUMBER_TABLE,
83: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315
84: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL --swai: bug 14237315
85: );
86:
87: PROCEDURE pick_release_internal_order(

Line 84: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL --swai: bug 14237315

80: p_source_orgs IN JTF_NUMBER_TABLE,
81: p_need_by_date IN DATE,
82: p_quantitys IN JTF_NUMBER_TABLE,
83: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL, --swai: bug 14237315
84: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL --swai: bug 14237315
85: );
86:
87: PROCEDURE pick_release_internal_order(
88: p_api_version IN NUMBER,

Line 96: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

92: p_order_header_id IN NUMBER,
93: p_orig_quantity IN NUMBER,
94: p_shipped_quantity IN NUMBER,
95: p_order_line_id IN NUMBER,
96: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
97: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
98: p_is_sn_range IN VARCHAR2,
99: p_is_reservable IN VARCHAR2,
100: p_lot_num IN VARCHAR2,

Line 97: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

93: p_orig_quantity IN NUMBER,
94: p_shipped_quantity IN NUMBER,
95: p_order_line_id IN NUMBER,
96: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
97: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
98: p_is_sn_range IN VARCHAR2,
99: p_is_reservable IN VARCHAR2,
100: p_lot_num IN VARCHAR2,
101: p_rev IN VARCHAR2,

Line 119: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

115: p_order_header_id IN NUMBER,
116: p_orig_quantity IN NUMBER,
117: p_shipped_quantity IN NUMBER,
118: p_order_line_id IN NUMBER,
119: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
120: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
121: p_is_sn_range IN VARCHAR2,
122: p_is_reservable IN VARCHAR2,
123: p_lot_num IN VARCHAR2,

Line 120: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

116: p_orig_quantity IN NUMBER,
117: p_shipped_quantity IN NUMBER,
118: p_order_line_id IN NUMBER,
119: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
120: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
121: p_is_sn_range IN VARCHAR2,
122: p_is_reservable IN VARCHAR2,
123: p_lot_num IN VARCHAR2,
124: p_rev IN VARCHAR2,

Line 136: PROCEDURE IS_SERIAL_RANGE_VALID(p_sn_range_tbl IN JTF_VARCHAR2_TABLE_100,

132: /* range invalid, then we break. */
133: /* Returns: 1 if the range is valid, 0 if its not */
134: /********************************************************************************************/
135:
136: PROCEDURE IS_SERIAL_RANGE_VALID(p_sn_range_tbl IN JTF_VARCHAR2_TABLE_100,
137: p_inv_item_id IN NUMBER,
138: p_current_org_id IN NUMBER,
139: p_subinventory IN VARCHAR2 DEFAULT NULL,
140: p_out OUT NOCOPY NUMBER);

Line 185: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

181: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
182: p_product_txn_id IN NUMBER,
183: p_order_header_id IN NUMBER,
184: p_order_line_id IN NUMBER,
185: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
186: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
187: p_is_sn_range IN VARCHAR2,
188: p_is_reservable IN VARCHAR2,
189: p_lot_num IN VARCHAR2,

Line 186: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

182: p_product_txn_id IN NUMBER,
183: p_order_header_id IN NUMBER,
184: p_order_line_id IN NUMBER,
185: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
186: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
187: p_is_sn_range IN VARCHAR2,
188: p_is_reservable IN VARCHAR2,
189: p_lot_num IN VARCHAR2,
190: p_rev IN VARCHAR2,