[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* table of details of the selected records from the UI. If one chooses to */
/* implement this, they would need to use this and populate the corresponding*/
/* out data structures. One caution to be exercised is that the order of the*/
/* out table should match the in table. For example if p_item_id(1) = item1 */
/* p_item_id(2)=item2 and p_item_id(3)=item3. Then the out table x_item_id */
/* should be like x_item_id = item1, x_item_id(2)=item2 anx x_item_id(3)= */
/* item3. In case for a particular index the in table item_id and out table */
/* item_id doesn't match, then the request parts program will interpret that*/
/* as an item substitution. If the end user implements this user hook they */
/* have to set x_user_custom_sourcing = 'Y'. The type of requisition can be */
/* specified using the x_requisition_type data structure. The possible values*/
/* are I for internal and V for vendor based requisitions. Even if the */
/* custom sourcing is applicable to only subset of the passed in data, the */
/* out tables have to be populated with the input values. For eg. If there */
/* are 2 records, and the custom sourcing would apply for 1st only, then the*/
/* second index of the table needs to have the values copied from the second*/
/* index of the input table. */
/****************************************************************************************/
PROCEDURE source_parts
(p_repair_line_id IN NUMBER,
p_wip_entity_id IN JTF_NUMBER_TABLE,
p_item_id IN JTF_NUMBER_TABLE,
p_quantity IN JTF_NUMBER_TABLE,
p_requesting_org IN NUMBER,
p_op_seq_num IN JTF_NUMBER_TABLE,
x_use_custom_sourcing OUT NOCOPY BOOLEAN,
x_wip_entity_id OUT NOCOPY JTF_NUMBER_TABLE,
x_item_id OUT NOCOPY JTF_NUMBER_TABLE,
x_item_desc OUT NOCOPY JTF_VARCHAR2_TABLE_100,
x_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
x_quantity OUT NOCOPY JTF_NUMBER_TABLE,
x_source_org_id OUT NOCOPY JTF_NUMBER_TABLE,
x_source_subinventory OUT NOCOPY JTF_VARCHAR2_TABLE_100,
x_op_seq_num OUT NOCOPY JTF_NUMBER_TABLE,
x_requisition_type OUT NOCOPY JTF_VARCHAR2_TABLE_100,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_data OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER
)IS
BEGIN
NULL;