DBA Data[Home] [Help]

APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_TERRITORY_RESOURCE_PVT

Line 1: Package Body JTF_TERRITORY_RESOURCE_PVT AS

1: Package Body JTF_TERRITORY_RESOURCE_PVT AS
2: /* $Header: jtfvtrsb.pls 120.4 2006/05/24 08:13:52 chchandr ship $ */
3:
4:
5: -- ---------------------------------------------------

Line 8: -- PACKAGE NAME: JTF_TERRITORY_RESOURCE_PVT

4:
5: -- ---------------------------------------------------
6: -- Start of Comments
7: -- ---------------------------------------------------
8: -- PACKAGE NAME: JTF_TERRITORY_RESOURCE_PVT
9: -- ---------------------------------------------------
10: -- PURPOSE
11: -- Joint task force core territory resource private api's.
12: -- This package is a private API for inserting territory

Line 73: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERRITORY_RESOURCE_PVT';

69:
70: -- ***************************************************
71: -- GLOBAL VARIABLES
72: -- ***************************************************
73: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TERRITORY_RESOURCE_PVT';
74: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvtrsb.pls';
75:
76:
77: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;

Line 4087: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_Interest_Type(l_Record => l_record);

4083: -- --dbms_output.put_line( '[1] Inside the VALUES loop - '|| l_Record.DISPLAY_TYPE);
4084: -- Do all the special processing for for interest Category/Primary Intererst/ Secondary types
4085: IF l_Record.DISPLAY_TYPE = 'INTEREST_TYPE' Then
4086: --dbms_output.put_line( 'Inside first if interest_type');
4087: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_Interest_Type(l_Record => l_record);
4088: -- This display type is only for resource qualifer (competence/competence level)
4089: ELSIf l_Record.DISPLAY_TYPE = 'COMPETENCE' Then
4090: --dbms_output.put_line( 'Inside first if competence');
4091: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_COMPETENCE(l_Record => l_record);

Line 4091: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_COMPETENCE(l_Record => l_record);

4087: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_Interest_Type(l_Record => l_record);
4088: -- This display type is only for resource qualifer (competence/competence level)
4089: ELSIf l_Record.DISPLAY_TYPE = 'COMPETENCE' Then
4090: --dbms_output.put_line( 'Inside first if competence');
4091: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_COMPETENCE(l_Record => l_record);
4092: ELSIf l_Record.DISPLAY_TYPE = 'NUMERIC' Then
4093: --dbms_output.put_line( 'Inside char number if');
4094: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_NUMERIC(l_Record => l_record);
4095: ELSIf l_Record.DISPLAY_TYPE like 'CHAR' Then

Line 4094: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_NUMERIC(l_Record => l_record);

4090: --dbms_output.put_line( 'Inside first if competence');
4091: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_COMPETENCE(l_Record => l_record);
4092: ELSIf l_Record.DISPLAY_TYPE = 'NUMERIC' Then
4093: --dbms_output.put_line( 'Inside char number if');
4094: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_NUMERIC(l_Record => l_record);
4095: ELSIf l_Record.DISPLAY_TYPE like 'CHAR' Then
4096: --dbms_output.put_line( 'Inside char number if');
4097: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_CHAR(l_Record => l_record);
4098: ELSIf l_Record.DISPLAY_TYPE = 'SPECIAL_FUNCTION' Then

Line 4097: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_CHAR(l_Record => l_record);

4093: --dbms_output.put_line( 'Inside char number if');
4094: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_NUMERIC(l_Record => l_record);
4095: ELSIf l_Record.DISPLAY_TYPE like 'CHAR' Then
4096: --dbms_output.put_line( 'Inside char number if');
4097: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_CHAR(l_Record => l_record);
4098: ELSIf l_Record.DISPLAY_TYPE = 'SPECIAL_FUNCTION' Then
4099: -- Need to add this
4100: null;
4101: ELSIF l_Record.DISPLAY_TYPE = 'CURRENCY' Then

Line 4102: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_CURRENCY(l_Record => l_record);

4098: ELSIf l_Record.DISPLAY_TYPE = 'SPECIAL_FUNCTION' Then
4099: -- Need to add this
4100: null;
4101: ELSIF l_Record.DISPLAY_TYPE = 'CURRENCY' Then
4102: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_CURRENCY(l_Record => l_record);
4103: End If;
4104: --
4105: l_Expr_Tbl(l_Expr_Pointer) := v_Temp;
4106:

Line 4608: JTF_TERRITORY_RESOURCE_PVT.Create_Terr_Resource

4604: l_TerrRsc_rec.terr_id := p_dest_terr_id;
4605:
4606: EXIT WHEN csr_rsc_all%NOTFOUND;
4607:
4608: JTF_TERRITORY_RESOURCE_PVT.Create_Terr_Resource
4609: (
4610: p_TerrRsc_Rec => l_TerrRsc_rec,
4611: p_Api_Version_Number => l_api_version_number,
4612: p_Init_Msg_List => NULL,

Line 4655: JTF_TERRITORY_RESOURCE_PVT.Create_Resource_Access

4651: EXIT WHEN csr_rsc_access_all%NOTFOUND;
4652:
4653: --dbms_output.put_line('Terr Resource ID : '||l_TerrRsc_Access_rec.terr_rsc_id);
4654:
4655: JTF_TERRITORY_RESOURCE_PVT.Create_Resource_Access
4656: (
4657: p_TerrRsc_Id => l_dest_terr_rsc_id,
4658: p_TerrRsc_Access_Rec => l_TerrRsc_Access_rec,
4659: p_Api_Version_Number => l_api_version_number,

Line 5222: END JTF_TERRITORY_RESOURCE_PVT;

5218: END IF;
5219:
5220: END Transfer_Resource_Territories;
5221:
5222: END JTF_TERRITORY_RESOURCE_PVT;