DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on JTF_NUMBER_TABLE

Line 40: p_product_txn_ids IN JTF_NUMBER_TABLE,

36: PROCEDURE create_internal_requisition(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_product_txn_ids IN JTF_NUMBER_TABLE,
41: p_destination_ous IN JTF_NUMBER_TABLE,
42: p_destination_orgs IN JTF_NUMBER_TABLE,
43: p_destination_loc_ids IN JTF_NUMBER_TABLE,
44: p_source_ous IN JTF_NUMBER_TABLE,

Line 41: p_destination_ous IN JTF_NUMBER_TABLE,

37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_product_txn_ids IN JTF_NUMBER_TABLE,
41: p_destination_ous IN JTF_NUMBER_TABLE,
42: p_destination_orgs IN JTF_NUMBER_TABLE,
43: p_destination_loc_ids IN JTF_NUMBER_TABLE,
44: p_source_ous IN JTF_NUMBER_TABLE,
45: p_source_orgs IN JTF_NUMBER_TABLE,

Line 42: p_destination_orgs IN JTF_NUMBER_TABLE,

38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_product_txn_ids IN JTF_NUMBER_TABLE,
41: p_destination_ous IN JTF_NUMBER_TABLE,
42: p_destination_orgs IN JTF_NUMBER_TABLE,
43: p_destination_loc_ids IN JTF_NUMBER_TABLE,
44: p_source_ous IN JTF_NUMBER_TABLE,
45: p_source_orgs IN JTF_NUMBER_TABLE,
46: p_need_by_date IN DATE,

Line 43: p_destination_loc_ids IN JTF_NUMBER_TABLE,

39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_product_txn_ids IN JTF_NUMBER_TABLE,
41: p_destination_ous IN JTF_NUMBER_TABLE,
42: p_destination_orgs IN JTF_NUMBER_TABLE,
43: p_destination_loc_ids IN JTF_NUMBER_TABLE,
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,

Line 44: p_source_ous IN JTF_NUMBER_TABLE,

40: p_product_txn_ids IN JTF_NUMBER_TABLE,
41: p_destination_ous IN JTF_NUMBER_TABLE,
42: p_destination_orgs IN JTF_NUMBER_TABLE,
43: p_destination_loc_ids IN JTF_NUMBER_TABLE,
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

Line 45: p_source_orgs IN JTF_NUMBER_TABLE,

41: p_destination_ous IN JTF_NUMBER_TABLE,
42: p_destination_orgs IN JTF_NUMBER_TABLE,
43: p_destination_loc_ids IN JTF_NUMBER_TABLE,
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

Line 47: p_quantitys IN JTF_NUMBER_TABLE,

43: p_destination_loc_ids IN JTF_NUMBER_TABLE,
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,

Line 75: p_product_txn_ids IN JTF_NUMBER_TABLE,

71: /* Overloaded procedure */
72: PROCEDURE create_internal_move_orders(
73: errbuf OUT NOCOPY VARCHAR2,
74: retcode OUT NOCOPY VARCHAR2,
75: p_product_txn_ids IN JTF_NUMBER_TABLE,
76: p_destination_ous IN JTF_NUMBER_TABLE,
77: p_destination_orgs IN JTF_NUMBER_TABLE,
78: p_destination_loc_ids IN JTF_NUMBER_TABLE,
79: p_source_ous IN JTF_NUMBER_TABLE,

Line 76: p_destination_ous IN JTF_NUMBER_TABLE,

72: PROCEDURE create_internal_move_orders(
73: errbuf OUT NOCOPY VARCHAR2,
74: retcode OUT NOCOPY VARCHAR2,
75: p_product_txn_ids IN JTF_NUMBER_TABLE,
76: p_destination_ous IN JTF_NUMBER_TABLE,
77: p_destination_orgs IN JTF_NUMBER_TABLE,
78: p_destination_loc_ids IN JTF_NUMBER_TABLE,
79: p_source_ous IN JTF_NUMBER_TABLE,
80: p_source_orgs IN JTF_NUMBER_TABLE,

Line 77: p_destination_orgs IN JTF_NUMBER_TABLE,

73: errbuf OUT NOCOPY VARCHAR2,
74: retcode OUT NOCOPY VARCHAR2,
75: p_product_txn_ids IN JTF_NUMBER_TABLE,
76: p_destination_ous IN JTF_NUMBER_TABLE,
77: p_destination_orgs IN JTF_NUMBER_TABLE,
78: p_destination_loc_ids IN JTF_NUMBER_TABLE,
79: p_source_ous IN JTF_NUMBER_TABLE,
80: p_source_orgs IN JTF_NUMBER_TABLE,
81: p_need_by_date IN DATE,

Line 78: p_destination_loc_ids IN JTF_NUMBER_TABLE,

74: retcode OUT NOCOPY VARCHAR2,
75: p_product_txn_ids IN JTF_NUMBER_TABLE,
76: p_destination_ous IN JTF_NUMBER_TABLE,
77: p_destination_orgs IN JTF_NUMBER_TABLE,
78: p_destination_loc_ids IN JTF_NUMBER_TABLE,
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,

Line 79: p_source_ous IN JTF_NUMBER_TABLE,

75: p_product_txn_ids IN JTF_NUMBER_TABLE,
76: p_destination_ous IN JTF_NUMBER_TABLE,
77: p_destination_orgs IN JTF_NUMBER_TABLE,
78: p_destination_loc_ids IN JTF_NUMBER_TABLE,
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

Line 80: p_source_orgs IN JTF_NUMBER_TABLE,

76: p_destination_ous IN JTF_NUMBER_TABLE,
77: p_destination_orgs IN JTF_NUMBER_TABLE,
78: p_destination_loc_ids IN JTF_NUMBER_TABLE,
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

Line 82: p_quantitys IN JTF_NUMBER_TABLE,

78: p_destination_loc_ids IN JTF_NUMBER_TABLE,
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:

Line 102: p_quantity_tbl IN JTF_NUMBER_TABLE,

98: p_is_sn_range IN VARCHAR2,
99: p_is_reservable IN VARCHAR2,
100: p_lot_num IN VARCHAR2,
101: p_rev IN VARCHAR2,
102: p_quantity_tbl IN JTF_NUMBER_TABLE,
103: p_picking_rule_id IN NUMBER DEFAULT NULL,
104: p_picking_subinv IN VARCHAR2 DEFAULT NULL,
105: p_pick_from_org IN NUMBER DEFAULT NULL,
106: x_msg_count OUT NOCOPY NUMBER,

Line 125: p_quantity_tbl IN JTF_NUMBER_TABLE,

121: p_is_sn_range IN VARCHAR2,
122: p_is_reservable IN VARCHAR2,
123: p_lot_num IN VARCHAR2,
124: p_rev IN VARCHAR2,
125: p_quantity_tbl IN JTF_NUMBER_TABLE,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: x_return_status OUT NOCOPY VARCHAR2);
129: /********************************************************************************************/

Line 191: p_quantity_tbl IN JTF_NUMBER_TABLE,

187: p_is_sn_range IN VARCHAR2,
188: p_is_reservable IN VARCHAR2,
189: p_lot_num IN VARCHAR2,
190: p_rev IN VARCHAR2,
191: p_quantity_tbl IN JTF_NUMBER_TABLE,
192: p_picking_rule_id IN NUMBER DEFAULT NULL,
193: p_picking_subinv IN VARCHAR2 DEFAULT NULL,
194: p_pick_from_org IN NUMBER DEFAULT NULL,
195: x_msg_count OUT NOCOPY NUMBER,