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,
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,
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,
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,
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,
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,
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,
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