PACKAGE: APPS.FLM_MULTIPLE_SUPPLIERS

Source

1 PACKAGE FLM_MULTIPLE_SUPPLIERS
2 /* $Header: flmmsups.pls 120.1.12020000.2 2012/07/13 11:04:55 sisankar ship $ */
3 AS
4 
5 -- This procedure returns the supplier for creation of new kanban card.
6 -- It takes into account the suppliers on existing cards and sourcing
7 -- percentages of each supplier while calculating the supplier for new card
8 PROCEDURE GET_SUPPLIER(p_pull_seq_id       IN        NUMBER,
9                        p_org_id            IN        NUMBER,
10                        p_cardstatus        IN        NUMBER, --Bug#14230963 : Added the parameter p_cardstatus
11 	                   x_supplier_id      OUT NOCOPY NUMBER,
12 	                   x_supplier_site_id OUT NOCOPY NUMBER,
13 	                   x_retcode          OUT NOCOPY VARCHAR2,
14                        x_err_msg          OUT NOCOPY VARCHAR2);
15 
16 --This procedure calculates the number of cards for each supplier based on
17 --sourcing percentages
18 
19 PROCEDURE multiple_supplier_kanban_cards(p_pull_seq_id IN        NUMBER,
20 	                                       x_retcode    OUT NOCOPY VARCHAR2,
21 	                                       x_err_msg    OUT NOCOPY VARCHAR2);
22 
23 END FLM_MULTIPLE_SUPPLIERS;