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 6702: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

6698: --dbms_output('create_new_terr START');
6699:
6700: l_new_terr_rec.TERR_ID := FND_API.G_MISS_NUM;
6701: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
6702: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6703: l_new_terr_rec.CREATION_DATE := SYSDATE;
6704: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6705: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6706: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;

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

6700: l_new_terr_rec.TERR_ID := FND_API.G_MISS_NUM;
6701: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
6702: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6703: l_new_terr_rec.CREATION_DATE := SYSDATE;
6704: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6705: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6706: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
6707:
6708: /* name of new territory is derived from template name */

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

6701: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
6702: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6703: l_new_terr_rec.CREATION_DATE := SYSDATE;
6704: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6705: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6706: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
6707:
6708: /* name of new territory is derived from template name */
6709: l_new_terr_rec.NAME := p_template_terr_rec.name ||

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

6702: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6703: l_new_terr_rec.CREATION_DATE := SYSDATE;
6704: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6705: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6706: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
6707:
6708: /* name of new territory is derived from template name */
6709: l_new_terr_rec.NAME := p_template_terr_rec.name ||
6710: ' - ' || ' #';

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

6807: --dbms_output('create_copied_terr START');
6808:
6809: l_new_terr_rec.TERR_ID := FND_API.G_MISS_NUM;
6810: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
6811: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6812: l_new_terr_rec.CREATION_DATE := SYSDATE;
6813: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6814: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6815: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;

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

6809: l_new_terr_rec.TERR_ID := FND_API.G_MISS_NUM;
6810: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
6811: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6812: l_new_terr_rec.CREATION_DATE := SYSDATE;
6813: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6814: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6815: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
6816:
6817: -- 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 6814: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

6810: l_new_terr_rec.LAST_UPDATE_DATE := SYSDATE;
6811: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6812: l_new_terr_rec.CREATION_DATE := SYSDATE;
6813: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6814: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6815: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
6816:
6817: -- dbms_output.put_line('JTF_TERRITORY_PVT:create_copied_terr:l_new_terr_rec.APPLICATION_SHORT_NAME-' || l_new_terr_rec.APPLICATION_SHORT_NAME);
6818:

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

6811: l_new_terr_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6812: l_new_terr_rec.CREATION_DATE := SYSDATE;
6813: l_new_terr_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6814: l_new_terr_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6815: l_new_terr_rec.APPLICATION_SHORT_NAME := FND_GLOBAL.APPLICATION_SHORT_NAME;
6816:
6817: -- dbms_output.put_line('JTF_TERRITORY_PVT:create_copied_terr:l_new_terr_rec.APPLICATION_SHORT_NAME-' || l_new_terr_rec.APPLICATION_SHORT_NAME);
6818:
6819: -- 04/06/01 ARPATEL - START

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

6927:
6928: /* Instantiate record items from FORM items */
6929: l_terr_usgs_rec.TERR_USG_ID := FND_API.G_MISS_NUM;
6930: l_terr_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
6931: l_terr_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6932: l_terr_usgs_rec.CREATION_DATE := SYSDATE;
6933: l_terr_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6934: l_terr_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6935: l_terr_usgs_rec.TERR_ID := p_new_terr_id;

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

6929: l_terr_usgs_rec.TERR_USG_ID := FND_API.G_MISS_NUM;
6930: l_terr_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
6931: l_terr_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6932: l_terr_usgs_rec.CREATION_DATE := SYSDATE;
6933: l_terr_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6934: l_terr_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6935: l_terr_usgs_rec.TERR_ID := p_new_terr_id;
6936:
6937: l_terr_usgs_rec.SOURCE_ID := p_terr_usgs_tbl(i).source_id;

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

6930: l_terr_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
6931: l_terr_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6932: l_terr_usgs_rec.CREATION_DATE := SYSDATE;
6933: l_terr_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6934: l_terr_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6935: l_terr_usgs_rec.TERR_ID := p_new_terr_id;
6936:
6937: l_terr_usgs_rec.SOURCE_ID := p_terr_usgs_tbl(i).source_id;
6938: l_terr_usgs_rec.ORG_ID := p_terr_usgs_tbl(i).org_id;

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

6986: l_terr_qtype_usgs_rec.TERR_QUAL_TYPE_USG_ID := FND_API.G_MISS_NUM;
6987: l_terr_qtype_usgs_rec.TERR_ID := p_new_terr_id;
6988: l_terr_qtype_usgs_rec.QUAL_TYPE_USG_ID := p_terr_qtype_usgs_tbl(i).qual_type_usg_id;
6989: l_terr_qtype_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
6990: l_terr_qtype_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6991: l_terr_qtype_usgs_rec.CREATION_DATE := SYSDATE;
6992: l_terr_qtype_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6993: l_terr_qtype_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6994: l_terr_qtype_usgs_rec.ORG_ID := p_terr_qtype_usgs_tbl(i).org_id;

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

6988: l_terr_qtype_usgs_rec.QUAL_TYPE_USG_ID := p_terr_qtype_usgs_tbl(i).qual_type_usg_id;
6989: l_terr_qtype_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
6990: l_terr_qtype_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6991: l_terr_qtype_usgs_rec.CREATION_DATE := SYSDATE;
6992: l_terr_qtype_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6993: l_terr_qtype_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6994: l_terr_qtype_usgs_rec.ORG_ID := p_terr_qtype_usgs_tbl(i).org_id;
6995:
6996:

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

6989: l_terr_qtype_usgs_rec.LAST_UPDATE_DATE := SYSDATE;
6990: l_terr_qtype_usgs_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
6991: l_terr_qtype_usgs_rec.CREATION_DATE := SYSDATE;
6992: l_terr_qtype_usgs_rec.CREATED_BY := FND_GLOBAL.USER_ID;
6993: l_terr_qtype_usgs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
6994: l_terr_qtype_usgs_rec.ORG_ID := p_terr_qtype_usgs_tbl(i).org_id;
6995:
6996:
6997: create_terr_qualtype_usage(

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

7049: /* Instantiate record items from appropriate template items */
7050: l_new_terr_qual_rec.Rowid := NULL;
7051: l_new_terr_qual_rec.TERR_QUAL_ID := FND_API.G_MISS_NUM;
7052: l_new_terr_qual_rec.LAST_UPDATE_DATE := SYSDATE;
7053: l_new_terr_qual_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7054: l_new_terr_qual_rec.CREATION_DATE := SYSDATE;
7055: l_new_terr_qual_rec.CREATED_BY := FND_GLOBAL.USER_ID;
7056: l_new_terr_qual_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7057:

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

7051: l_new_terr_qual_rec.TERR_QUAL_ID := FND_API.G_MISS_NUM;
7052: l_new_terr_qual_rec.LAST_UPDATE_DATE := SYSDATE;
7053: l_new_terr_qual_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7054: l_new_terr_qual_rec.CREATION_DATE := SYSDATE;
7055: l_new_terr_qual_rec.CREATED_BY := FND_GLOBAL.USER_ID;
7056: l_new_terr_qual_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7057:
7058: /* this value is passed into procedure */
7059: l_new_terr_qual_rec.TERR_ID := p_new_terr_id;

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

7052: l_new_terr_qual_rec.LAST_UPDATE_DATE := SYSDATE;
7053: l_new_terr_qual_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7054: l_new_terr_qual_rec.CREATION_DATE := SYSDATE;
7055: l_new_terr_qual_rec.CREATED_BY := FND_GLOBAL.USER_ID;
7056: l_new_terr_qual_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7057:
7058: /* this value is passed into procedure */
7059: l_new_terr_qual_rec.TERR_ID := p_new_terr_id;
7060:

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

7134:
7135: /* Instantiate record items from template qualifier value record */
7136: l_new_terr_value_rec.TERR_VALUE_ID := NULL;
7137: l_new_terr_value_rec.LAST_UPDATE_DATE := SYSDATE;
7138: l_new_terr_value_rec.LAST_UPDATED_BY := fnd_global.user_id;
7139: l_new_terr_value_rec.CREATION_DATE := SYSDATE;
7140: l_new_terr_value_rec.CREATED_BY := fnd_global.user_id;
7141: l_new_terr_value_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
7142:

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

7136: l_new_terr_value_rec.TERR_VALUE_ID := NULL;
7137: l_new_terr_value_rec.LAST_UPDATE_DATE := SYSDATE;
7138: l_new_terr_value_rec.LAST_UPDATED_BY := fnd_global.user_id;
7139: l_new_terr_value_rec.CREATION_DATE := SYSDATE;
7140: l_new_terr_value_rec.CREATED_BY := fnd_global.user_id;
7141: l_new_terr_value_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
7142:
7143: /* this value comes from newly created territory qualifier (above) */
7144: l_new_terr_value_rec.TERR_QUAL_ID := p_new_terr_qual_id;

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

7137: l_new_terr_value_rec.LAST_UPDATE_DATE := SYSDATE;
7138: l_new_terr_value_rec.LAST_UPDATED_BY := fnd_global.user_id;
7139: l_new_terr_value_rec.CREATION_DATE := SYSDATE;
7140: l_new_terr_value_rec.CREATED_BY := fnd_global.user_id;
7141: l_new_terr_value_rec.LAST_UPDATE_LOGIN := fnd_global.login_id;
7142:
7143: /* this value comes from newly created territory qualifier (above) */
7144: l_new_terr_value_rec.TERR_QUAL_ID := p_new_terr_qual_id;
7145: