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.12 2008/06/18 09:46:52 vpalle ship $ */
3:
4: -- ---------------------------------------------------
5: -- Start of Comments

Line 7: -- PACKAGE NAME: JTF_TERRITORY_RESOURCE_PVT

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

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

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

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

3938: -- --dbms_output.put_line( '[1] Inside the VALUES loop - '|| l_Record.DISPLAY_TYPE);
3939: -- Do all the special processing for for interest Category/Primary Intererst/ Secondary types
3940: IF l_Record.DISPLAY_TYPE = 'INTEREST_TYPE' Then
3941: --dbms_output.put_line( 'Inside first if interest_type');
3942: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_Interest_Type(l_Record => l_record);
3943: -- This display type is only for resource qualifer (competence/competence level)
3944: ELSIf l_Record.DISPLAY_TYPE = 'COMPETENCE' Then
3945: --dbms_output.put_line( 'Inside first if competence');
3946: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_COMPETENCE(l_Record => l_record);

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

3942: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_Interest_Type(l_Record => l_record);
3943: -- This display type is only for resource qualifer (competence/competence level)
3944: ELSIf l_Record.DISPLAY_TYPE = 'COMPETENCE' Then
3945: --dbms_output.put_line( 'Inside first if competence');
3946: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_COMPETENCE(l_Record => l_record);
3947: ELSIf l_Record.DISPLAY_TYPE = 'NUMERIC' Then
3948: --dbms_output.put_line( 'Inside char number if');
3949: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_NUMERIC(l_Record => l_record);
3950: ELSIf l_Record.DISPLAY_TYPE like 'CHAR' Then

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

3945: --dbms_output.put_line( 'Inside first if competence');
3946: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_COMPETENCE(l_Record => l_record);
3947: ELSIf l_Record.DISPLAY_TYPE = 'NUMERIC' Then
3948: --dbms_output.put_line( 'Inside char number if');
3949: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_NUMERIC(l_Record => l_record);
3950: ELSIf l_Record.DISPLAY_TYPE like 'CHAR' Then
3951: --dbms_output.put_line( 'Inside char number if');
3952: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_CHAR(l_Record => l_record);
3953: ELSIf l_Record.DISPLAY_TYPE = 'SPECIAL_FUNCTION' Then

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

3948: --dbms_output.put_line( 'Inside char number if');
3949: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_NUMERIC(l_Record => l_record);
3950: ELSIf l_Record.DISPLAY_TYPE like 'CHAR' Then
3951: --dbms_output.put_line( 'Inside char number if');
3952: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_CHAR(l_Record => l_record);
3953: ELSIf l_Record.DISPLAY_TYPE = 'SPECIAL_FUNCTION' Then
3954: -- Need to add this
3955: null;
3956: ELSIF l_Record.DISPLAY_TYPE = 'CURRENCY' Then

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

3953: ELSIf l_Record.DISPLAY_TYPE = 'SPECIAL_FUNCTION' Then
3954: -- Need to add this
3955: null;
3956: ELSIF l_Record.DISPLAY_TYPE = 'CURRENCY' Then
3957: v_Temp := JTF_TERRITORY_RESOURCE_PVT.Get_Expression_CURRENCY(l_Record => l_record);
3958: End If;
3959: --
3960: l_Expr_Tbl(l_Expr_Pointer) := v_Temp;
3961:

Line 4463: JTF_TERRITORY_RESOURCE_PVT.Create_Terr_Resource

4459: l_TerrRsc_rec.terr_id := p_dest_terr_id;
4460:
4461: EXIT WHEN csr_rsc_all%NOTFOUND;
4462:
4463: JTF_TERRITORY_RESOURCE_PVT.Create_Terr_Resource
4464: (
4465: p_TerrRsc_Rec => l_TerrRsc_rec,
4466: p_Api_Version_Number => l_api_version_number,
4467: p_Init_Msg_List => NULL,

Line 4510: JTF_TERRITORY_RESOURCE_PVT.Create_Resource_Access

4506: EXIT WHEN csr_rsc_access_all%NOTFOUND;
4507:
4508: --dbms_output.put_line('Terr Resource ID : '||l_TerrRsc_Access_rec.terr_rsc_id);
4509:
4510: JTF_TERRITORY_RESOURCE_PVT.Create_Resource_Access
4511: (
4512: p_TerrRsc_Id => l_dest_terr_rsc_id,
4513: p_TerrRsc_Access_Rec => l_TerrRsc_Access_rec,
4514: p_Api_Version_Number => l_api_version_number,

Line 5077: END JTF_TERRITORY_RESOURCE_PVT;

5073: END IF;
5074:
5075: END Transfer_Resource_Territories;
5076:
5077: END JTF_TERRITORY_RESOURCE_PVT;
5078: