DBA Data[Home] [Help]

PACKAGE: APPS.ASO_CORE_CONTRACTS_PUB

Source


1 PACKAGE aso_core_contracts_pub AS
2 /* $Header: asopokcs.pls 120.1 2005/06/29 12:37:03 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_CORE_CONTRACTS_PUB
5 -- Purpose          :
6 --
7 -- History          :
8 -- NOTE             :
9 
10 -- End of Comments
11 
12 --
13 -- Possible values of P_Rel_Type are,
14 -- CONTRACTISTERMSFORQUOTE: for iStore;
15 -- CONTRACTNEGOTIATESQUOTE: for Quoting.
16 --
17 
18   PROCEDURE create_contract (
19     p_api_version               IN       NUMBER,
20     p_init_msg_list             IN       VARCHAR2 := fnd_api.g_false,
21     p_commit                    IN       VARCHAR2 := fnd_api.g_false,
22     p_quote_id                  IN       NUMBER,
23     p_terms_agreed_flag         IN       VARCHAR2 := fnd_api.g_false,
24     p_rel_type                  IN       VARCHAR2 := fnd_api.g_miss_char,
25     p_interaction_subject       IN       VARCHAR2 := fnd_api.g_miss_char,
26     p_interaction_body          IN       VARCHAR2 := fnd_api.g_miss_char,
27     p_party_id                  IN       NUMBER := fnd_api.g_miss_num,
28     p_resource_id               IN       NUMBER := fnd_api.g_miss_num,
29     p_template_id               IN       NUMBER := fnd_api.g_miss_num,
30     p_template_major_version    IN       NUMBER := fnd_api.g_miss_num,
31     x_contract_id               OUT NOCOPY /* file.sql.39 change */       NUMBER,
32     x_contract_number           OUT NOCOPY /* file.sql.39 change */       VARCHAR2,
33     x_return_status             OUT NOCOPY /* file.sql.39 change */       VARCHAR2,
34     x_msg_count                 OUT NOCOPY /* file.sql.39 change */       NUMBER,
35     x_msg_data                  OUT NOCOPY /* file.sql.39 change */       VARCHAR2
36   );
37 
38 
39 -- this procedure is used to update a contract from a quote.
40 
41   PROCEDURE update_contract (
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_quote_id                  IN       NUMBER,
46     p_contract_id               IN       NUMBER := fnd_api.g_miss_num,
47     p_interaction_subject       IN       VARCHAR2 := fnd_api.g_miss_char,
48     p_interaction_body          IN       VARCHAR2 := fnd_api.g_miss_char,
49     p_party_id                  IN       NUMBER := fnd_api.g_miss_num,
50     p_resource_id               IN       NUMBER := fnd_api.g_miss_num,
51     x_return_status             OUT NOCOPY /* file.sql.39 change */       VARCHAR2,
52     x_msg_count                 OUT NOCOPY /* file.sql.39 change */       NUMBER,
53     x_msg_data                  OUT NOCOPY /* file.sql.39 change */       VARCHAR2
54   );
55 
56 
57 --
58 -- Notification type may contain following value,
59 -- 'CONTRACT_CREATED':  contract is created;
60 -- 'CONTRACT_UPDATED':  contract is requested to update;
61 -- 'CONTRACT_CANCELED': contract is canceled;
62 -- 'CONTRACT_APPROVED': contract is approved;
63 -- 'CONTRACT_REJECTED': contract is rejected.
64 --
65 
66   PROCEDURE notify_contract_change (
67     p_api_version               IN       NUMBER,
68     p_init_msg_list             IN       VARCHAR2 := fnd_api.g_false,
69     p_commit                    IN       VARCHAR2 := fnd_api.g_false,
70     p_quote_id                  IN       NUMBER,
71     p_notification_type         IN       VARCHAR2,
72     p_customer_comments         IN       VARCHAR2 := fnd_api.g_miss_char,
73     p_salesrep_email_id         IN       VARCHAR2 := fnd_api.g_miss_char,
74     x_return_status             OUT NOCOPY /* file.sql.39 change */       VARCHAR2,
75     x_msg_count                 OUT NOCOPY /* file.sql.39 change */       NUMBER,
76     x_msg_data                  OUT NOCOPY /* file.sql.39 change */       VARCHAR2
77   );
78 
79 
80 -- vtariker
81   PROCEDURE Check_Customer_Accounts(
82     p_init_msg_list     IN            VARCHAR2  := FND_API.G_FALSE,
83     p_qte_header_id     IN            NUMBER,
84     x_return_status     OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
85     x_msg_count         OUT NOCOPY /* file.sql.39 change */  NUMBER,
86     x_msg_data          OUT NOCOPY /* file.sql.39 change */  VARCHAR2
87    );
88 -- vtariker
89 
90 END aso_core_contracts_pub;