1 PACKAGE CST_RevenueCogsMatch_GRP AUTHID CURRENT_USER AS
2 /* $Header: CSTRCMGS.pls 120.0.12010000.1 2008/07/24 17:23:39 appldev ship $ */
3
4
5
6 -----------------------------------------------------------------------------
7 -- Start of comments --
8 -- --
9 -- PROCEDURE --
10 -- Receive_CloseLineEvent The Order Management module will call this --
11 -- procedure during line closure when they need --
12 -- to notify Costing of a revenue line ID that --
13 -- will not be invoiced in AR. By calling this --
14 -- procedure they are essentially telling Costing --
15 -- that revenue is recognized at 100% for this --
16 -- order line. --
17 -- --
18 -- --
19 -- VERSION 1.0 --
20 -- --
21 -- STANDARD PARAMETERS --
22 -- P_API_VERSION API Version # - REQUIRED: enter 1.0 --
23 -- P_INIT_MSG_LIST Initialize message list? True/False --
24 -- P_COMMIT Should the API commit before returning? True/False --
25 -- P_VALIDATION_LEVEL Specify the level of validation on the inputs --
26 -- X_RETURN_STATUS Success/Error/Unexplained error - 'S','E', or 'U' --
27 -- X_MSG_COUNT Message Count - # of messages placed in message list--
28 -- X_MSG_DATA Message Text - returns msg contents if msg_count = 1--
29 -- --
30 -- API SPECIFIC PARAMETERS --
31 -- P_REVENUE_EVENT_LINE_ID Order Line ID for which COGS will be matched --
32 -- against, but for which there was no invoicing --
33 -- P_EVENT_DATE Date that the order line is closed --
34 -- P_OU_ID Operating Unit ID --
35 -- P_INVENTORY_ITEM_ID Inventory Item ID --
36 -- --
37 -- HISTORY: --
38 -- 04/28/05 Bryan Kuntz Created --
39 -- End of comments --
40 -----------------------------------------------------------------------------
41 PROCEDURE Receive_CloseLineEvent(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_revenue_event_line_id IN NUMBER,
50 p_event_date IN DATE,
51 p_ou_id IN NUMBER,
52 p_inventory_item_id IN NUMBER
53 );
54
55
56 -----------------------------------------------------------------------------
57 -- Start of comments --
58 -- --
59 -- PROCEDURE --
60 -- Return_PeriodStatuses Oracle Receivables will call this procedure --
61 -- whenever they attempt to reopen one of their --
62 -- accounting periods for a given set of books. --
63 -- This procedure will check the Costing period --
64 -- for all of the organizations that belong to --
65 -- that set of books. If any are closed, it will --
66 -- indicate this upon return. --
67 -- --
68 -- --
69 -- VERSION 1.0 --
70 -- --
71 -- STANDARD PARAMETERS --
72 -- P_API_VERSION API Version # - REQUIRED: enter 1.0 --
73 -- P_INIT_MSG_LIST Initialize message list? True/False --
74 -- P_COMMIT Should the API commit before returning? True/False --
75 -- P_VALIDATION_LEVEL Specify the level of validation on the inputs --
76 -- X_RETURN_STATUS Success/Error/Unexplained error - 'S','E', or 'U' --
77 -- X_MSG_COUNT Message Count - # of messages placed in message list--
78 -- X_MSG_DATA Message Text - returns msg contents if msg_count = 1--
79 -- --
80 -- API SPECIFIC PARAMETERS --
81 -- P_SET_OF_BOOKS_ID Set of Books Unique Identifier --
82 -- P_EFFECTIVE_PERIOD_NUM Period Year * 10000 + Period Num --
83 -- X_CLOSED_CST_PERIODS 'Y' if any of the organizations in the set --
84 -- of books passed in have a closed period, --
85 -- 'N' otherwise --
86 -- --
87 -- HISTORY: --
88 -- 05/09/05 Bryan Kuntz Created --
89 -- End of comments --
90 -----------------------------------------------------------------------------
91 PROCEDURE Return_PeriodStatuses(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94 p_commit IN VARCHAR2 := FND_API.G_FALSE,
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_set_of_books_id IN NUMBER,
100 p_effective_period_num IN NUMBER,
101 x_closed_cst_periods OUT NOCOPY VARCHAR2
102 );
103
104 END CST_RevenueCogsMatch_GRP;