APPS.PSP_GENERAL dependencies on GMS_INSTALL

Line 956: p_pa_gms_install_options OUT NOCOPY VARCHAR2) IS

952: PROCEDURE MULTIORG_CLIENT_INFO(
953: p_gl_set_of_bks_id OUT NOCOPY NUMBER,
954: p_business_group_id OUT NOCOPY NUMBER,
955: p_operating_unit OUT NOCOPY NUMBER,
956: p_pa_gms_install_options OUT NOCOPY VARCHAR2) IS
957:
958: l_pa_install NUMBER := 0;
959: l_gms_install NUMBER := 0;
960:

Line 959: l_gms_install NUMBER := 0;

955: p_operating_unit OUT NOCOPY NUMBER,
956: p_pa_gms_install_options OUT NOCOPY VARCHAR2) IS
957:
958: l_pa_install NUMBER := 0;
959: l_gms_install NUMBER := 0;
960:
961: begin
962: fnd_profile.get('GL_SET_OF_BKS_ID', p_gl_set_of_bks_id);
963:

Line 990: -- if (gms_install.site_enabled) then

986: or ( mo_global.get_current_org_id is NOT NULL and p.org_id = mo_global.get_current_org_id ));
987: -- --dbms_output.put_line('l_pa_install is ' || to_char(l_pa_install));
988:
989: if (l_pa_install > 0) then
990: -- if (gms_install.site_enabled) then
991:
992: -- Commented for Bug 5498280: MOAC changes
993: /*
994: -- Check if Multi-Org is implemented for the ORG_ID..

Line 998: if (gms_install.enabled(p_operating_unit)) then

994: -- Check if Multi-Org is implemented for the ORG_ID..
995: -- If p_operating_unit added by Neerav for Bug 1538262
996: if p_operating_unit is NOT NULL then
997:
998: if (gms_install.enabled(p_operating_unit)) then
999: l_gms_install := 1;
1000: else
1001: l_gms_install := 0;
1002: end if;

Line 999: l_gms_install := 1;

995: -- If p_operating_unit added by Neerav for Bug 1538262
996: if p_operating_unit is NOT NULL then
997:
998: if (gms_install.enabled(p_operating_unit)) then
999: l_gms_install := 1;
1000: else
1001: l_gms_install := 0;
1002: end if;
1003:

Line 1001: l_gms_install := 0;

997:
998: if (gms_install.enabled(p_operating_unit)) then
999: l_gms_install := 1;
1000: else
1001: l_gms_install := 0;
1002: end if;
1003:
1004: else
1005: */

Line 1006: if (gms_install.enabled) then

1002: end if;
1003:
1004: else
1005: */
1006: if (gms_install.enabled) then
1007: l_gms_install := 1;
1008: else
1009: l_gms_install := 0;
1010: end if;

Line 1007: l_gms_install := 1;

1003:
1004: else
1005: */
1006: if (gms_install.enabled) then
1007: l_gms_install := 1;
1008: else
1009: l_gms_install := 0;
1010: end if;
1011: -- end if;

Line 1009: l_gms_install := 0;

1005: */
1006: if (gms_install.enabled) then
1007: l_gms_install := 1;
1008: else
1009: l_gms_install := 0;
1010: end if;
1011: -- end if;
1012:
1013:

Line 1016: -- --dbms_output.put_line('l_gms_install is ' || to_char(l_gms_install));

1012:
1013:
1014: end if;
1015:
1016: -- --dbms_output.put_line('l_gms_install is ' || to_char(l_gms_install));
1017:
1018: if (l_pa_install > 0) and (l_gms_install > 0) then
1019: p_pa_gms_install_options := 'PA_GMS';
1020: elsif (l_pa_install > 0) and (l_gms_install = 0) then

Line 1018: if (l_pa_install > 0) and (l_gms_install > 0) then

1014: end if;
1015:
1016: -- --dbms_output.put_line('l_gms_install is ' || to_char(l_gms_install));
1017:
1018: if (l_pa_install > 0) and (l_gms_install > 0) then
1019: p_pa_gms_install_options := 'PA_GMS';
1020: elsif (l_pa_install > 0) and (l_gms_install = 0) then
1021: p_pa_gms_install_options := 'PA_ONLY';
1022: else

Line 1019: p_pa_gms_install_options := 'PA_GMS';

1015:
1016: -- --dbms_output.put_line('l_gms_install is ' || to_char(l_gms_install));
1017:
1018: if (l_pa_install > 0) and (l_gms_install > 0) then
1019: p_pa_gms_install_options := 'PA_GMS';
1020: elsif (l_pa_install > 0) and (l_gms_install = 0) then
1021: p_pa_gms_install_options := 'PA_ONLY';
1022: else
1023: p_pa_gms_install_options := 'NO_PA_GMS';

Line 1020: elsif (l_pa_install > 0) and (l_gms_install = 0) then

1016: -- --dbms_output.put_line('l_gms_install is ' || to_char(l_gms_install));
1017:
1018: if (l_pa_install > 0) and (l_gms_install > 0) then
1019: p_pa_gms_install_options := 'PA_GMS';
1020: elsif (l_pa_install > 0) and (l_gms_install = 0) then
1021: p_pa_gms_install_options := 'PA_ONLY';
1022: else
1023: p_pa_gms_install_options := 'NO_PA_GMS';
1024: end if;

Line 1021: p_pa_gms_install_options := 'PA_ONLY';

1017:
1018: if (l_pa_install > 0) and (l_gms_install > 0) then
1019: p_pa_gms_install_options := 'PA_GMS';
1020: elsif (l_pa_install > 0) and (l_gms_install = 0) then
1021: p_pa_gms_install_options := 'PA_ONLY';
1022: else
1023: p_pa_gms_install_options := 'NO_PA_GMS';
1024: end if;
1025:

Line 1023: p_pa_gms_install_options := 'NO_PA_GMS';

1019: p_pa_gms_install_options := 'PA_GMS';
1020: elsif (l_pa_install > 0) and (l_gms_install = 0) then
1021: p_pa_gms_install_options := 'PA_ONLY';
1022: else
1023: p_pa_gms_install_options := 'NO_PA_GMS';
1024: end if;
1025:
1026: exception
1027: WHEN OTHERS THEN