PACKAGE: APPS.QP_PRICE_BOOK_HEADERS_PKG

Source

1 package QP_PRICE_BOOK_HEADERS_PKG AUTHID CURRENT_USER as
2 /* $Header: QPXUPBHS.pls 120.0 2005/10/27 04:07:21 nirmkuma noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PRICE_BOOK_HEADER_ID in NUMBER,
7   X_PRICE_BOOK_TYPE_CODE in VARCHAR2,
8   X_CURRENCY_CODE in VARCHAR2,
9   X_EFFECTIVE_DATE in DATE,
10   X_CUSTOMER_ID in VARCHAR2,
11   X_PUB_STATUS_CODE in VARCHAR2,
12   X_ITEM_CATEGORY in NUMBER,
13   X_PRICE_BASED_ON in VARCHAR2,
14   X_PL_AGR_BSA_ID in NUMBER,
15   X_PRICING_PERSPECTIVE_CODE in VARCHAR2,
16   X_ITEM_QUANTITY in NUMBER,
17   X_REQUEST_ID in NUMBER,
18   X_REQUEST_TYPE_CODE in VARCHAR2,
19   X_PB_INPUT_HEADER_ID in NUMBER,
20   X_PRICE_BOOK_NAME in VARCHAR2,
21   X_PL_AGR_BSA_NAME in VARCHAR2,
22   X_LANGUAGE in VARCHAR2,
23   X_CREATION_DATE in DATE,
24   X_CREATED_BY in NUMBER,
25   X_LAST_UPDATE_DATE in DATE,
26   X_LAST_UPDATED_BY in NUMBER,
27   X_LAST_UPDATE_LOGIN in NUMBER);
28 
29 procedure LOCK_ROW (
30   X_PRICE_BOOK_HEADER_ID in NUMBER,
31   X_PRICE_BOOK_TYPE_CODE in VARCHAR2,
32   X_CURRENCY_CODE in VARCHAR2,
33   X_EFFECTIVE_DATE in DATE,
34   X_CUSTOMER_ID in VARCHAR2,
35   X_PUB_STATUS_CODE in VARCHAR2,
36   X_ITEM_CATEGORY in NUMBER,
37   X_PRICE_BASED_ON in VARCHAR2,
38   X_PL_AGR_BSA_ID in NUMBER,
39   X_PRICING_PERSPECTIVE_CODE in VARCHAR2,
40   X_ITEM_QUANTITY in NUMBER,
41   X_REQUEST_ID in NUMBER,
42   X_REQUEST_TYPE_CODE in VARCHAR2,
43   X_PB_INPUT_HEADER_ID in NUMBER,
44   X_PRICE_BOOK_NAME in VARCHAR2,
45   X_PL_AGR_BSA_NAME in VARCHAR2,
46   X_LANGUAGE in VARCHAR2
47 );
48 procedure UPDATE_ROW (
49   X_PRICE_BOOK_HEADER_ID in NUMBER,
50   X_PRICE_BOOK_TYPE_CODE in VARCHAR2,
51   X_CURRENCY_CODE in VARCHAR2,
52   X_EFFECTIVE_DATE in DATE,
53   X_CUSTOMER_ID in VARCHAR2,
54   X_PUB_STATUS_CODE in VARCHAR2,
55   X_ITEM_CATEGORY in NUMBER,
56   X_PRICE_BASED_ON in VARCHAR2,
57   X_PL_AGR_BSA_ID in NUMBER,
58   X_PRICING_PERSPECTIVE_CODE in VARCHAR2,
59   X_ITEM_QUANTITY in NUMBER,
60   X_REQUEST_ID in NUMBER,
61   X_REQUEST_TYPE_CODE in VARCHAR2,
62   X_PB_INPUT_HEADER_ID in NUMBER,
63   X_PRICE_BOOK_NAME in VARCHAR2,
64   X_PL_AGR_BSA_NAME in VARCHAR2,
65   X_LANGUAGE in VARCHAR2,
66   X_LAST_UPDATE_DATE in DATE,
67   X_LAST_UPDATED_BY in NUMBER,
68   X_LAST_UPDATE_LOGIN in NUMBER
69 );
70 procedure DELETE_ROW (
71   X_PRICE_BOOK_HEADER_ID in NUMBER
72 );
73 procedure ADD_LANGUAGE;
74 end QP_PRICE_BOOK_HEADERS_PKG;