[Home] [Help]
PACKAGE: APPS.OKS_FULFILL
Source
1 PACKAGE OKS_FULFILL AS
2 /* $Header: OKSFULFS.pls 120.0 2005/05/25 17:58:17 appldev noship $*/
3 --
4 -- Purpose: This package is been called from the concurrent program to create orders for Subscriptions
5 -- It would be decided within this package if this process would be implemented as a parallel worker
6 --
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- ADAS 10/15/02 ------ ------------------------------------------
10 -- Enter package declarations as shown below
11
12 ---------------------------------------------------------------------------
13 -- GLOBAL MESSAGE CONSTANTS
14 ---------------------------------------------------------------------------
15 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
17 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
18 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
19 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
20 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
21 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
22 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
24 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
25 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
26 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
27 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
28 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
29 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
30 G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKC_INVALID_END_DATE';
31 --
32 G_QA_SUCCESS CONSTANT VARCHAR2(200) := 'OKS__QA_SUCCESS';
33 G_PARTY_COUNT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_PARTY_COUNT';
34 G_REQUIRED_RULE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE';
35 G_REQUIRED_RULE_VALUES CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_VALUES';
36 G_REQUIRED_RULE_PARTY_ROLE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_RULE_PARTY_ROLE';
37 G_RULE_DEPENDENT_VALUE CONSTANT VARCHAR2(200) := 'OKC_RULE_DEPENDENT_VALUE';
38 G_INVALID_LINE_DATES CONSTANT VARCHAR2(200) := 'OKC_INVALID_LINE_DATES';
39 G_REQUIRED_LINE_VALUE CONSTANT VARCHAR2(200) := 'OKC_REQUIRED_LINE_FIELD';
40 G_INVALID_LINE_CURRENCY CONSTANT VARCHAR2(200) := 'OKC_INVALID_LINE_CURRENCY';
41 G_INVALID_LINE_ITEM CONSTANT VARCHAR2(200) := 'OKS_INVALID_LINE_ITEM';
42 G_REQUIRED_COVERED_LINE CONSTANT VARCHAR2(200) := 'OKS_REQUIRED_COVERED_LINE';
43 G_INVALID_COVERAGE_LINE CONSTANT VARCHAR2(200) := 'OKS_INVALID_COVERAGE_LINE';
44 G_COVERAGE_OVERLAP CONSTANT VARCHAR2(200) := 'OKS_COVERAGE_OVERLAP';
45 G_PARTY_ROLE CONSTANT VARCHAR2(200) := 'OKS_PARTY_ROLE';
46 G_BASE_READING CONSTANT VARCHAR2(200) := 'OKS_COUNTER_BASE_READING';
47 G_BILL_ATTR CONSTANT VARCHAR2(200) := 'OKS_BILLING_ATTRIBUTES';
48 G_SHORT_DESC CONSTANT VARCHAR2(200) := 'OKS_HDR_SHORT_DESC';
49 G_QA_CHECK CONSTANT VARCHAR2(200) := 'OKS_QA_CHECK_LIST';
50 G_K_GROUP CONSTANT VARCHAR2(200) := 'OKS_CONTRACT_GROUP';
51 G_WORKFLOW CONSTANT VARCHAR2(200) := 'OKS_WORK_FLOW';
52 G_DEFAULT_READING CONSTANT VARCHAR2(200) := 'OKS_COUNTER_DEFAULT_READING';
53 G_PRICE_LIST CONSTANT VARCHAR2(200) := 'OKS_PRICE_LIST';
54
55 G_ONE_CUST_CONTACT CONSTANT VARCHAR2(200) := 'OKS_ONE_CUST_CONTACT';
56 G_INVALID_TAX_EXEMPT CONSTANT VARCHAR2(200) := 'OKS_INVALID_TAX_EXEMPT';
57 G_CUSTOMER_ON_CREDIT_HOLD CONSTANT VARCHAR2(200) := 'OKS_CUST_ON_CREDIT_HOLD';
58 G_REQUIRED_FIELD CONSTANT VARCHAR2(200) := 'OKS_REQUIRED_FIELD';
59 G_AUTHORIZE_PAYMENT CONSTANT VARCHAR2(200) := 'AUTHORIZE_PAYMENT';
60 G_PRECESION CONSTANT NUMBER := .01;
61 G_Return_Status Varchar2(1) := 'S';
62 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
63
64 -- GLOBAL VARIABLES
65 ---------------------------------------------------------------------------
66 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_FULFILL';
67 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
68 ---------------------------------------------------------------------------
69
70
71 PROCEDURE Submit
72 (
73 ERRBUF OUT NOCOPY VARCHAR2,
74 RETCODE OUT NOCOPY NUMBER,
75 p_contract_hdr_id IN NUMBER,
76 P_default_date IN VARCHAR2,
77 p_org_id IN NUMBER,
78 P_Customer_id IN NUMBER,
79 P_Grp_Id IN NUMBER
80 );
81
82
83 END OKS_FULFILL; -- Package spec
84