APPS.QP_SSC_UTIL dependencies on QP_PTE_SOURCE_SYSTEMS

Line 704: UPDATE QP_PTE_SOURCE_SYSTEMS

700: )
701: IS
702: BEGIN
703:
704: UPDATE QP_PTE_SOURCE_SYSTEMS
705: SET APPLICATION_SHORT_NAME = p_SSC_rec.application_short_name
706: , ATTRIBUTE1 = p_SSC_rec.attribute1
707: , ATTRIBUTE10 = p_SSC_rec.attribute10
708: , ATTRIBUTE11 = p_SSC_rec.attribute11

Line 760: INSERT INTO QP_PTE_SOURCE_SYSTEMS

756: )
757: IS
758: BEGIN
759:
760: INSERT INTO QP_PTE_SOURCE_SYSTEMS
761: ( APPLICATION_SHORT_NAME
762: , ATTRIBUTE1
763: , ATTRIBUTE10
764: , ATTRIBUTE11

Line 845: DELETE FROM QP_PTE_SOURCE_SYSTEMS

841: )
842: IS
843: BEGIN
844:
845: DELETE FROM QP_PTE_SOURCE_SYSTEMS
846: WHERE PTE_SOURCE_SYSTEM_ID = p_pte_source_system_id
847: ;
848:
849: EXCEPTION

Line 922: FROM QP_PTE_SOURCE_SYSTEMS

918: , PROGRAM_ID
919: , PROGRAM_UPDATE_DATE
920: , PTE_CODE
921: , PTE_SOURCE_SYSTEM_ID
922: FROM QP_PTE_SOURCE_SYSTEMS
923: WHERE ( PTE_SOURCE_SYSTEM_ID = p_pte_source_system_id
924: )
925: --**OR ( LOOKUP_CODE = p_lookup_code
926: OR ( PTE_CODE = p_lookup_code

Line 1097: FROM QP_PTE_SOURCE_SYSTEMS

1093: , l_SSC_rec.program_id
1094: , l_SSC_rec.program_update_date
1095: , l_SSC_rec.pte_code
1096: , l_SSC_rec.pte_source_system_id
1097: FROM QP_PTE_SOURCE_SYSTEMS
1098: WHERE PTE_SOURCE_SYSTEM_ID = p_SSC_rec.pte_source_system_id
1099: FOR UPDATE NOWAIT;
1100:
1101: -- Row locked. Compare IN attributes to DB attributes.