eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE: APPS.QPR_PRICE_PLANS_PKG

Source


1 package QPR_PRICE_PLANS_PKG as
2 /* $Header: QPRUPPLS.pls 120.0 2007/12/24 20:04:21 vinnaray noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_PRICE_PLAN_ID in NUMBER,
6   X_REQUEST_ID in NUMBER,
7   X_PROGRAM_LOGIN_ID in NUMBER,
8   X_INSTANCE_ID in NUMBER,
9   X_AW_TYPE_CODE in VARCHAR2,
10   X_AW_STATUS_CODE in VARCHAR2,
11   X_TEMPLATE_FLAG in VARCHAR2,
12   X_SEEDED_FLAG in VARCHAR2,
13   X_AW_CODE in VARCHAR2,
14   X_AW_CREATED_FLAG in VARCHAR2,
15   X_START_DATE in DATE,
16   X_END_DATE in DATE,
17   X_BASE_UOM_CODE in VARCHAR2,
18   X_USE_FOR_DEAL_FLAG in VARCHAR2,
19   X_CURRENCY_CODE in VARCHAR2,
20   X_AW_XML in CLOB,
21   X_NAME in VARCHAR2,
22   X_DESCRIPTION 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 procedure LOCK_ROW (
29   X_PRICE_PLAN_ID in NUMBER,
30   X_REQUEST_ID in NUMBER,
31   X_PROGRAM_LOGIN_ID in NUMBER,
32   X_INSTANCE_ID in NUMBER,
33   X_AW_TYPE_CODE in VARCHAR2,
34   X_AW_STATUS_CODE in VARCHAR2,
35   X_TEMPLATE_FLAG in VARCHAR2,
36   X_SEEDED_FLAG in VARCHAR2,
37   X_AW_CODE in VARCHAR2,
38   X_AW_CREATED_FLAG in VARCHAR2,
39   X_START_DATE in DATE,
40   X_END_DATE in DATE,
41   X_BASE_UOM_CODE in VARCHAR2,
42   X_USE_FOR_DEAL_FLAG in VARCHAR2,
43   X_CURRENCY_CODE in VARCHAR2,
44   X_AW_XML in CLOB,
45   X_NAME in VARCHAR2,
46   X_DESCRIPTION in VARCHAR2
47 );
48 procedure UPDATE_ROW (
49   X_PRICE_PLAN_ID in NUMBER,
50   X_REQUEST_ID in NUMBER,
51   X_PROGRAM_LOGIN_ID in NUMBER,
52   X_INSTANCE_ID in NUMBER,
53   X_AW_TYPE_CODE in VARCHAR2,
54   X_AW_STATUS_CODE in VARCHAR2,
55   X_TEMPLATE_FLAG in VARCHAR2,
56   X_SEEDED_FLAG in VARCHAR2,
57   X_AW_CODE in VARCHAR2,
58   X_AW_CREATED_FLAG in VARCHAR2,
59   X_START_DATE in DATE,
60   X_END_DATE in DATE,
61   X_BASE_UOM_CODE in VARCHAR2,
62   X_USE_FOR_DEAL_FLAG in VARCHAR2,
63   X_CURRENCY_CODE in VARCHAR2,
64   X_AW_XML in CLOB,
65   X_NAME in VARCHAR2,
66   X_DESCRIPTION in VARCHAR2,
67   X_LAST_UPDATE_DATE in DATE,
68   X_LAST_UPDATED_BY in NUMBER,
69   X_LAST_UPDATE_LOGIN in NUMBER
70 );
71 procedure DELETE_ROW (
72   X_PRICE_PLAN_ID in NUMBER
73 );
74 procedure ADD_LANGUAGE;
75 end QPR_PRICE_PLANS_PKG;