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.

APPS.JTF_RS_SRP_TERRITORIES_PUB dependencies on JTF_RS_SRP_TERRITORIES

Line 1: PACKAGE jtf_rs_srp_territories_pub AUTHID CURRENT_USER AS

1: PACKAGE jtf_rs_srp_territories_pub AUTHID CURRENT_USER 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

Line 19: Calls to these procedures will invoke procedures from jtf_rs_srp_territories_pvt

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:

Line 50: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

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,

Line 51: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,

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,

Line 52: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,

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,

Line 53: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,

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,

Line 54: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

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,

Line 55: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,

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

Line 59: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%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. */

Line 76: * @param p_object_version_number The object version number of the salesrep territory derives from the jtf_rs_srp_territories table.

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

Line 88: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

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,

Line 89: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,

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,

Line 90: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,

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,

Line 91: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

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,

Line 92: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

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,

Line 93: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

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

Line 94: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%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: );

Line 100: END jtf_rs_srp_territories_pub;

96: X_MSG_COUNT OUT NOCOPY NUMBER,
97: X_MSG_DATA OUT NOCOPY VARCHAR2
98: );
99:
100: END jtf_rs_srp_territories_pub;