APPS.QP_FNA_UTIL dependencies on QP_SOURCESYSTEM_FNAREA_MAP

Line 770: UPDATE QP_SOURCESYSTEM_FNAREA_MAP

766: )
767: IS
768: BEGIN
769:
770: UPDATE QP_SOURCESYSTEM_FNAREA_MAP
771: SET ATTRIBUTE1 = p_FNA_rec.attribute1
772: , ATTRIBUTE10 = p_FNA_rec.attribute10
773: , ATTRIBUTE11 = p_FNA_rec.attribute11
774: , ATTRIBUTE12 = p_FNA_rec.attribute12

Line 828: INSERT INTO QP_SOURCESYSTEM_FNAREA_MAP

824: )
825: IS
826: BEGIN
827:
828: INSERT INTO QP_SOURCESYSTEM_FNAREA_MAP
829: ( ATTRIBUTE1
830: , ATTRIBUTE10
831: , ATTRIBUTE11
832: , ATTRIBUTE12

Line 917: DELETE FROM QP_SOURCESYSTEM_FNAREA_MAP

913: )
914: IS
915: BEGIN
916:
917: DELETE FROM QP_SOURCESYSTEM_FNAREA_MAP
918: WHERE PTE_SOURCESYSTEM_FNAREA_ID = p_pte_sourcesystem_fnarea_id
919: ;
920:
921: EXCEPTION

Line 996: FROM QP_SOURCESYSTEM_FNAREA_MAP

992: , PTE_SOURCESYSTEM_FNAREA_ID
993: , PTE_SOURCE_SYSTEM_ID
994: , REQUEST_ID
995: , SEEDED_FLAG
996: FROM QP_SOURCESYSTEM_FNAREA_MAP
997: WHERE ( PTE_SOURCESYSTEM_FNAREA_ID = p_pte_sourcesystem_fnarea_id
998: )
999: OR ( PTE_SOURCE_SYSTEM_ID = p_pte_source_system_id
1000: );

Line 1175: FROM QP_SOURCESYSTEM_FNAREA_MAP

1171: , l_FNA_rec.pte_sourcesystem_fnarea_id
1172: , l_FNA_rec.pte_source_system_id
1173: , l_FNA_rec.request_id
1174: , l_FNA_rec.seeded_flag
1175: FROM QP_SOURCESYSTEM_FNAREA_MAP
1176: WHERE PTE_SOURCESYSTEM_FNAREA_ID = p_FNA_rec.pte_sourcesystem_fnarea_id
1177: FOR UPDATE NOWAIT;
1178:
1179: -- Row locked. Compare IN attributes to DB attributes.