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_TERRITORY_PVT dependencies on FND_GLOBAL

Line 73: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;

69: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERRITORY_PVT';
70: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvterb.pls';
71:
72:
73: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
74: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
75: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
76: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
77: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;

Line 74: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

70: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvterb.pls';
71:
72:
73: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
74: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
75: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
76: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
77: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
78: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;

Line 75: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;

71:
72:
73: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
74: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
75: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
76: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
77: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
78: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
79: /* ARPATEL 041801 */

Line 76: G_USER_ID NUMBER := FND_GLOBAL.User_Id;

72:
73: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
74: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
75: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
76: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
77: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
78: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
79: /* ARPATEL 041801 */
80: G_Debug BOOLEAN := FALSE;

Line 77: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;

73: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
74: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
75: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
76: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
77: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
78: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
79: /* ARPATEL 041801 */
80: G_Debug BOOLEAN := FALSE;
81:

Line 78: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;

74: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
75: G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
76: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
77: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
78: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
79: /* ARPATEL 041801 */
80: G_Debug BOOLEAN := FALSE;
81:
82: /*-------------------*/

Line 8266: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

8262: --dbms_output('create_new_terr START');
8263:
8264: l_new_terr_rec.TERR_ID := FND_API.G_MISS_NUM;
8265: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
8266: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8267: l_new_terr_rec.CREATION_DATE := SYSDATE;
8268: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8269: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8270: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;

Line 8268: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;

8264: l_new_terr_rec.TERR_ID := FND_API.G_MISS_NUM;
8265: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
8266: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8267: l_new_terr_rec.CREATION_DATE := SYSDATE;
8268: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8269: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8270: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
8271:
8272: /* name of new territory is derived from template name */

Line 8269: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

8265: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
8266: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8267: l_new_terr_rec.CREATION_DATE := SYSDATE;
8268: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8269: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8270: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
8271:
8272: /* name of new territory is derived from template name */
8273: l_new_terr_rec.NAME := p_template_terr_rec.name ||

Line 8270: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;

8266: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8267: l_new_terr_rec.CREATION_DATE := SYSDATE;
8268: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8269: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8270: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
8271:
8272: /* name of new territory is derived from template name */
8273: l_new_terr_rec.NAME := p_template_terr_rec.name ||
8274: ' - ' || ' #';

Line 8375: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

8371: --dbms_output('create_copied_terr START');
8372:
8373: l_new_terr_rec.TERR_ID := FND_API.G_MISS_NUM;
8374: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
8375: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8376: l_new_terr_rec.CREATION_DATE := SYSDATE;
8377: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8378: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8379: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;

Line 8377: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;

8373: l_new_terr_rec.TERR_ID := FND_API.G_MISS_NUM;
8374: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
8375: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8376: l_new_terr_rec.CREATION_DATE := SYSDATE;
8377: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8378: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8379: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
8380:
8381: -- dbms_output.put_line('JTF_TERRITORY_PVT:create_copied_terr:l_new_terr_rec.APPLICATION_SHORT_NAME-' || l_new_terr_rec.APPLICATION_SHORT_NAME);

Line 8378: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

8374: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
8375: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8376: l_new_terr_rec.CREATION_DATE := SYSDATE;
8377: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8378: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8379: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
8380:
8381: -- dbms_output.put_line('JTF_TERRITORY_PVT:create_copied_terr:l_new_terr_rec.APPLICATION_SHORT_NAME-' || l_new_terr_rec.APPLICATION_SHORT_NAME);
8382:

Line 8379: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;

8375: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8376: l_new_terr_rec.CREATION_DATE := SYSDATE;
8377: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8378: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8379: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
8380:
8381: -- dbms_output.put_line('JTF_TERRITORY_PVT:create_copied_terr:l_new_terr_rec.APPLICATION_SHORT_NAME-' || l_new_terr_rec.APPLICATION_SHORT_NAME);
8382:
8383: -- 04/06/01 ARPATEL - START

Line 8495: l_terr_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

8491:
8492: /* Instantiate record items from FORM items */
8493: l_terr_usgs_rec.TERR_USG_ID := FND_API.G_MISS_NUM;
8494: l_terr_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
8495: l_terr_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8496: l_terr_usgs_rec.CREATION_DATE := SYSDATE;
8497: l_terr_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8498: l_terr_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8499: l_terr_usgs_rec.TERR_ID := p_new_terr_id;

Line 8497: l_terr_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;

8493: l_terr_usgs_rec.TERR_USG_ID := FND_API.G_MISS_NUM;
8494: l_terr_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
8495: l_terr_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8496: l_terr_usgs_rec.CREATION_DATE := SYSDATE;
8497: l_terr_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8498: l_terr_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8499: l_terr_usgs_rec.TERR_ID := p_new_terr_id;
8500:
8501: l_terr_usgs_rec.SOURCE_ID := p_terr_usgs_tbl(i).source_id;

Line 8498: l_terr_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

8494: l_terr_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
8495: l_terr_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8496: l_terr_usgs_rec.CREATION_DATE := SYSDATE;
8497: l_terr_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8498: l_terr_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8499: l_terr_usgs_rec.TERR_ID := p_new_terr_id;
8500:
8501: l_terr_usgs_rec.SOURCE_ID := p_terr_usgs_tbl(i).source_id;
8502: l_terr_usgs_rec.ORG_ID := p_terr_usgs_tbl(i).org_id;

Line 8554: l_terr_qtype_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

8550: l_terr_qtype_usgs_rec.TERR_QUAL_TYPE_USG_ID := FND_API.G_MISS_NUM;
8551: l_terr_qtype_usgs_rec.TERR_ID := p_new_terr_id;
8552: l_terr_qtype_usgs_rec.QUAL_TYPE_USG_ID := p_terr_qtype_usgs_tbl(i).qual_type_usg_id;
8553: l_terr_qtype_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
8554: l_terr_qtype_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8555: l_terr_qtype_usgs_rec.CREATION_DATE := SYSDATE;
8556: l_terr_qtype_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8557: l_terr_qtype_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8558: l_terr_qtype_usgs_rec.ORG_ID := p_terr_qtype_usgs_tbl(i).org_id;

Line 8556: l_terr_qtype_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;

8552: l_terr_qtype_usgs_rec.QUAL_TYPE_USG_ID := p_terr_qtype_usgs_tbl(i).qual_type_usg_id;
8553: l_terr_qtype_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
8554: l_terr_qtype_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8555: l_terr_qtype_usgs_rec.CREATION_DATE := SYSDATE;
8556: l_terr_qtype_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8557: l_terr_qtype_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8558: l_terr_qtype_usgs_rec.ORG_ID := p_terr_qtype_usgs_tbl(i).org_id;
8559:
8560:

Line 8557: l_terr_qtype_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

8553: l_terr_qtype_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
8554: l_terr_qtype_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8555: l_terr_qtype_usgs_rec.CREATION_DATE := SYSDATE;
8556: l_terr_qtype_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8557: l_terr_qtype_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8558: l_terr_qtype_usgs_rec.ORG_ID := p_terr_qtype_usgs_tbl(i).org_id;
8559:
8560:
8561: create_terr_qualtype_usage(

Line 8617: l_new_terr_qual_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

8613: /* Instantiate record items from appropriate template items */
8614: l_new_terr_qual_rec.Rowid := NULL;
8615: l_new_terr_qual_rec.TERR_QUAL_ID := FND_API.G_MISS_NUM;
8616: l_new_terr_qual_rec.LAST_UPDATE_DATE := SYSDATE;
8617: l_new_terr_qual_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8618: l_new_terr_qual_rec.CREATION_DATE := SYSDATE;
8619: l_new_terr_qual_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8620: l_new_terr_qual_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8621:

Line 8619: l_new_terr_qual_rec.CREATED_BY := FND_GLOBAL.USER_ID;

8615: l_new_terr_qual_rec.TERR_QUAL_ID := FND_API.G_MISS_NUM;
8616: l_new_terr_qual_rec.LAST_UPDATE_DATE := SYSDATE;
8617: l_new_terr_qual_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8618: l_new_terr_qual_rec.CREATION_DATE := SYSDATE;
8619: l_new_terr_qual_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8620: l_new_terr_qual_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8621:
8622: /* this value is passed into procedure */
8623: l_new_terr_qual_rec.TERR_ID := p_new_terr_id;

Line 8620: l_new_terr_qual_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

8616: l_new_terr_qual_rec.LAST_UPDATE_DATE := SYSDATE;
8617: l_new_terr_qual_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
8618: l_new_terr_qual_rec.CREATION_DATE := SYSDATE;
8619: l_new_terr_qual_rec.CREATED_BY := FND_GLOBAL.USER_ID;
8620: l_new_terr_qual_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
8621:
8622: /* this value is passed into procedure */
8623: l_new_terr_qual_rec.TERR_ID := p_new_terr_id;
8624:

Line 8702: l_new_terr_value_rec.LAST_UPDATED_BY := fnd_global.user_id;

8698:
8699: /* Instantiate record items from template qualifier value record */
8700: l_new_terr_value_rec.TERR_VALUE_ID := NULL;
8701: l_new_terr_value_rec.LAST_UPDATE_DATE := SYSDATE;
8702: l_new_terr_value_rec.LAST_UPDATED_BY := fnd_global.user_id;
8703: l_new_terr_value_rec.CREATION_DATE := SYSDATE;
8704: l_new_terr_value_rec.CREATED_BY := fnd_global.user_id;
8705: l_new_terr_value_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
8706:

Line 8704: l_new_terr_value_rec.CREATED_BY := fnd_global.user_id;

8700: l_new_terr_value_rec.TERR_VALUE_ID := NULL;
8701: l_new_terr_value_rec.LAST_UPDATE_DATE := SYSDATE;
8702: l_new_terr_value_rec.LAST_UPDATED_BY := fnd_global.user_id;
8703: l_new_terr_value_rec.CREATION_DATE := SYSDATE;
8704: l_new_terr_value_rec.CREATED_BY := fnd_global.user_id;
8705: l_new_terr_value_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
8706:
8707: /* this value comes from newly created territory qualifier (above) */
8708: l_new_terr_value_rec.TERR_QUAL_ID := p_new_terr_qual_id;

Line 8705: l_new_terr_value_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;

8701: l_new_terr_value_rec.LAST_UPDATE_DATE := SYSDATE;
8702: l_new_terr_value_rec.LAST_UPDATED_BY := fnd_global.user_id;
8703: l_new_terr_value_rec.CREATION_DATE := SYSDATE;
8704: l_new_terr_value_rec.CREATED_BY := fnd_global.user_id;
8705: l_new_terr_value_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
8706:
8707: /* this value comes from newly created territory qualifier (above) */
8708: l_new_terr_value_rec.TERR_QUAL_ID := p_new_terr_qual_id;
8709: