APPS.JTF_TERRITORY_PVT dependencies on JTF_TERRITORY_PVT

Line 1: Package BODY JTF_TERRITORY_PVT AS

1: Package BODY JTF_TERRITORY_PVT AS
2: /* $Header: jtfvterb.pls 120.3 2005/10/14 16:12:30 shli ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TERRITORY_PVT

2: /* $Header: jtfvterb.pls 120.3 2005/10/14 16:12:30 shli ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TERRITORY_PVT
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- Joint task force core territory manager private api's.
10: -- This package is defins all private API for manupulating

Line 69: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERRITORY_PVT';

65:
66: -- ***************************************************
67: -- GLOBAL VARIABLES
68: -- ***************************************************
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;

Line 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);

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
6820: IF (p_copy_hierarchy_flag = 'Y') THEN
6821:

Line 8139: --dbms_output('JTF_TERRITORY_PVT:gen_dupliacte_territory: - BEGIN');

8135: /* ======================*/
8136:
8137: /* (validation procedures not necessary) */
8138:
8139: --dbms_output('JTF_TERRITORY_PVT:gen_dupliacte_territory: - BEGIN');
8140: -- get table of terr usages and terr qual type usages for the source territory
8141: initialise( p_copy_source_terr_id -- input TERR_ID
8142: , l_copy_source_terr_rec -- output desc
8143: , l_num_gen_terr -- output (irrelevant)

Line 8161: --dbms_output('JTF_TERRITORY_PVT:gen_dupliacte_territory: - END');

8157: create_new_terr_qtype_usgs(l_new_terr_id, l_tmpl_qtype_usgs_tbl);
8158:
8159: /* for all qualifier values */
8160: insert_copied_qual_values(p_copy_source_terr_id, l_new_terr_id);
8161: --dbms_output('JTF_TERRITORY_PVT:gen_dupliacte_territory: - END');
8162:
8163: /* START: 09/17/00 - JDOCHERT */
8164: IF (p_copy_rsc_flag = 'Y') THEN
8165:

Line 8188: JTF_TERRITORY_PVT.Copy_Territory (

8184: loop
8185:
8186: --p_new_terr_rec.parent_territory_id := l_new_terr_id;
8187:
8188: JTF_TERRITORY_PVT.Copy_Territory (
8189: p_Api_Version_Number => p_Api_Version_Number,
8190: p_Init_Msg_List => p_Init_Msg_List,
8191: p_Commit => p_Commit,
8192: p_validation_level => p_validation_level,

Line 8811: l_terr_rec JTF_TERRITORY_PVT.TERR_ALL_REC_TYPE;

8807: p_debug_flag IN VARCHAR2 := 'N',
8808: p_sql_trace IN VARCHAR2 := 'N' ) AS
8809:
8810: /* local record variables */
8811: l_terr_rec JTF_TERRITORY_PVT.TERR_ALL_REC_TYPE;
8812:
8813: /* local item variables */
8814: l_terr_id NUMBER;
8815: l_hier_terr_count NUMBER;

Line 8902: JTF_TERRITORY_PVT.Copy_Territory (

8898: l_terr_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
8899: l_terr_rec.ORG_ID := FND_API.G_MISS_NUM;
8900: l_terr_rec.NUM_WINNERS := FND_API.G_MISS_NUM;
8901:
8902: JTF_TERRITORY_PVT.Copy_Territory (
8903: p_Api_Version_Number => l_Api_Version_Number,
8904: p_Init_Msg_List => FND_API.G_TRUE,
8905: p_Commit => FND_API.G_TRUE,
8906: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 9243: END JTF_TERRITORY_PVT;

9239: END get_terr_value_desc;
9240:
9241:
9242: -- Package Body
9243: END JTF_TERRITORY_PVT;