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

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

Line: 204


SELECT distinct category_id
FROM     PA_FP_OF_WEBADI_V;

Line: 208


SELECT distinct Other_Organization_Id
FROM   PA_FP_OF_WEBADI_V
Where  category_id = l_category_id;

Line: 213


SELECT

Category_id,
Category,
OU_id,
OU_name,
Organization_Id,
Organization_Name,
Other_OU_Id,
Other_OU_Name,
Other_Organization_Id,
Other_Organization_Name,
Txn_Project_Name,
Resource_Name,
Period1,
Period2,
Period3,
Period4,
Period5,
Period6,
Period7,
Period8,
Period9,
Period10,
Period11,
Period12,
Period13,
Period14,
Period15,
Period16,
Period17,
Period18,
Period19,
Period20,
Period21,
Period22,
Period23,
Period24,
Period25,
Period26,
Period27,
Period28,
Period29,
Period30,
Period31,
Period32,
Period33,
Period34,
Period35,
Period36,
Period37,
Period38,
Period39,
Period40,
Period41,
Period42,
Period43,
Period44,
Period45,
Period46,
Period47,
Period48,
Period49,
Period50,
Period51,
Period52
FROM  PA_FP_OF_WEBADI_V
Where Category_id = l_category_id
  and Other_Organization_Id =l_other_org_id;

Line: 293


delete from pa_fp_of_webadi_xface
where session_id = l_session_id
  and amount_type_code = l_amount_type_code;

Line: 410


        INSERT INTO  pa_fp_of_webadi_xface
               (Session_id,
                budget_version_id,
                amount_type_code,
                Category_id,
                Category,
                org_id,
                Other_Organization_Name,
                Project_Name,
                Resource_Name,
                Prd1,
                Prd2,
                Prd3,
Prd4,
Prd5,
Prd6,
Prd7,
Prd8,
Prd9,
Prd10,
Prd11,
Prd12,
Prd13,
Prd14,
Prd15,
Prd16,
Prd17,
Prd18,
Prd19,
Prd20,
Prd21,
Prd22,
Prd23,
Prd24,
Prd25,
Prd26,
Prd27,
Prd28,
Prd29,
Prd30,
Prd31,
Prd32,
Prd33,
Prd34,
Prd35,
Prd36,
Prd37,
Prd38,
Prd39,
Prd40,
Prd41,
Prd42,
Prd43,
Prd44,
Prd45,
Prd46,
Prd47,
Prd48,
Prd49,
Prd50,
Prd51,
Prd52)
	VALUES
	       (l_session_id,
                l_budget_version_id,
                l_amount_type_code,
                Category_id_tab(x),
		Category_tab(x),
		OU_id_tab(x),
		Other_Organization_Name_tab(x)||'--'||Other_OU_Name_tab(x),
		Txn_Project_Name_tab(x),
		Resource_Name_tab(x),
		Period1_tab(x),
		Period2_tab(x),
		Period3_tab(x),
Period4_tab(x),
Period5_tab(x),
Period6_tab(x),
Period7_tab(x),
Period8_tab(x),
Period9_tab(x),
Period10_tab(x),
Period11_tab(x),
Period12_tab(x),
Period13_tab(x),
Period14_tab(x),
Period15_tab(x),
Period16_tab(x),
Period17_tab(x),
Period18_tab(x),
Period19_tab(x),
Period20_tab(x),
Period21_tab(x),
Period22_tab(x),
Period23_tab(x),
Period24_tab(x),
Period25_tab(x),
Period26_tab(x),
Period27_tab(x),
Period28_tab(x),
Period29_tab(x),
Period30_tab(x),
Period31_tab(x),
Period32_tab(x),
Period33_tab(x),
Period34_tab(x),
Period35_tab(x),
Period36_tab(x),
Period37_tab(x),
Period38_tab(x),
Period39_tab(x),
Period40_tab(x),
Period41_tab(x),
Period42_tab(x),
Period43_tab(x),
Period44_tab(x),
Period45_tab(x),
Period46_tab(x),
Period47_tab(x),
Period48_tab(x),
Period49_tab(x),
Period50_tab(x),
Period51_tab(x),
Period52_tab(x));

