DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_RESOURCE_SETUPS_S

Line 33144: TYPE SetupCode IS TABLE OF MSC_ST_RESOURCE_SETUPS.SETUP_CODE%TYPE INDEX BY BINARY_INTEGER;

33140: --bug 8310366 Validation of all columns for the RESOURCE_SETUP entity (SDS Changes)
33141:
33142: PROCEDURE LOAD_RESOURCE_SETUPS IS
33143: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
33144: TYPE SetupCode IS TABLE OF MSC_ST_RESOURCE_SETUPS.SETUP_CODE%TYPE INDEX BY BINARY_INTEGER;
33145: TYPE OrganizationCode is TABLE OF MSC_ST_RESOURCE_SETUPS.ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
33146: TYPE CompanyName is TABLE OF MSC_ST_RESOURCE_SETUPS.COMPANY_NAME%TYPE INDEX BY BINARY_INTEGER;
33147: TYPE CurTyp IS REF CURSOR;
33148: c1 CurTyp;

Line 33384: SET setup_id = msc_st_resource_setups_s.NEXTVAL

33380: IF c3%ROWCOUNT > 0 THEN
33381:
33382: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33383: UPDATE msc_st_resource_setups
33384: SET setup_id = msc_st_resource_setups_s.NEXTVAL
33385: WHERE rowid = lb_rowid(j);
33386:
33387: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33388: UPDATE msc_st_resource_setups