eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_SRP_TERRITORIES_PVT dependencies on JTF_RS_SRP_TERRITORIES_S

Line 26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

22: PROCEDURE create_rs_srp_territories
23: (P_API_VERSION IN NUMBER,
24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

Line 28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,

Line 30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,

Line 51: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE

47: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,
50: X_MSG_DATA OUT NOCOPY VARCHAR2,
51: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE
52: )IS
53:
54: l_api_version CONSTANT NUMBER := 1.0;
55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';

Line 57: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;

53:
54: l_api_version CONSTANT NUMBER := 1.0;
55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
56: l_rowid ROWID;
57: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;

Line 59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;

55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
56: l_rowid ROWID;
57: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;

Line 62: l_status jtf_rs_srp_territories.status%type := p_status;

58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;

Line 63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;

59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;

Line 321: SELECT jtf_rs_srp_territories_s.nextval

317: END IF;
318: END IF;
319:
320: --Get the next value of the Salesrep_Territory_Id from the sequence
321: SELECT jtf_rs_srp_territories_s.nextval
322: INTO l_salesrep_territory_id
323: FROM dual;
324:
325: --Insert the row into the table by calling the table handler

Line 531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

527: PROCEDURE update_rs_srp_territories(
528: P_API_VERSION IN NUMBER,
529: P_INIT_MSG_LIST IN VARCHAR2,
530: P_COMMIT IN VARCHAR2,
531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

Line 532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

528: P_API_VERSION IN NUMBER,
529: P_INIT_MSG_LIST IN VARCHAR2,
530: P_COMMIT IN VARCHAR2,
531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,

Line 534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

530: P_COMMIT IN VARCHAR2,
531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,

Line 560: l_status jtf_rs_srp_territories.status%type := p_status;

556: )IS
557:
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
560: l_status jtf_rs_srp_territories.status%type := p_status;
561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;

Line 562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;

558: l_api_version CONSTANT NUMBER := 1.0;
559: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
560: l_status jtf_rs_srp_territories.status%type := p_status;
561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;

Line 564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;

560: l_status jtf_rs_srp_territories.status%type := p_status;
561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;

Line 566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;

562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;