1 PACKAGE inv_standalone_sync_pub AUTHID CURRENT_USER as
2 /* $Header: INVSLSPS.pls 120.1 2010/01/19 09:39:04 hjogleka noship $*/
3
4 -- This API updates receipt confirmation extracted flag in RT.
5 FUNCTION Update_RC_Extracted (
6 p_api_version IN NUMBER
7 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
8 , p_commit IN VARCHAR2 := FND_API.G_FALSE
9 , x_return_status OUT NOCOPY VARCHAR2
10 , x_msg_count OUT NOCOPY NUMBER
11 , x_msg_data OUT NOCOPY VARCHAR2
12 , p_start_date IN VARCHAR2
13 , p_end_date IN VARCHAR2
14 , p_category IN VARCHAR2 DEFAULT NULL
15 , p_warehouse IN VARCHAR2
16 , p_document_num IN VARCHAR2 DEFAULT NULL
17 , p_receipt_num IN VARCHAR2
18 , p_inventory_item IN VARCHAR2 DEFAULT NULL
19 , p_rc_extracted IN VARCHAR2
20 , p_transaction_id IN NUMBER DEFAULT NULL
21 ) RETURN VARCHAR2;
22
23 FUNCTION sync_adjustment_transactions(
24 p_api_version IN NUMBER
25 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
26 , p_commit IN VARCHAR2 := FND_API.G_FALSE
27 , x_return_status OUT NOCOPY VARCHAR2
28 , x_msg_count OUT NOCOPY NUMBER
29 , x_msg_data OUT NOCOPY VARCHAR2
30 , p_from_date IN DATE
31 , p_to_date IN DATE
32 , p_organization_name IN VARCHAR2
33 , p_category_name IN VARCHAR2
34 , p_inventory_item IN VARCHAR2 DEFAULT NULL
35 , p_transaction_type IN VARCHAR2 DEFAULT NULL
36 , p_transaction_source IN VARCHAR2 DEFAULT NULL
37 , p_transaction_id IN NUMBER DEFAULT NULL
38 , p_extract_flag IN VARCHAR2
39
40 ) RETURN VARCHAR2;
41
42 PROCEDURE sync_adjustment_transactions2(
43 p_api_version IN NUMBER
44 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
45 , p_commit IN VARCHAR2 := FND_API.G_FALSE
46 , x_return_status OUT NOCOPY VARCHAR2
47 , x_msg_count OUT NOCOPY NUMBER
48 , x_msg_data OUT NOCOPY VARCHAR2
49 , p_from_date IN DATE
50 , p_to_date IN DATE
51 , p_organization_id IN NUMBER
52 , p_category_name IN VARCHAR2
53 , p_inventory_item_id IN NUMBER DEFAULT NULL
54 , p_transaction_type_id IN NUMBER DEFAULT NULL
55 , p_transaction_source IN VARCHAR2 DEFAULT NULL
56 , p_transaction_id IN NUMBER DEFAULT NULL
57 , p_extract_flag IN VARCHAR2
58 );
59
60 END inv_standalone_sync_pub;