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_SALESREPS_PVT dependencies on JTF_RS_SALESREPS_S

Line 14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

10: P_API_VERSION IN NUMBER,
11: P_INIT_MSG_LIST IN VARCHAR2,
12: P_COMMIT IN VARCHAR2,
13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

Line 16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,

12: P_COMMIT IN VARCHAR2,
13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,

Line 17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

13: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
14: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
15: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
16: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

Line 23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

19: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

Line 24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

20: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
21: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
22: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

Line 27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

23: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,

Line 28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

24: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
25: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
26: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
27: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
28: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
29: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,

Line 48: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

44: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
49: )
50: IS
51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
52: l_api_version CONSTANT NUMBER := 1.0;

Line 55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;

51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALESREP';
52: l_api_version CONSTANT NUMBER := 1.0;
53: l_rowid ROWID;
54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;

Line 57: l_status jtf_rs_salesreps.status%type := p_status;

53: l_rowid ROWID;
54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;

Line 58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;

54: l_resource_id jtf_rs_salesreps.resource_id%type := p_resource_id;
55: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id;
56: l_name jtf_rs_salesreps.name%type := p_name;
57: l_status jtf_rs_salesreps.status%type := p_status;
58: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;

Line 63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;

59: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;

Line 64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;

60: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
61: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
62: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;

Line 67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;

63: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;

Line 68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;

64: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
65: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
66: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;
72: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;

Line 71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;

67: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
68: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
69: l_category jtf_rs_resource_extns.category%type;
70: l_person_id jtf_rs_salesreps.person_id%type;
71: l_salesrep_id jtf_rs_salesreps.salesrep_id%type;
72: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
73: l_msg_data VARCHAR2(2000);
74: l_msg_count NUMBER;
75: l_check_char VARCHAR2(1);

Line 89: CURSOR c_dup_salesrep_id (l_salesrep_id IN jtf_rs_salesreps.salesrep_id%type,

85: SELECT 'Y'
86: FROM jtf_rs_salesreps
87: WHERE rowid = l_rowid;
88:
89: CURSOR c_dup_salesrep_id (l_salesrep_id IN jtf_rs_salesreps.salesrep_id%type,
90: l_org_id IN jtf_rs_salesreps.org_id%type )
91: IS
92: SELECT 'X'
93: FROM jtf_rs_salesreps

Line 339: SELECT jtf_rs_salesreps_s.nextval

335:
336: /* Get the next value of the Salesrep_id from the sequence. */
337:
338: LOOP
339: SELECT jtf_rs_salesreps_s.nextval
340: INTO l_salesrep_id
341: FROM dual;
342: --dbms_output.put_line ('After Select - Salesrep ID ' || l_salesrep_id);
343:

Line 636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

632: P_API_VERSION IN NUMBER,
633: P_INIT_MSG_LIST IN VARCHAR2,
634: P_COMMIT IN VARCHAR2,
635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

Line 638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,

634: P_COMMIT IN VARCHAR2,
635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

Line 639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

635: P_RESOURCE_ID IN JTF_RS_SALESREPS.RESOURCE_ID%TYPE,
636: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
637: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
638: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
639: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,

Line 644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

640: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

Line 645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

641: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
642: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
643: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

Line 648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

644: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,

Line 649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

645: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
646: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
647: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
648: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
649: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
650: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
651: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,
652: P_ATTRIBUTE2 IN JTF_RS_SALESREPS.ATTRIBUTE2%TYPE,
653: P_ATTRIBUTE3 IN JTF_RS_SALESREPS.ATTRIBUTE3%TYPE,

Line 666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

662: P_ATTRIBUTE12 IN JTF_RS_SALESREPS.ATTRIBUTE12%TYPE,
663: P_ATTRIBUTE13 IN JTF_RS_SALESREPS.ATTRIBUTE13%TYPE,
664: P_ATTRIBUTE14 IN JTF_RS_SALESREPS.ATTRIBUTE14%TYPE,
665: P_ATTRIBUTE15 IN JTF_RS_SALESREPS.ATTRIBUTE15%TYPE,
666: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
669: X_MSG_COUNT OUT NOCOPY NUMBER,
670: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 671: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE

667: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
668: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
669: X_MSG_COUNT OUT NOCOPY NUMBER,
670: X_MSG_DATA OUT NOCOPY VARCHAR2,
671: X_SALESREP_ID OUT NOCOPY JTF_RS_SALESREPS.SALESREP_ID%TYPE
672: ) IS
673:
674: BEGIN
675:

Line 726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,

