1 PACKAGE jtf_rs_srp_territories_pub AS
2 /* $Header: jtfrspis.pls 120.0 2005/05/11 08:21:12 appldev ship $ */
3 /*#
4 * Salesrep Territories API
5 * This API contains the procedures for managing resource salesrep territories
6 * like create and update resource salesrep territories.
7 * @rep:scope internal
8 * @rep:product JTF
9 * @rep:displayname Salesrep Territories API
10 * @rep:category BUSINESS_ENTITY JTF_RS_SRP_TERRITORY
11 */
12 /*****************************************************************************************
13 This is a public API that caller will invoke.
14 It provides procedures for managing resource salesrep territories, like
15 create and update resource salesrep territories, from other modules.
16 Its main procedures are as following:
17 Create Resource Salesrep Territories
18 Update Resource Salesrep Territories
19 Calls to these procedures will invoke procedures from jtf_rs_srp_territories_pvt
20 to do business validations and to do actual inserts, updates and deletes into tables.
21 ******************************************************************************************/
22
23
24 /* Procedure to create the resource salesrep territories
25 based on input values passed by calling routines. */
26 /*#
27 * Create Salesrep Territories API
28 * This procedure allows the user to create resource salesrep territories record.
29 * @param p_api_version API version
30 * @param p_init_msg_list Initialization of the message list
31 * @param p_commit Commit
32 * @param p_salesrep_id Salesperson Identifier
33 * @param p_territory_id Territory Identifier
34 * @param p_status The status of the salesperson.
35 * @param p_wh_update_date This date is sent to the data warehouse
36 * @param p_start_date_active Date on which the salesrep territories becomes active.
37 * @param p_end_date_active Date on which the salesrep territories is no longer active.
38 * @param x_return_status Output parameter for return status
39 * @param x_msg_count Output parameter for number of user messages from this procedure
40 * @param x_msg_data Output parameter containing last user message from this procedure
41 * @param x_salesrep_territory_id Out parameter for salesrep territory Identifier
42 * @rep:scope internal
43 * @rep:lifecycle active
44 * @rep:displayname Create Salesrep Territories API
45 */
46 PROCEDURE create_rs_srp_territories
47 (P_API_VERSION IN NUMBER,
48 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
50 P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
51 P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
52 P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
53 P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
54 P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
55 P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
56 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
57 X_MSG_COUNT OUT NOCOPY NUMBER,
58 X_MSG_DATA OUT NOCOPY VARCHAR2,
59 X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE
60 );
61
62 /* Procedure to update the resource salesrep territories
63 based on input values passed by calling routines. */
64 /*#
65 * Update Salesrep Territories API
66 * This procedure allows the user to update resource salesrep territories record.
67 * @param p_api_version API version
68 * @param p_init_msg_list Initialization of the message list
69 * @param p_commit Commit
70 * @param p_salesrep_id Salesperson Identifier
71 * @param p_territory_id Territory Identifier
72 * @param p_status The status of the salesperson.
73 * @param p_wh_update_date This date is sent to the data warehouse
74 * @param p_start_date_active Date on which the salesrep territories becomes active.
75 * @param p_end_date_active Date on which the salesrep territories is no longer active.
76 * @param p_object_version_number The object version number of the salesrep territory derives from the jtf_rs_srp_territories table.
77 * @param x_return_status Output parameter for return status
78 * @param x_msg_count Output parameter for number of user messages from this procedure
79 * @param x_msg_data Output parameter containing last user message from this procedure
80 * @rep:scope internal
81 * @rep:lifecycle active
82 * @rep:displayname Update Salesrep Territories API
83 */
84 PROCEDURE update_rs_srp_territories
85 (P_API_VERSION IN NUMBER,
86 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88 P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
89 P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
90 P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
91 P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
92 P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
93 P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
94 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
95 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96 X_MSG_COUNT OUT NOCOPY NUMBER,
97 X_MSG_DATA OUT NOCOPY VARCHAR2
98 );
99
100 END jtf_rs_srp_territories_pub;