1: PACKAGE BODY jtf_rs_salesreps_pub AS
2: /* $Header: jtfrspsb.pls 120.4 2005/10/17 17:18:37 nsinghai ship $ */
3:
4: /*****************************************************************************************
5: This package body defines the procedures for managing Salesreps , like
12: ******************************************************************************************/
13:
14: /* Package Varianles */
15:
16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_SALESREPS_PUB';
17:
18: /* Procedure to create the Salesreps
19: based on input values passed by calling routines. */
20:
21: PROCEDURE create_salesrep
22: (P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
26: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
22: (P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
26: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
23: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
26: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
26: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
25: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
26: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
26: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
27: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
28: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
29: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
37: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
30: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
37: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
38: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
31: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
37: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
38: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
39: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
32: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
37: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
38: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
39: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
40: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
33: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
37: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
38: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
39: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
40: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
37: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
38: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
39: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
40: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42: X_MSG_COUNT OUT NOCOPY NUMBER,
35: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
37: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
38: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
39: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
40: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42: X_MSG_COUNT OUT NOCOPY NUMBER,
43: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
37: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
38: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
39: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
40: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42: X_MSG_COUNT OUT NOCOPY NUMBER,
43: X_MSG_DATA OUT NOCOPY VARCHAR2,
44: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
40: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
42: X_MSG_COUNT OUT NOCOPY NUMBER,
43: X_MSG_DATA OUT NOCOPY VARCHAR2,
44: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
45: ) IS
46:
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
45: ) IS
46:
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
49: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
50: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
51: l_name jtf_rs_salesreps.name%type := p_name;
52: l_status jtf_rs_salesreps.status%type := p_status;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
46:
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
49: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
50: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
51: l_name jtf_rs_salesreps.name%type := p_name;
52: l_status jtf_rs_salesreps.status%type := p_status;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
49: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
50: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
51: l_name jtf_rs_salesreps.name%type := p_name;
52: l_status jtf_rs_salesreps.status%type := p_status;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
48: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
49: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
50: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
51: l_name jtf_rs_salesreps.name%type := p_name;
52: l_status jtf_rs_salesreps.status%type := p_status;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
49: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
50: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
51: l_name jtf_rs_salesreps.name%type := p_name;
52: l_status jtf_rs_salesreps.status%type := p_status;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
50: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
51: l_name jtf_rs_salesreps.name%type := p_name;
52: l_status jtf_rs_salesreps.status%type := p_status;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
51: l_name jtf_rs_salesreps.name%type := p_name;
52: l_status jtf_rs_salesreps.status%type := p_status;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
52: l_status jtf_rs_salesreps.status%type := p_status;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
53: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
61: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
54: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
61: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
62: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
55: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
61: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
62: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
63: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
56: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
61: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
62: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
63: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
64: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
57: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
61: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
62: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
63: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
64: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
65: -- added for NOCOPY
58: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
61: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
62: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
63: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
64: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
65: -- added for NOCOPY
66: l_resource_id_out jtf_rs_salesreps.resource_id%type;
59: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
61: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
62: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
63: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
64: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
65: -- added for NOCOPY
66: l_resource_id_out jtf_rs_salesreps.resource_id%type;
67:
60: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
61: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
62: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
63: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
64: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
65: -- added for NOCOPY
66: l_resource_id_out jtf_rs_salesreps.resource_id%type;
67:
68: BEGIN
62: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
63: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
64: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
65: -- added for NOCOPY
66: l_resource_id_out jtf_rs_salesreps.resource_id%type;
67:
68: BEGIN
69:
70: SAVEPOINT create_salesreps_pub;
150:
151:
152: /* Calling Private API to insert salesrep */
153:
154: jtf_rs_salesreps_pvt.create_salesrep(
155: P_API_VERSION => 1,
156: P_INIT_MSG_LIST => fnd_api.g_false,
157: P_COMMIT => fnd_api.g_false,
158: P_RESOURCE_ID => l_resource_id,
186:
187: ELSE
188:
189: /* Call the private procedure for Migration. */
190: jtf_rs_salesreps_pvt.create_salesrep_migrate(
191: P_API_VERSION => 1,
192: P_INIT_MSG_LIST => fnd_api.g_false,
193: P_COMMIT => fnd_api.g_false,
194: P_RESOURCE_ID => l_resource_id,
279: PROCEDURE create_salesrep_migrate
280: (P_API_VERSION IN NUMBER,
281: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
282: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
283: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
284: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
280: (P_API_VERSION IN NUMBER,
281: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
282: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
283: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
284: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
281: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
282: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
283: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
284: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
282: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
283: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
284: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
283: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
284: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
284: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
285: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
286: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
287: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT SYSDATE,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
288: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
289: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
290: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT NULL,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
291: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT NULL,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
292: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
293: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
294: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
295: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
296: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
297: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
298: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
299: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
300: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
301: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
302: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
303: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
304: P_ATTRIBUTE4 IN JTF_RS_SALESREPS.ATTRIBUTE4%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
312: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
305: P_ATTRIBUTE5 IN JTF_RS_SALESREPS.ATTRIBUTE5%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
312: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
313: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
306: P_ATTRIBUTE6 IN JTF_RS_SALESREPS.ATTRIBUTE6%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
312: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
313: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
314: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
307: P_ATTRIBUTE7 IN JTF_RS_SALESREPS.ATTRIBUTE7%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
312: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
313: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
314: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
315: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
308: P_ATTRIBUTE8 IN JTF_RS_SALESREPS.ATTRIBUTE8%TYPE DEFAULT NULL,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
312: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
313: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
314: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
315: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
316: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
309: P_ATTRIBUTE9 IN JTF_RS_SALESREPS.ATTRIBUTE9%TYPE DEFAULT NULL,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
312: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
313: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
314: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
315: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
316: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
317: X_MSG_COUNT OUT NOCOPY NUMBER,
310: P_ATTRIBUTE10 IN JTF_RS_SALESREPS.ATTRIBUTE10%TYPE DEFAULT NULL,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
312: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
313: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
314: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
315: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
316: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
317: X_MSG_COUNT OUT NOCOPY NUMBER,
318: X_MSG_DATA OUT NOCOPY VARCHAR2,
311: P_ATTRIBUTE11 IN JTF_RS_SALESREPS.ATTRIBUTE11%TYPE DEFAULT NULL,
312: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE DEFAULT NULL,
313: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE DEFAULT NULL,
314: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE DEFAULT NULL,
315: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
316: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
317: X_MSG_COUNT OUT NOCOPY NUMBER,
318: X_MSG_DATA OUT NOCOPY VARCHAR2,
319: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
315: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE DEFAULT NULL,
316: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
317: X_MSG_COUNT OUT NOCOPY NUMBER,
318: X_MSG_DATA OUT NOCOPY VARCHAR2,
319: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
320: ) IS
321:
322: BEGIN
323:
322: BEGIN
323:
324: --dbms_output.put_line ('Inside the create_salesrep_migrate pub body');
325:
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
323:
324: --dbms_output.put_line ('Inside the create_salesrep_migrate pub body');
325:
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
324: --dbms_output.put_line ('Inside the create_salesrep_migrate pub body');
325:
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
325:
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
346: --dbms_output.put_line ('After assigning values to the Global variables');
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
346: --dbms_output.put_line ('After assigning values to the Global variables');
347:
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
346: --dbms_output.put_line ('After assigning values to the Global variables');
347:
348: jtf_rs_salesreps_pub.create_salesrep (
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
346: --dbms_output.put_line ('After assigning values to the Global variables');
347:
348: jtf_rs_salesreps_pub.create_salesrep (
349: P_API_VERSION => P_API_VERSION,
350: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
351: P_COMMIT => P_COMMIT,
352: P_RESOURCE_ID => P_RESOURCE_ID,
378: PROCEDURE update_salesrep
379: (P_API_VERSION IN NUMBER,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
379: (P_API_VERSION IN NUMBER,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
380: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
381: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
382: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
383: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
384: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
385: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
386: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
387: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
388: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE DEFAULT FND_API.G_MISS_NUM,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
389: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE DEFAULT FND_API.G_MISS_NUM,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
390: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE DEFAULT FND_API.G_MISS_NUM,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
398: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
391: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
398: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
392: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE DEFAULT FND_API.G_MISS_CHAR,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
398: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
400: X_MSG_COUNT OUT NOCOPY NUMBER,
393: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
398: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
400: X_MSG_COUNT OUT NOCOPY NUMBER,
401: X_MSG_DATA OUT NOCOPY VARCHAR2
394: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
395: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
396: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE DEFAULT FND_API.G_MISS_CHAR,
397: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
398: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
400: X_MSG_COUNT OUT NOCOPY NUMBER,
401: X_MSG_DATA OUT NOCOPY VARCHAR2
402: ) IS
402: ) IS
403:
404: l_api_version CONSTANT NUMBER := 1.0;
405: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SALESREP';
406: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
407: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
408: l_name jtf_rs_salesreps.name%type := p_name;
409: l_status jtf_rs_salesreps.status%type := p_status;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
403:
404: l_api_version CONSTANT NUMBER := 1.0;
405: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SALESREP';
406: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
407: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
408: l_name jtf_rs_salesreps.name%type := p_name;
409: l_status jtf_rs_salesreps.status%type := p_status;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
404: l_api_version CONSTANT NUMBER := 1.0;
405: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SALESREP';
406: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
407: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
408: l_name jtf_rs_salesreps.name%type := p_name;
409: l_status jtf_rs_salesreps.status%type := p_status;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
405: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SALESREP';
406: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
407: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
408: l_name jtf_rs_salesreps.name%type := p_name;
409: l_status jtf_rs_salesreps.status%type := p_status;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
406: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
407: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
408: l_name jtf_rs_salesreps.name%type := p_name;
409: l_status jtf_rs_salesreps.status%type := p_status;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
407: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
408: l_name jtf_rs_salesreps.name%type := p_name;
409: l_status jtf_rs_salesreps.status%type := p_status;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
408: l_name jtf_rs_salesreps.name%type := p_name;
409: l_status jtf_rs_salesreps.status%type := p_status;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
409: l_status jtf_rs_salesreps.status%type := p_status;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
410: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
411: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
419: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
412: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
419: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
420: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
413: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
419: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
420: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
421: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
414: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
419: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
420: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
421: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
422: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
415: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
419: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
420: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
421: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
422: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
423:
416: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
419: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
420: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
421: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
422: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
423:
424:
417: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
419: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
420: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
421: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
422: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
423:
424:
425: BEGIN
418: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
419: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
420: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
421: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
422: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
423:
424:
425: BEGIN
426:
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495:
496: /* Calling Private API to insert salesrep */
497: jtf_rs_salesreps_pvt.update_salesrep(
498: P_API_VERSION => 1,
499: P_INIT_MSG_LIST => fnd_api.g_false,
500: P_COMMIT => fnd_api.g_false,
501: P_SALESREP_ID => l_salesrep_id,
563:
564: END update_salesrep;
565:
566:
567: END JTF_RS_SALESREPS_PUB;