Line: 538


    	select sum(period1),
               sum(period2),
               sum(period3),
               sum(period4),
               sum(period5),
               sum(period6),
               sum(period7),
               sum(period8),
               sum(period9),
               sum(period10),
               sum(period11),
               sum(period12),
               sum(period13),
               sum(period14),
               sum(period15),
               sum(period16),
               sum(period17),
               sum(period18),
               sum(period19),
               sum(period20),
               sum(period21),
               sum(period22),
               sum(period23),
               sum(period24),
               sum(period25),
               sum(period26),
               sum(period27),
               sum(period28),
               sum(period29),
               sum(period30),
               sum(period31),
               sum(period32),
               sum(period33),
               sum(period34),
               sum(period35),
               sum(period36),
               sum(period37),
               sum(period38),
               sum(period39),
               sum(period40),
               sum(period41),
               sum(period42),
               sum(period43),
               sum(period44),
               sum(period45),
               sum(period46),
               sum(period47),
               sum(period48),
               sum(period49),
               sum(period50),
               sum(period51),
               sum(period52)
         into  l_org_tot_period1,
               l_org_tot_period2,
               l_org_tot_period3,
               l_org_tot_period4,
               l_org_tot_period5,
               l_org_tot_period6,
               l_org_tot_period7,
               l_org_tot_period8,
               l_org_tot_period9,
               l_org_tot_period10,
               l_org_tot_period11,
               l_org_tot_period12,
               l_org_tot_period13,
               l_org_tot_period14,
               l_org_tot_period15,
               l_org_tot_period16,
               l_org_tot_period17,
               l_org_tot_period18,
               l_org_tot_period19,
               l_org_tot_period20,
               l_org_tot_period21,
               l_org_tot_period22,
               l_org_tot_period23,
               l_org_tot_period24,
               l_org_tot_period25,
               l_org_tot_period26,
               l_org_tot_period27,
               l_org_tot_period28,
               l_org_tot_period29,
               l_org_tot_period30,
               l_org_tot_period31,
               l_org_tot_period32,
               l_org_tot_period33,
               l_org_tot_period34,
               l_org_tot_period35,
               l_org_tot_period36,
               l_org_tot_period37,
               l_org_tot_period38,
               l_org_tot_period39,
               l_org_tot_period40,
               l_org_tot_period41,
               l_org_tot_period42,
               l_org_tot_period43,
               l_org_tot_period44,
               l_org_tot_period45,
               l_org_tot_period46,
               l_org_tot_period47,
               l_org_tot_period48,
               l_org_tot_period49,
               l_org_tot_period50,
               l_org_tot_period51,
               l_org_tot_period52
         From  PA_FP_OF_WEBADI_V
        Where category_id = l_category_id
          And Other_Organization_Id = l_other_org_id;

Line: 650


   Insert INTO  pa_fp_of_webadi_xface
               (Session_id,
                budget_version_id,
                amount_type_code,
                Category_id,
                Category,
                Other_Organization_Name,
                Prd1,
                Prd2,
                Prd3,
Prd4,
Prd5,
Prd6,
Prd7,
Prd8,
Prd9,
Prd10,
Prd11,
Prd12,
Prd13,
Prd14,
Prd15,
Prd16,
Prd17,
Prd18,
Prd19,
Prd20,
Prd21,
Prd22,
Prd23,
Prd24,
Prd25,
Prd26,
Prd27,
Prd28,
Prd29,
Prd30,
Prd31,
Prd32,
Prd33,
Prd34,
Prd35,
Prd36,
Prd37,
Prd38,
Prd39,
Prd40,
Prd41,
Prd42,
Prd43,
Prd44,
Prd45,
Prd46,
Prd47,
Prd48,
Prd49,
Prd50,
Prd51,
Prd52 )
        VALUES( l_session_id,
                l_budget_version_id,
                l_amount_type_code,
                Category_id_tab(1),
                Category_tab(1),
                Other_Organization_Name_tab(1)||'--'||Other_OU_Name_tab(1)||' Total',
		l_org_tot_period1,
                l_org_tot_period2,
                l_org_tot_period3,
               l_org_tot_period4,
               l_org_tot_period5,
               l_org_tot_period6,
               l_org_tot_period7,
               l_org_tot_period8,
               l_org_tot_period9,
               l_org_tot_period10,
               l_org_tot_period11,
               l_org_tot_period12,
               l_org_tot_period13,
               l_org_tot_period14,
               l_org_tot_period15,
               l_org_tot_period16,
               l_org_tot_period17,
               l_org_tot_period18,
               l_org_tot_period19,
               l_org_tot_period20,
               l_org_tot_period21,
               l_org_tot_period22,
               l_org_tot_period23,
               l_org_tot_period24,
               l_org_tot_period25,
               l_org_tot_period26,
               l_org_tot_period27,
               l_org_tot_period28,
               l_org_tot_period29,
               l_org_tot_period30,
               l_org_tot_period31,
               l_org_tot_period32,
               l_org_tot_period33,
               l_org_tot_period34,
               l_org_tot_period35,
               l_org_tot_period36,
               l_org_tot_period37,
               l_org_tot_period38,
               l_org_tot_period39,
               l_org_tot_period40,
               l_org_tot_period41,
               l_org_tot_period42,
               l_org_tot_period43,
               l_org_tot_period44,
               l_org_tot_period45,
               l_org_tot_period46,
               l_org_tot_period47,
               l_org_tot_period48,
               l_org_tot_period49,
               l_org_tot_period50,
               l_org_tot_period51,
               l_org_tot_period52);

Line: 771


	Category_id_tab.delete;

Line: 772


	Category_tab.delete;

Line: 773


	OU_id_tab.delete;

Line: 774


	OU_name_tab.delete;

Line: 775


	Organization_Id_tab.delete;

Line: 776


	Organization_Name_tab.delete;

Line: 777


	Other_OU_Id_tab.delete;

Line: 778


	Other_OU_Name_tab.delete;

Line: 779


	Other_Organization_Id_tab.delete;

Line: 780


	Other_Organization_Name_tab.delete;

Line: 781


	Txn_Project_Name_tab.delete;

Line: 782


	Resource_Name_tab.delete;

Line: 783


	Period1_tab.delete;

Line: 784


	Period2_tab.delete;

Line: 785


	Period3_tab.delete;

Line: 786


        Period4_tab.delete;

Line: 787


        Period5_tab.delete;

Line: 788


        Period6_tab.delete;

Line: 789


        Period7_tab.delete;

Line: 790


        Period8_tab.delete;

Line: 791


        Period9_tab.delete;

Line: 792


        Period10_tab.delete;

Line: 793


        Period11_tab.delete;

Line: 794


        Period12_tab.delete;

Line: 795


        Period13_tab.delete;

Line: 796


        Period14_tab.delete;

Line: 797


        Period15_tab.delete;

Line: 798


        Period16_tab.delete;

Line: 799


        Period17_tab.delete;

Line: 800


        Period18_tab.delete;

Line: 801


        Period19_tab.delete;

Line: 802


        Period20_tab.delete;

Line: 803


        Period21_tab.delete;

Line: 804


        Period22_tab.delete;

Line: 805


        Period23_tab.delete;

Line: 806


        Period24_tab.delete;

Line: 807


        Period25_tab.delete;

Line: 808


        Period26_tab.delete;

Line: 809


        Period27_tab.delete;

Line: 810


        Period28_tab.delete;

Line: 811


        Period29_tab.delete;

Line: 812


        Period30_tab.delete;

Line: 813


        Period31_tab.delete;

Line: 814


        Period32_tab.delete;

Line: 815


        Period33_tab.delete;

Line: 816


        Period34_tab.delete;

Line: 817


        Period35_tab.delete;

Line: 818


        Period36_tab.delete;

Line: 819


        Period37_tab.delete;

Line: 820


        Period38_tab.delete;

Line: 821


        Period39_tab.delete;

Line: 822


        Period40_tab.delete;

Line: 823


        Period41_tab.delete;

Line: 824


        Period42_tab.delete;

Line: 825


        Period43_tab.delete;

Line: 826


        Period44_tab.delete;

Line: 827


        Period45_tab.delete;

Line: 828


        Period46_tab.delete;

Line: 829


        Period47_tab.delete;

Line: 830


        Period48_tab.delete;

Line: 831


        Period49_tab.delete;

Line: 832


        Period50_tab.delete;

Line: 833


        Period51_tab.delete;

Line: 834


        Period52_tab.delete;