722: PROCEDURE Update_salesrep(
723: P_API_VERSION IN NUMBER,
724: P_INIT_MSG_LIST IN VARCHAR2,
725: P_COMMIT IN VARCHAR2,
726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

Line 727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,

723: P_API_VERSION IN NUMBER,
724: P_INIT_MSG_LIST IN VARCHAR2,
725: P_COMMIT IN VARCHAR2,
726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,

Line 729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,

725: P_COMMIT IN VARCHAR2,
726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,

Line 730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,

726: P_SALESREP_ID IN JTF_RS_SALESREPS.SALESREP_ID%TYPE,
727: P_SALES_CREDIT_TYPE_ID IN JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
728: P_NAME IN JTF_RS_SALESREPS.NAME%TYPE,
729: P_STATUS IN JTF_RS_SALESREPS.STATUS%TYPE,
730: P_START_DATE_ACTIVE IN JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,

Line 735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,

731: P_END_DATE_ACTIVE IN JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

Line 736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,

732: P_GL_ID_REV IN JTF_RS_SALESREPS.GL_ID_REV%TYPE,
733: P_GL_ID_FREIGHT IN JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
734: P_GL_ID_REC IN JTF_RS_SALESREPS.GL_ID_REC%TYPE,
735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

Line 739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,

735: P_SET_OF_BOOKS_ID IN JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,

Line 740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,

736: P_SALESREP_NUMBER IN JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
737: P_EMAIL_ADDRESS IN JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
738: P_WH_UPDATE_DATE IN JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
739: P_SALES_TAX_GEOCODE IN JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
740: P_SALES_TAX_INSIDE_CITY_LIMITS IN JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
741: P_ORG_ID IN JTF_RS_SALESREPS.ORG_ID%TYPE,
742: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
743: P_ATTRIBUTE_CATEGORY IN JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE,
744: P_ATTRIBUTE1 IN JTF_RS_SALESREPS.ATTRIBUTE1%TYPE,

Line 768: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;

764:
765: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SALESREP';
766: l_api_version CONSTANT NUMBER := 1.0;
767: l_rowid ROWID;
768: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
769: l_resource_id jtf_rs_salesreps.resource_id%type;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;

Line 770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id

766: l_api_version CONSTANT NUMBER := 1.0;
767: l_rowid ROWID;
768: l_salesrep_id jtf_rs_salesreps.salesrep_id%type := p_salesrep_id;
769: l_resource_id jtf_rs_salesreps.resource_id%type;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;

Line 773: l_status jtf_rs_salesreps.status%type := p_status;

769: l_resource_id jtf_rs_salesreps.resource_id%type;
770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;

Line 774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;

770: l_sales_credit_type_id jtf_rs_salesreps.sales_credit_type_id%type := p_sales_credit_type_id
771: ;
772: l_name jtf_rs_salesreps.name%type := p_name;
773: l_status jtf_rs_salesreps.status%type := p_status;
774: l_start_date_active jtf_rs_salesreps.start_date_active%type := p_start_date_active;
775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;

Line 779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;

775: l_end_date_active jtf_rs_salesreps.end_date_active%type := p_end_date_active;
776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;

Line 780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;

776: l_gl_id_rev jtf_rs_salesreps.gl_id_rev%type := p_gl_id_rev;
777: l_gl_id_freight jtf_rs_salesreps.gl_id_freight%type := p_gl_id_freight;
778: l_gl_id_rec jtf_rs_salesreps.gl_id_rec%type := p_gl_id_rec;
779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;

Line 783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;

779: l_set_of_books_id jtf_rs_salesreps.set_of_books_id%type := p_set_of_books_id;
780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
786: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
787: c_val varchar2(1);

Line 784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;

780: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;
781: l_email_address jtf_rs_salesreps.email_address%type := p_email_address;
782: l_wh_update_date jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;
783: l_sales_tax_geocode jtf_rs_salesreps.sales_tax_geocode%type := p_sales_tax_geocode;
784: l_sales_tax_inside_city_limits jtf_rs_salesreps.sales_tax_inside_city_limits%type := p_sales_tax_inside_city_limits;
785: l_org_id jtf_rs_salesreps.org_id%type := p_org_id;
786: l_object_version_number jtf_rs_salesreps.object_version_number%type := p_object_version_number;
787: c_val varchar2(1);
788: l_msg_data VARCHAR2(2000);

Line 793: CURSOR c_salesrep_update(l_salesrep_id jtf_rs_salesreps.salesrep_id%type, l_org_id jtf_rs_salesreps.org_id%type) is

789: x_var varchar2(1);
790: l_msg_count NUMBER;
791: l_bind_data_id NUMBER;
792:
793: CURSOR c_salesrep_update(l_salesrep_id jtf_rs_salesreps.salesrep_id%type, l_org_id jtf_rs_salesreps.org_id%type) is
794: SELECT salesrep_id,
795: resource_id,
796: DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,
797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,