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.OKS_REV_DISTR_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13


    g_rdsv_rec.last_updated_by       := p_rdsv_rec.last_updated_by;

Line: 14


    g_rdsv_rec.last_update_date      := p_rdsv_rec.last_update_date;

Line: 19


procedure Insert_Revenue_Distr(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_rdsv_rec	IN	rdsv_rec_type,
                              x_rdsv_rec	OUT NOCOPY	rdsv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'Insert_Revenue_Distr';

Line: 98


end Insert_Revenue_Distr;

Line: 100


procedure Insert_Revenue_Distr(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_rdsv_tbl	IN	rdsv_tbl_type,
                              x_rdsv_tbl	OUT NOCOPY	rdsv_tbl_type) is
i NUMBER;

Line: 115


	    Insert_Revenue_Distr(p_api_version=>p_api_version,
                              p_init_msg_list=>OKC_API.G_FALSE,
                              x_return_status=>l_return_status,
                              x_msg_count=>x_msg_count,
                              x_msg_data=>x_msg_data,
                              p_rdsv_rec=>p_rdsv_tbl(i),
                              x_rdsv_rec=>x_rdsv_tbl(i));

Line: 134


end Insert_Revenue_Distr;

Line: 136


procedure update_Revenue_Distr(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_rdsv_rec	IN	rdsv_rec_type,
                              x_rdsv_rec	OUT NOCOPY	rdsv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'update_Revenue_Distr';

Line: 167


  OKS_REV_DISTR_PVT.update_Revenue_Distr(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_rdsv_rec,
                              x_rdsv_rec);

Line: 215


end update_Revenue_Distr;

Line: 217


procedure update_Revenue_Distr(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_rdsv_tbl	IN	rdsv_tbl_type,
                              x_rdsv_tbl	OUT NOCOPY	rdsv_tbl_type) is
i NUMBER;

Line: 232


	    update_Revenue_Distr(p_api_version=>p_api_version,
                              p_init_msg_list=>OKC_API.G_FALSE,
                              x_return_status=>l_return_status,
                              x_msg_count=>x_msg_count,
                              x_msg_data=>x_msg_data,
                              p_rdsv_rec=>p_rdsv_tbl(i),
                              x_rdsv_rec=>x_rdsv_tbl(i));

Line: 251


end update_Revenue_Distr;

Line: 253


procedure delete_Revenue_Distr(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_rdsv_rec	IN	rdsv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'delete_Revenue_Distr';

Line: 283


  OKS_REV_DISTR_PVT.delete_Revenue_Distr(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_rdsv_rec);

Line: 329


end delete_Revenue_Distr;

Line: 331


procedure delete_Revenue_Distr(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              x_return_status	OUT NOCOPY	VARCHAR2,
                              x_msg_count	OUT NOCOPY	NUMBER,
                              x_msg_data	OUT NOCOPY	VARCHAR2,
                              p_rdsv_tbl	IN	rdsv_tbl_type) is
i NUMBER;

Line: 345


	    delete_Revenue_Distr(p_api_version=>p_api_version,
                              p_init_msg_list=>OKC_API.G_FALSE,
                              x_return_status=>l_return_status,
                              x_msg_count=>x_msg_count,
                              x_msg_data=>x_msg_data,
                              p_rdsv_rec=>p_rdsv_tbl(i));

Line: 363


end delete_Revenue_Distr;

Line: 625


   SELECT GSOB.CHART_OF_ACCOUNTS_ID
   FROM HR_ORGANIZATION_UNITS HOU
       ,MTL_PARAMETERS MP
       --,FND_PRODUCT_GROUPS
       ,GL_SETS_OF_BOOKS GSOB
       ,HR_ORGANIZATION_INFORMATION HOI2
   WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
     AND EXISTS ( SELECT 1
                   FROM HR_ORGANIZATION_INFORMATION HOI1
                   WHERE HOI1.ORGANIZATION_ID = HOU.ORGANIZATION_ID
                     AND HOI1.ORG_INFORMATION1 = 'INV'
                     AND HOI1.ORG_INFORMATION2 = 'Y'
                     AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS')
       AND HOI2.ORGANIZATION_ID = HOU.ORGANIZATION_ID
       AND ( HOI2.ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
       AND  TO_NUMBER(HOI2.ORG_INFORMATION1) =  GSOB.SET_OF_BOOKS_ID
       AND HOU.ORGANIZATION_ID = P_ORG_ID;

Line: 646


    select CONCATENATED_SEGMENT_DELIMITER
    from fnd_id_flex_structures_vl
    where APPLICATION_ID = 101
    and ID_FLEX_CODE     = 'GL#'
    and ID_FLEX_NUM      = l_chart_id;

Line: 653


    select APPLICATION_COLUMN_NAME
    from fnd_id_flex_segments_vl
    where APPLICATION_ID = 101
    and   ID_FLEX_CODE   = 'GL#'
    and   ID_FLEX_NUM    = l_chart_id
    order by SEGMENT_NUM;

Line: 664


  l_select_stmt    Varchar2(4000);

Line: 695


  l_select_stmt := 'Select ' || l_sel_column ||
                   ' From Gl_Code_combinations Where Code_Combination_Id = ' || p_id;

Line: 698


  EXECUTE IMMEDIATE l_select_stmt into l_return;