Line: 841


        select sum(period1),
               sum(period2),
               sum(period3),
               sum(period4),
               sum(period5),
               sum(period6),
               sum(period7),
               sum(period8),
               sum(period9),
               sum(period10),
               sum(period11),
               sum(period12),
               sum(period13),
               sum(period14),
               sum(period15),
               sum(period16),
               sum(period17),
               sum(period18),
               sum(period19),
               sum(period20),
               sum(period21),
               sum(period22),
               sum(period23),
               sum(period24),
               sum(period25),
               sum(period26),
               sum(period27),
               sum(period28),
               sum(period29),
               sum(period30),
               sum(period31),
               sum(period32),
               sum(period33),
               sum(period34),
               sum(period35),
               sum(period36),
               sum(period37),
               sum(period38),
               sum(period39),
               sum(period40),
               sum(period41),
               sum(period42),
               sum(period43),
               sum(period44),
               sum(period45),
               sum(period46),
               sum(period47),
               sum(period48),
               sum(period49),
               sum(period50),
               sum(period51),
               sum(period52)
         into  l_cat_tot_period1,
               l_cat_tot_period2,
               l_cat_tot_period3,
               l_cat_tot_period4,
               l_cat_tot_period5,
               l_cat_tot_period6,
               l_cat_tot_period7,
               l_cat_tot_period8,
               l_cat_tot_period9,
               l_cat_tot_period10,
               l_cat_tot_period11,
               l_cat_tot_period12,
               l_cat_tot_period13,
               l_cat_tot_period14,
               l_cat_tot_period15,
               l_cat_tot_period16,
               l_cat_tot_period17,
               l_cat_tot_period18,
               l_cat_tot_period19,
               l_cat_tot_period20,
               l_cat_tot_period21,
               l_cat_tot_period22,
               l_cat_tot_period23,
               l_cat_tot_period24,
               l_cat_tot_period25,
               l_cat_tot_period26,
               l_cat_tot_period27,
               l_cat_tot_period28,
               l_cat_tot_period29,
               l_cat_tot_period30,
               l_cat_tot_period31,
               l_cat_tot_period32,
               l_cat_tot_period33,
               l_cat_tot_period34,
               l_cat_tot_period35,
               l_cat_tot_period36,
               l_cat_tot_period37,
               l_cat_tot_period38,
               l_cat_tot_period39,
               l_cat_tot_period40,
               l_cat_tot_period41,
               l_cat_tot_period42,
               l_cat_tot_period43,
               l_cat_tot_period44,
               l_cat_tot_period45,
               l_cat_tot_period46,
               l_cat_tot_period47,
               l_cat_tot_period48,
               l_cat_tot_period49,
               l_cat_tot_period50,
               l_cat_tot_period51,
               l_cat_tot_period52
         From  PA_FP_OF_WEBADI_V
        Where category_id = l_category_id;

Line: 951


   Insert INTO  pa_fp_of_webadi_xface
               (Session_id,
                budget_version_id,
                amount_type_code,
                category_id,
                category,
                Prd1,
                Prd2,
                Prd3,
Prd4,
Prd5,
Prd6,
Prd7,
Prd8,
Prd9,
Prd10,
Prd11,
Prd12,
Prd13,
Prd14,
Prd15,
Prd16,
Prd17,
Prd18,
Prd19,
Prd20,
Prd21,
Prd22,
Prd23,
Prd24,
Prd25,
Prd26,
Prd27,
Prd28,
Prd29,
Prd30,
Prd31,
Prd32,
Prd33,
Prd34,
Prd35,
Prd36,
Prd37,
Prd38,
Prd39,
Prd40,
Prd41,
Prd42,
Prd43,
Prd44,
Prd45,
Prd46,
Prd47,
Prd48,
Prd49,
Prd50,
Prd51,
Prd52)
        VALUES( l_session_id,
                l_budget_version_id,
                l_amount_type_code,
                ll_category_id,
                l_category_name||' Total',
                l_cat_tot_period1,
                l_cat_tot_period2,
                l_cat_tot_period3,
               l_cat_tot_period4,
               l_cat_tot_period5,
               l_cat_tot_period6,
               l_cat_tot_period7,
               l_cat_tot_period8,
               l_cat_tot_period9,
               l_cat_tot_period10,
               l_cat_tot_period11,
               l_cat_tot_period12,
               l_cat_tot_period13,
               l_cat_tot_period14,
               l_cat_tot_period15,
               l_cat_tot_period16,
               l_cat_tot_period17,
               l_cat_tot_period18,
               l_cat_tot_period19,
               l_cat_tot_period20,
               l_cat_tot_period21,
               l_cat_tot_period22,
               l_cat_tot_period23,
               l_cat_tot_period24,
               l_cat_tot_period25,
               l_cat_tot_period26,
               l_cat_tot_period27,
               l_cat_tot_period28,
               l_cat_tot_period29,
               l_cat_tot_period30,
               l_cat_tot_period31,
               l_cat_tot_period32,
               l_cat_tot_period33,
               l_cat_tot_period34,
               l_cat_tot_period35,
               l_cat_tot_period36,
               l_cat_tot_period37,
               l_cat_tot_period38,
               l_cat_tot_period39,
               l_cat_tot_period40,
               l_cat_tot_period41,
               l_cat_tot_period42,
               l_cat_tot_period43,
               l_cat_tot_period44,
               l_cat_tot_period45,
               l_cat_tot_period46,
               l_cat_tot_period47,
               l_cat_tot_period48,
               l_cat_tot_period49,
               l_cat_tot_period50,
               l_cat_tot_period51,
               l_cat_tot_period52);